SitePoint Sponsor |
|
User Tag List
Results 1 to 4 of 4
Thread: Error
-
Jun 24, 2004, 09:55 #1
- Join Date
- Jun 2004
- Location
- Sacramento
- Posts
- 8
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Error
I have installed Mysql on my server at work and I am trying to create a database...
at the mysql prompt I type:
mysql>create database jokes;
and get the message:
Error 1044: Access Denied for user: '@localhost' to database 'jokes'
Please let me know how to fix this.
Thank you!
-
Jun 24, 2004, 10:10 #2
- Join Date
- Jun 2004
- Location
- Roaming North America
- Posts
- 220
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
it's a permissions problem. You are logged in as a user that does not have rights to do that operation. See manual: http://dev.mysql.com/doc/mysql/en/Adding_users.html
-
Jun 24, 2004, 10:31 #3
- Join Date
- Jun 2004
- Location
- Sacramento
- Posts
- 8
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
I went to the prompt and typed in
mysql> --user=root mysql;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
received error 1045: Access denied for user: '@localhost' Using password:NO)
Any solutions?
-
Jun 26, 2004, 07:59 #4
- Join Date
- Jun 2004
- Location
- Roaming North America
- Posts
- 220
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Originally Posted by ccc2001
Bookmarks