Page 1 of 1

MySQL on Mac OS X, can't create database

Posted: Tue Aug 17, 2004 4:49 pm
by jrough
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,

Posted: Tue Aug 17, 2004 4:58 pm
by feyd
looks like you aren't logged in as a user..

Posted: Tue Aug 17, 2004 4:59 pm
by Draco_03
try
host : localhost
user : ROOT
password : '' (no password)

try that to log yourself in