Page 1 of 1

ERROR 1044: while setin up mysql

Posted: Wed Nov 12, 2003 9:39 pm
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

Posted: Wed Nov 12, 2003 10:17 pm
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.

Posted: Wed Nov 12, 2003 11:32 pm
by greeneel
Thx alot
I will check these out..