MySQL free installation configuration and remote access

1. Unzip the downloaded MySQL archive into a custom directory (D:\Program Files (x86) \mysql-5.6.16-winx64).

2. registering MySQL as a Windows system service

The operation is as follows:

1) Create a new My.ini file and put the My.ini file under D:\Program files (x86) \mysql-5.6.16-winx64\, My.ini the following:

[Client]port=3306default-character-set=utf8[mysqld] # Set the installation directory for MySQL Basedir=d:\program Files (x86) \ mysql-5.6.16-winx64# Data Directory set to MySQL Datadir=d:\program Files (x86) \mysql-5.6.16-winx64/dataport=3306character_set_ Server=utf8sql_mode=no_engine_substitution,strict_trans_tables

2 ) run cmd as an administrator and go to MySQL unzip the directory under the bin directory.

3) Enter the Service installation command:

Mysqld.exe-install

A successful installation will prompt the service to install successfully.

Note: The My-default.ini file is available in the root directory after MySQL decompression, if not, from somewhere else.

The Removal Service command is: Mysqld-remove

3. Start the MySQL 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.

4. Change the root account password to 123

mysqladmin-u root password "123"

5. Remote Access

Root does not support remote access by default, you need to add authorization manually

Grant all privileges on * * to [email protected] '% ' identified by ' 123 '; Allow authorization to take effect flush privileges;