SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
-
Jul 13, 2002, 16:18 #1
- Join Date
- Jun 2001
- Location
- Melbourne, AU & Seattle, WA
- Posts
- 502
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
ERROR 1044: Access denied for user
I'm on pg 29 of Kevin Yank's book. I'm trying to create the jokes database. At the mysql> prompt I entered:
CREATE DATABASE jokes;
Then, instead of creating the database, it returns this line:
ERROR 1044: Access denied for user: '@localhost' to database 'jokes'
Any clues why or how to fix it? It worked when I was using Win2K and IIS, but since I found out Mac OS X can do this I've started over on that platform.~Dorian
-
Jul 14, 2002, 23:06 #2
- Join Date
- Jun 2001
- Location
- Melbourne, AU & Seattle, WA
- Posts
- 502
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
I don't know if this is the proper way to do this, but I've been messing around and typed:
mysql -u root
Then it let me create the database called jokes.~Dorian
-
Jul 15, 2002, 00:15 #3
- Join Date
- Jun 2002
- Location
- Denver, CO
- Posts
- 18
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
You need to GRANT permissions to the table for the user account you typically use (which shouldn't be root!). I don't know what book you're looking at, but check out chapters on users/permissions.
Bookmarks