MySQL on Mac OS X, can't create database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
jrough
Forum Newbie
Posts: 14
Joined: Thu Jun 10, 2004 5:17 pm

MySQL on Mac OS X, can't create database

Post 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,
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

looks like you aren't logged in as a user..
Draco_03
Forum Regular
Posts: 577
Joined: Fri Aug 15, 2003 12:25 pm
Location: Montreal, Canada

Post by Draco_03 »

try
host : localhost
user : ROOT
password : '' (no password)

try that to log yourself in
Post Reply