Installing MySQL 5.7.7 under Windows

First uninstall the existing MySQL program

1. Stop MySQL Service

2. Uninstall MySQL program

3. Remove the installation directory

4 Delete Data Directory

5 Delete information about MySQL in the registry

Using Find MySQL, the found data is selectively deleted, some may not be MySQL programs. I uninstalled MySQL 2 times and did not find MySQL-related information in the registry.

installing MySQL 5.7.7

1, unzip the zip package, and copy My-default.ini, renamed to My.ini

2, the contents of the configuration My.ini are as follows:

3. Add the MySQL directory to the environment variable path

4, registered MySQL for win system services, and start the service

5. Log in to MySQL using root, the initial login root has no password

6, change the root password for 1234 ( important, win and Linux change the password is not the same )

Update Mysql.user set Authentication_string=password (' 1234 ') where user= ' root ' and Host = ' localhost ';

7. Use the root user login password to set the remote connection to open

GRANT all privileges on * * to ' root ' @ '% ' identified by ' 1234 ' with GRANT OPTION;

 

Log in to local MySQL using Navicat

Installing MySQL 5.7.7 under Windows