List:General Discussion« Previous MessageNext Message »
From:Marciano [Intercol] Date:March 14 2006 4:36pm
Subject:RE: Permissions block database creation
View as plain text  
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


Thread
Merge tables.Paul Halliday14 Mar
  • Re: Merge tables.Martijn Tonies14 Mar
  • Re: Merge tables.Prasanna Raj14 Mar
  • Re: Merge tables.Martijn Tonies14 Mar
    • Re: Merge tables.Alec.Cawley14 Mar
    • Re: Merge tables.Paul Halliday14 Mar
      • Re: Merge tables.Alec.Cawley14 Mar
        • Re: Merge tables.nigel wood14 Mar
          • Re: Merge tables.Alec.Cawley14 Mar
          • Permissions block database creationDoug Pinkerton14 Mar
            • RE: Permissions block database creationMarciano [Intercol]14 Mar
            • Re: Permissions block database creationКосов Евгений14 Mar
  • Re: Merge tables.Martijn Tonies14 Mar