Thank you for everyone's suggestions. I did run the flush privileges after creating the user too.
I recently added an iSCSI network drive to my system and copied the databases on the network drive. I mounted the network drive in the same place that the mysql databases previously were located and started up the mysql service. Turns out the way I mounted the drive caused the errors I described. I copied the databases back to the system drive in their old location and restarted the mysql service, then mysql starting behaving like normal again. Now I just need to figure out how to mount the iSCSI drive correctly and get mysql to play nice with it. Thanks again for everyone's suggestions. 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: 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 statement. If you do a direct insert into the user table you have to issue this command. ----- Original Message ----- From: "Lopez, Denise" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Tuesday, March 20, 2007 7:55 PM Subject: RE: Database creation question That still didn't work. I think I just need to restart the mysql service. 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 ________________________________ From: Juan Eduardo 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 user use : mysql> GRANT ALL PRIVILEGES ON DATABASENAME.* TO USERNAME@"%" IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION; Regards, Juan Eduardo On 3/20/07, Lopez, Denise < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: 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 the database. mysql > create database 'database name'; mysql > grant all privileges on 'database_name'.* to [EMAIL PROTECTED] identified by 'password'; These 2 commands finished successfully and when I run the show databases command, my new database shows up. I can exit back to shell prompt and reconnect to mysql with the command above and it still displays the new database. Up to here is what I expected, here's the weird part. With the username and password from above I tried to create a table in my database and received this error: Can't create/write to file '/usr/local/mysql/var/timetrackerdb/mytemp.MYI' I google'd this and the only suggestion was the disk that mysql was trying to write to was out of space. So I checked the space on /usr/local/mysql/var and there is plenty of room on the drive. Come to find out that the database directory didn't get created in the data directory where all the database directories are located. Any ideas why the mysql process didn't create the database directory? I already checked permissions on the /usr/local/mysql root mysql 755 and /usr/local/mysql/var mysql mysql 700. Thanks in advance. 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
