Error 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using password:y) reprinted April 07, 2017 17:48:57 41200 ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using password:y) #1. Stop the MySQL database service MySQL stop #2. Execute the following command mysqld_ Safe--user=mysql--skip-grant-tables--skip-networking & #3. Log in to the MySQL database using root mysql-u root MySQL #4. Update the root password MYSQL&G T Update user set Password=password (' NewPassword ') where user= ' root '; search #最新版MySQL请采用如下SQL:mysql> UPDATE user SET Authen Tication_string=password (' NewPassword ') where user= ' root '; #5. Refresh permissions mysql> flush privileges; #6. Quit MySQL mysql> quit #7. Restart MySQL service MySQL start #8. Log back in to MySQL mysql-uroot-p enter password with the root user: < Enter new Password n Ewpassword>
MySQL forgot password