In your conf file, please add : Previously create a temp directory
[mysqld] tmpdir=/usr/local/mysql/temp Regards, Juan On 3/20/07, Lopez, Denise <[EMAIL PROTECTED]> wrote:
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
