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]
