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:
http://dev.mysql.com/doc/refman/5.0/en/access-denied.html
M wrote:
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
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]