Access denied after upgrade to 5.0

2006-01-28 Thread M
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

Re: Access denied after upgrade to 5.0

2006-01-28 Thread Gleb Paharenko
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: