MySQL boot prompt access denied for user root@localhost (using Password:yes)

issue: Encounter MySQL startup prompt access denied for user [email protected] (using Password:yes)

1, check the password there is no error, if none is a permission problem.

2. Open the SQL Graphics tool and enter the following command line

Grant all privileges on * * to ' root ' @ ' localhost ' identified by ' your password ' with grant Option;flush privileges;

3, in the local environment to run no problem, if there are anomalies, please leave a comment, discuss together

This article is from the "little Bit of Programming" blog, be sure to keep this source http://andylhx.blog.51cto.com/8891164/1760331

MySQL boot prompt access denied for user [email protected](using Password:yes)