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