[Changed the root password ]mysql changing passwords unsuccessful? I fc4 appearances mysql5.0 good, Then the password : mysqladmin-u root password 'new-password' Indicated : Mysqladmin : connect to server at 'localhost' failed Error : 'Access denied for user' root '@' localhost '(using password : yes)' Mysqladmin-h localhost-u root-p password abc123!@# The password is not acquiescence. Mysql-u root-p Mysql>use mysql; Mysql>update user set Password=password ( "newpassword") where User= 'root'; Mysql>flush privileges; Mysql>quit --> Upstairs is a positive solution. Oh, wrong, the landlord is not in the download Win, a sweat : : Mysql-u root-p Mysql>use mysql; Mysql>update user set Password=password ( "newpassword") where User= 'root'; Mysql>flush privileges; Mysql>quit Laws show is successful. However into or when the same as the original. No password. Importing new code on the entrance. No password into now, to read a mysql database. Information_schema only read and test database. 1. KILL you put off all the process mysql 2. Mysqld_safe --skip-grant-tables to start, then alter the code into account. And I have every starter could not start using the database mysqladmin Mysqladmin : Error starting slave suggested : Access denied for user : '' @ 'localhost' (using password : NO) Only. /mysqld_safe & This can start. User table and see if it is the record number of User=root Now see, as seen in the past that there are two root not so sure! I have not set any user. Because it is to see two, but did not investigate the use of distinct Not now see a mysql database Can see and test information_schema Before the change password to read Mysql initiate the process is not mysqladmin mysqld_safe Fainted. [ Closed window ]