You need to set GRANTs to create on the host.

http://dev.mysql.com/doc/refman/5.0/en/grant.html


-----Original Message-----
From: Doug Pinkerton [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, March 14, 2006 1:26 PM
To: mysql@lists.mysql.com
Subject: Permissions block database creation

I'm a total newbie working through the tutorial in DuBois's _MySQL_.  
I've got MySQL running on my PowerBook. In Terminal, I can use the  
mysql client to get responses to things like SELECT NOW(). But the  
command CREATE DATABASE sampdb; results in the following error.

ERROR 1044 (42000): Access denied for user ''@'localhost' to database  
'sampdb'
mysql>

I am unable to determine its location, which causes me to suspect  
that it is in the portion of the system not accessible from the  
Finder. Can anyone offer a suggestion?

Mac OS 10.4.5

Thanks,
dp


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to