MySQL Configuration edition installation

• Unzip and modify the configuration file
• Adding environment variables
• Register MySQL Service
• Start the service
• Change root password

Unzip and modify the configuration file

Unzip the downloaded MySQL archive into a custom directory, and my unzip directory is:
"D:\MySQL\mysql-5.6.13-win32"
Will unzip the directory under the default file My-default.ini copy one copy, renamed My.ini
Copy the following configuration information to My.ini save
If you don't have a my-default.ini, you can create your own my.ini or get it from somewhere else.

[client]port=3306default-character-set=utf8[mysqld]port=3306character_set_server=utf8#解压目录basedir=D:\MySQL\mysql-5.6.13-win32#解压目录下data目录datadir=D:\MySQL\mysql-5.6.13-win32\datasql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES[WinMySQLAdmin]D:\MySQL\mysql-5.6.13-win32\bin\mysqld.exe

Adding environment variables

The operation is as follows:
1. Right-click My Computer, properties, advanced system settings (advanced), environment variables
Click the New button under System variables
Input variable name: mysql_home
Input variable Value: D:\mysql-5.6.11-winx64
This is the custom unzip directory for MySQL.
2. Select path in the system variable
Click the Edit button
To add a variable value to a variable value:%mysql_home%\bin
Note that this variable is added after the value of the original variable, separated from it, and cannot delete the original variable value.

Register MySQL Service

From the console into the bin directory under the MySQL decompression directory:
Enter the Service installation command:
mysqld install MySQL --defaults-file="D:\Program Files\MySQL\mysql-5.6.13-win32\my.ini"
Extract the modified My.ini file from the directory
A successful installation will prompt the service to install successfully.
Note: The My.ini file is placed in the root directory after MySQL decompression
The Removal Service command is: mysqld remove

Start the service

• Method One:
  The Start service command is: net start MySQL
• Method Two:
  Open the Administration Tools service and locate the MySQL service.
  Start the service by right-clicking to start or by tapping on the left-hand boot directly.

Change root password

The default password for the root account is empty when the installation is complete, and you can modify the password to the specified password. Example: 123456

c:>mysql –uroot    mysql>show databases;    mysql>usemysql;    mysql>UPDATE user SET password=PASSWORD("123456") WHERE user=‘root‘;    mysql>FLUSH PRIVILEGES;    mysql>QUIT

MySQL Configuration edition installation