MySQL on Mac OS X, can't create database
Posted: Tue Aug 17, 2004 4:49 pm
I cannot create the world database. I have the following subdirectories in the mysql directory:
COPYING, INSTALL-BINARY, README, bin, configure, data, docus, include, lib, man, mysql-test, scripts, share, sql-bench,support-files, tests, world.sql
I give the commands:
sudo echo
/usr/local/mysql/bin/mysql and I get the mysql> prompt
Then I issue the command
CREATE DATABASE world;
Then I get what looks like a permissions error:
ERROR 1044: Access denied for user: '@localhost' to database 'world'
mysql> CREATE DATABASE world;
ERROR 1044: Access denied for user: '@localhost' to database 'world
How do I fix the error so I can create the world database?
thanks,
COPYING, INSTALL-BINARY, README, bin, configure, data, docus, include, lib, man, mysql-test, scripts, share, sql-bench,support-files, tests, world.sql
I give the commands:
sudo echo
/usr/local/mysql/bin/mysql and I get the mysql> prompt
Then I issue the command
CREATE DATABASE world;
Then I get what looks like a permissions error:
ERROR 1044: Access denied for user: '@localhost' to database 'world'
mysql> CREATE DATABASE world;
ERROR 1044: Access denied for user: '@localhost' to database 'world
How do I fix the error so I can create the world database?
thanks,