Mysql configuration version installation_mysql

Decompress and modify the configuration file: Decompress the downloaded MySQL package to the custom directory, and decompress the package to modify the configuration file.

Decompress the downloaded MySQL package to the custom directory. The decompressed directory is:
"D: \ Program Files \ MySQL \ mysql-5.6.13-win32"
Copy the default file my-default.ini in the unzipped directory and change it to my. ini.
Copy the following configuration information to my. ini and save it.
If there is no my-default.ini, you can create my. ini yourself or get it from somewhere else
<
[Client]
Port = 3306
Default-character-set = utf8
[Mysqld]
Port = 3306
Character_set_server = utf8
Basedir = D: \ Program Files \ MySQL \ mysql-5.6.13-win32
# Decompress the Directory
Datadir = D: \ Program Files \ MySQL \ mysql-5.6.13-win32 \ data
# Decompress the data directory in the directory
SQL _mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES
[WinMySQLAdmin]
D: \ Program Files \ MySQL \ mysql-5.6.13-win32 \ bin \ mysqld.exe
>

Add Environment Variables

The procedure is as follows:
1) Right-click my computer-> properties-> advanced system settings (advanced)-> Environment Variables
Click new Under System Variables
Input variable name: MYSQL_HOME
Input variable value: D: \ Program Files \ mysql-5.6.11-winx64
# This is the custom extract directory of mysql.
2) Select the Path in the system variable
Click Edit
Add the variable value % MYSQL_HOME % \ bin to the variable value.
Note that this variable is added after the original variable value and separated by;. The original variable value cannot be deleted,

Register Mysql Service

1) log on to the bin directory under the MySQL decompression directory from the console:
2) enter the service installation command:
Mysqld install MySQL-defaults-file = "D: \ Program Files \ MySQL \ mysql-5.6.13-win32 \ my. ini"
Decompress the my. ini file modified in the directory
After the installation is successful, a message is displayed, indicating that the service is successfully installed.
Note: Put the my. ini file in the root directory after MySQL Decompression
Command: mysqld remove

Start the service

Method 1: run the net start mysql Command. Method 2: Open the management tools service and find the MySQL service. Right-click Start or click Start on the left to start the service.

Change root Password

When the installation is complete, the default password of the root account is blank. You can change the password to the specified password. Example: 123456
C:> mysql-uroot
Mysql> show databases;
Mysql> use mysql;
Mysql> UPDATE user SET password = PASSWORD ("123456") WHERE user = 'root ';
Mysql> flush privileges;
Mysql> QUIT