[timorthy]

Hi all,

I'm starting learning AMP. I used cmd.exe to test mysql after installing it, but I face an error following:

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'ODBC@localhost' (using password: NO)'

Can anyone give me a hand? Thank you so much.

[DA Master]

Have you started your server? Use command prompt to run this...

net start mysql

Note: mysql might be different. Try looking in the services window through Services in Administrative Tools.

[dennispopel]

I'm afraid that this is the issue of incorrect password - try running mysqladmin -uroot

[timorthy]

Thanks for your ans. Actually, I started mysql already, set it automatically. However, when I try NET START MYSQL, it also appears error of "error: 'Access denied for user 'ODBC@localhost' (using password: NO)'"

If I put password on it, it announces "error: 'Access denied for user 'ODBC@localhost' (using password: YES)'"

But, when I type: MYSQLADMIN -u root -p reload, it runs well.

I don't know why? Oh gosh mysql.

I'm not sure maybe I run AMP on windows XP system, and I'm setting log-in the system automatically. Does it cause error?