Hello,
I upgraded MySQL from 4.1 to 5.0 on my machine (MDK 2006). Since I can't
connect, I always get:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
(or using password:YES)
I followed the reset password procedure. If the server is started with
Hello.
Are you able to connect to MySQL Server if you blank the root password?
Use mysql command line client from 5.0 distribution. Have you run
mysql_fix_privilege_tables script? Please, provide the CREATE statement
for mysql.user table.See: