MYSQL 5.6.14 winx64 Configuration method (Installation-free version) _mysql

1. Download MySQL Community Server 5.6.14

2. Extract the MySQL compression package

Unzip the downloaded MySQL compression package to the custom directory.

3. Add Environment variables

Variable name: mysql_home

Variable Value: D:\Program files\mysql-5.6.14-winx64

That is, a custom extract directory for MySQL.

and add%mysql_home%\bin to the path.

4. Registering Windows System Services

Registering MySQL as a Windows system service

The operation is as follows:

1 Create a new My.ini file and copy the My.ini file to the C:\Windows directory, the My.ini content is as follows:

[Client]
port=3306
Default-character-set=utf8
[mysqld] 
# set to MySQL's installation directory 
Basedir=d:\program files\ Mysql-5.6.14-winx64
# Set to MySQL's Data directory 
datadir=d:\program files\mysql-5.6.14-winx64/data
port=3306
Character_set_server=utf8
Sql_mode=no_engine_substitution,strict_trans_tables

2 from the console into the MySQL extract directory under the bin directory.

3 Enter the service installation command:

Mysqld.exe-install

If the install/remove of the Service denied! appears

Because window 7 and Vista have more stringent permissions.
Enter C:\Window\System32 find CMD.EXE right key to choose as Administrator, and then into the corresponding directory execution command, all OK.

After the installation is successful, the service installation is prompted to succeed.

Note: My-default.ini files in the root directory after the MySQL extract, if not, can be obtained from other places.

Removal Service command: mysqld remove

5. Start MySQL Service

Method One:

Start service command for: net start MySQL

Method Two:

Open the admin tools service and find the MySQL service.

Start the service by right-clicking on the startup or clicking on the left side of the boot directly.

6. Change the password of root account

When the installation completes, the root account default password is blank, and the password can be modified to the specified password. such as: 123456

Method One:

C:>mysql–uroot
mysql>show databases; 
Mysql>use MySQL;
Mysql>update user SET Password=password ("123456") WHERE user= ' root ';
Mysql>flush privileges; "Note that you must not forget this sentence, or password changes can not be effective"
mysql>quit

Method Two:

Use a Third-party administration tool for password modification. such as Navicat for MySQL

The above is a small series to introduce the MySQL 5.6.14 winx64 configuration method (without installation version), I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!