Install MySQL6 on Windows

1 Installing MySQL6

http://fengyongfa2006.blog.163.com/blog/static/36654659200942401542800/

2 Changing the password of the root account

C:>mysql–urootmysql>show databases; MySQL> Usemysql;mysql>update user SET Password=password ("123456") WHERE user='root'; MySQL >FLUSH privileges;mysql>quit

Note: After you fix the reset password, be sure to perform the Refresh Permission command (flush privileges)

3 login encountered MySQL ERROR 1045 problem

If logging in to the MySQL database using the root account is unsuccessful, an error 1045 exception is thrown.

1045 (28000for'root'@'localhost' (using

Workaround:

Install MySQL6 on Windows