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
--skip-grant-tables, I can see correct entries for user root:

mysql> select  Host,  User from user where User = 'root';
+--------------------------------------------------------------+------+
| Host                                                         | User |
+--------------------------------------------------------------+------+
| localhost                                                    | root |
| localhost.localdomain                                        | root |
+--------------------------------------------------------------+------+

encoded passwords are there too.

Is there anything else I could miss. What should I check, where to look?

Thank you

Marek



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to