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]