After the above two installs and initializes the article, some small partners will appear when landing MySQL: Error 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no) The prompt.
Use the following methods can be resolved, I have verified the feasibility.
#1. Stop the MySQL database/etc/init.d/mysqld 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> update user SET Password=password (' NewPassword ') where user= ' Root '; #最新版MySQL请采用如下SQL:mysql> UPDATE user SET Authentication_string=password (' NewPassword ') where user= ' root '; #5. Refresh permissions mysql> flush privileges; #6. Quit mysqlmysql> quit #7. Restart Mysql/etc/init.d/mysqld restart #8. re-login with root user mysqlmysql-uroot-p Enter password: < Enter the newly created password newpassword>
ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no)