Re: Trouble setting root password

2005-11-23 Thread Gleb Paharenko
Hello. I have also tried mysqld_safe --skip-grant-tables --user=root Don't run mysqld under root (even more - fresh versions should automatically skip this option). What exactly have you done to restore root password? Please provide exact SQL statements. What user is 'Access denied'

Trouble setting root password

2005-11-22 Thread Logg, Connie A.
I tried to go into mysql with root and the password I had set, and access was refused. I finally gave up and decided to reset the root password using the techniques described on http://dev.mysql.com/doc/refman/4.1/en/resetting-permissions.html This is a linux machine running mysql Your MySQL