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:pinkerton.doug@stripped]
Sent: Tuesday, March 14, 2006 1:26 PM
To: mysql@stripped
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/mysql?unsub=1