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]> 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
