Win7 installation MySQL 5.6 tutorial diagram

1. Download

Mysql: https://dev.mysql.com/downloads/windows/installer/5.6.html Click the download button, then click to start downloading. You can download without logging in.

2. Installation

1. Double-click the installer

2. Click to agree to the agreement and click next

3. Select the installation version, select Custom, and click Next

4. Select MySQL Server 5.6 x64, check all, then select the installation path, next

Select the installation path

5. Before installation, the necessary environment checks will be performed. Click Execute to perform the necessary environment installation.

6. Perform the installation

7. Installation successful, next step

8. Now configure some parameters. Next

9. Select the server type, set port 3306, then check Advanced Settings, next

10. Set the root user password, add a new user, and go to the next step

11. Set the Windows Server Name and default startup of MySQL, next step

12. Set the log parameters, check Bin Log, and leave the others as default. Next, check Bin Log to implement master-slave usage.

13. Set advanced parameters, the default is ok, next step

14. Execute the application configuration, Execute, and Finish after completion

15. Configuration completed, next step

16. Installation completed, Finish

17. To verify whether the installation is successful, you can use the third-party tool navicat to test it remotely, or you can go to Start->All Programs->Mysql->Run Black Window and execute show databases;

3. Set up the my.ini file (default encoding)

Location: E:\MySQL\MySQLData5.6\my.ini Find the my.ini file of MySQL, you can set the default encoding, number of concurrent connections, default engine, etc.

[client]
default-character-set = utf8

[mysql]
default-character-set = utf8

[mysqld]
basedir=E:/MySQL/MySQLServer5.6/
datadir=E:/MySQL/MySQLData5.6/Data
character-set-server=utf8
default-storage-engine=INNODB

After the settings are completed, restart the MySQL service and execute win+r, enter services.msc, start the service, and then find mysql56 to restart the service

After the MySQL service is restarted, check whether the encoding has been modified successfully.

mysql> show variables like 'character%';

4. Set up root remote access

Click Start->All Programs->Mysql->Run black window and execute remote access command

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'the password you set' WITH GRANT OPTION;
mysql> flush privileges; 

5. Set Windows PATH

1. Configure environment variables: right-click "My Computer" --> "Properties" --> "Advanced System Settings" --> "Environment Variables"

2. Set MYSQL_HOME Create a new MYSQL_HOME variable in the system variables, and the variable value is:

E:\MySQL\MySQLServer5.6 

3. Set PATH Add the variable value to the path variable (it already exists, no need to create a new one):

%MYSQL_HOME%\bin 

4. In this way, you can use the command to start and stop the mysql service

net start mysql56 ## Start the MySQL service net stop mysql56 ## Stop the MySQL service Note that mysql56 is defined according to the windows server name during installation mysql -u root -p 

Summarize

The above is the tutorial illustration of Win7 installation MySQL 5.6 introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!