MySQL Free Install version configuration method

1 extracting MySQL

Unzip the file to your favorite directory, below is my own directory.

Catalog: D:\Program files\mysql\mysql-5.6.25-winx64

Will unzip the directory under the default file My-default.ini copy one copy, renamed My.ini,

and configure My.ini in Basedir (decompression path) and DataDir (data path), refer to.

2 Configuring Environment variables

The person who has configured the JDK will configure the environment variables, yes. mysql also configures environment variables.

Right-click My Computer, properties, advanced system settings (advanced), environment variables add the path to the bin in MySQL in path.

Note that this variable is added after the value of the original variable, separated from it, and the original variable value cannot be deleted .

3 registering MySQL as Windows system service

1) from the console into the bin directory under the MySQL decompression directory ( The following command must be in D:\Program files\mysql\ in the Mysql-5.6.25-winx64\bin directory

 2) Enter the Service installation command:
    mysqld Install MySQL--defaults-file= "D:\Program files\mysql\mysql-5.6.25-winx64 \my.ini "

4 starting the MySQL service

method One:
The start service command is: net start MySQL
Method Two:
Computer Right-manage-services and applications-services to find the MySQL service.
start the service by right-clicking to start or by tapping on the left-hand boot directly.

5 Changing the password of the root account

The default password for the root account is empty when the installation is complete, and you can modify the password to the specified password. such as: 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

6 Shortcut to start the database service

1) object location input, new shortcut, right-click, Desktop: C:\Windows\System32\cmd.exe
shortcut name self-defined, OK, shortcut established successfully
2) Right-click the shortcut you just created, and then change the target column to the MySQL startup parameter:
C:\Windows\System32\cmd.exe "D:\Program files\mysql\mysql-5.6.25-winx64\ Bin"/k mysql-uroot-p Inven Tory
Explanation: cmd path "mysql Path bin directory"/k mysql-u user name-p password database name
3) Click OK to save after the modification, double click the shortcut to connect to MySQL database

MySQL Free Install version configuration method