ERROR 1044: while setin up mysql

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
greeneel
Forum Commoner
Posts: 47
Joined: Wed Jul 30, 2003 5:19 pm

ERROR 1044: while setin up mysql

Post by greeneel »

hi

I recently installed mysql 3.23.58 on an WinXP Pro System, now part of the instructions said that I should run this command to test whether mysql is workin :
c:\mysql\bin\mysqlshow mysql

When i typed this I got back the following error:
mysqlshow: Access denied for user: '@localhost' to database 'mysql'

I am telling it to show me the tables of the "mysql" database but got this error instead.. I never created a password or anything for mysql, so i can`t figure out why is it that i`m getting this error..

Also added to this I am trying to delete the anonymous User that was created by default from mysql..to do this I typed:
c:\mysql\bin\mysql
This brings up the mysql monitor, now when i type "use mysql"
I get this error:

ERROR 1044: Access denied for user: '@localhost' to database 'mysql'

Is it a password thats stopping me from getting into the mysql database? If so can someone tell me how I can get rid of it so that I can delete the anonymous user?

Thanks In Advance :D
User avatar
scorphus
Forum Regular
Posts: 589
Joined: Fri May 09, 2003 11:53 pm
Location: Belo Horizonte, Brazil
Contact:

Post by scorphus »

These links can help you:

4.2.13 Causes of Access denied Errors
• [google]%22ERROR%201044%22%20%2Bsite:mysql.com[/google]

Cheers,
Scorphus.
User avatar
greeneel
Forum Commoner
Posts: 47
Joined: Wed Jul 30, 2003 5:19 pm

Post by greeneel »

Thx alot
I will check these out..
Post Reply