Mysql 5.6.37 winx64 dual-version mysql notes, 5.6.37winx64

Mysql 5.6.37 winx64 dual-version mysql notes, 5.6.37winx64

If MySQL 5.0 already exists on the machine, continue to install the latest version of mysql.

1. Download the free installation package from the official website.

The downloaded file is mysql-5.6.37-winx64.zip. decompress the package to the custom directory. Example: D: \ mysql-5.6.37.

2. Add environment variables.

Right-click my computer> Properties> advanced system Settings> environment variables. Click new Under System Variables

Input variable name: MYSQL_HOME input variable value: D: \ mysql-5.6.37 (custom extract directory), select path in system variable, click Edit button to add variable value % MYSQL_HOME % \ bin, it is separated from the value of the previous variable.

3. Register windows system services

Run cmd to enter the bin directory of the mysql custom extract directory. Input D: In the input cd D: \ mysql-5.6.37 \ bin

Enter the installation command: mysqld-install service name (no service name is entered, mysql service is created by default) mysqld-install MySQL-defaults-file = "D: \ mysql-5.6.37 \ my. ini"

(System services will be created with parameters in my. ini in the specified path)

Here, you need to write the mysql configuration information in my. ini to [client] In my. ini.

Port = 3306default-character-set = utf8 [mysqld] # Set to the MYSQL installation directory basedir = D: \ mysql-5.6.37 # Set to the mysql data directory datadir = D: \ mysql-5.6.37 \ dataport = 3306character_set_server = utf8sql_mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES

4. Start mysql

Input in cmd

Net start service name

5. Common Operations

SC delete mysql (delete a service named mysql under cmd)

Mysqld remove mysql5.6 (run the command in the bin directory of mysql to delete the service named mysql5.6)

Net stop mysql (close the service named mysql)

Vi. Precautions and error records

1. The newly installed mysql port must be different from the previous port
2. Error 1053: a message indicating that the service is successfully installed is displayed, but a 1053 error occurs when the service is started later. Solution: Delete the mysql service you just created and use mysqld-install mysql5.6 to reinstall the service.
3. Error 1067: a message is displayed when the service is started. Solution: Check the my. ini file and find that basedir and datadir are written incorrectly. Change it to the correct path.

Summary

The above is the notes for Mysql 5.6.37 winx64 dual-version mysql installation. I hope it will be helpful to you. If you have any questions, please leave a message, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!