RE: Configure options question

2007-04-12 Thread Lopez, Denise
just fine. Denise Lopez UCLA Center for Digital Humanities Network Services Systems Engineer 337 Charles E. Young Drive East PPB 1020 Los Angeles, CA 90095 310/206-8216 -Original Message- From: Jerry Schwartz [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 10:23 AM To: Lopez, Deni

Configure options question

2007-04-12 Thread Lopez, Denise
I have a beginner question for you all. I recently took over a server and would like to determine what configure options were given when MySQL was compiled. Currently the MySQL version is 4.1.10 and I would like to know whether the mysql server was compiled with .png support. Thanks in advance

RE: Privileges question.

2007-04-05 Thread Lopez, Denise
Nevermind, I had a lingering entry in the db table. Once I deleted that it worked as expected. Denise Lopez UCLA Center for Digital Humanities Network Services Systems Engineer 337 Charles E. Young Drive East PPB 1020 Los Angeles, CA 90095 310/206-8216 -Original Message- From: Lopez

Privileges question.

2007-04-05 Thread Lopez, Denise
Hi all, I am trying to create a user with only SELECT,INSERT,UPDATE,DELETE privileges on a database. My question is when I type show grants for the user I create, it says the user has full privileges over the database and I only want them to have the ones listed above. mysql > grant SELECT,INSER

RE: Database creation question

2007-03-22 Thread Lopez, Denise
- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 21, 2007 7:09 AM To: Lopez, Denise; mysql@lists.mysql.com Subject: Re: Database creation question You might try issueing a FLUSH PRIVILEGES command instead of restarting. This is supposed to be implicit when you use the GRANT

RE: Database creation question

2007-03-20 Thread Lopez, Denise
uardo Moreno [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 20, 2007 4:03 PM To: Lopez, Denise Cc: mysql@lists.mysql.com Subject: Re: Database creation question Denise, Hola!. 1) Connect to the system like root user 2) $ chown -R mysql:mysql /usr/local/mysql/ 3) In oder to create use

Database creation question

2007-03-20 Thread Lopez, Denise
Hello everyone, I had a really weird thing happen and I was wondering if anyone has seen anything like this. From a shell command line I connected to a running instance of mysql with the mysql -u root -p command. I successfully get to a mysql prompt. I needed to create a new database and user for