MySQL5.6.31 winx64.zip installation tutorial, mysql5.6winx64.zip

MySQL5.6.31 winx64.zip installation tutorial, mysql5.6winx64.zip

#1. Download

#

#2. decompress the package to the local machine to modify the necessary configuration my *. ini

#3. mysql install 

Start the cmdcd mysql directory/bin in admin mode

Execute the installation: mysqld-install

Start mysql service: net start mysql

Disable mysql service: net stop mysql

#4. mysql encoding configuration <decompressed MySQL-5.6.31-winx64 encoding configuration>

There is an INI file starting with "my-" already written under the root directory, such as: my-default.ini. Copy one copy, change the file name to my. ini, and add the following content:

[Mysqld] # set character set to utf8loose-default-character-set = utf8character-set-server = utf8basedir = Your mysql path datadir = Your mysql path/data [client] # set client character set default-character-set = utf8

PS: [client ].

#5. Change the Root password

1. Use mysql-u username-p to specify the root user to log on to MySQL. Enter the password and press Enter.

2. Modify the MySQL root User password. Format: mysql> set password for username @ localhost = password ('new password ');

Example: mysql> set password for root @ localhost = password ('shapolang ');

In the preceding example, the User root Password is changed to shapolang;

Log on again and enter the new password shapolang;

The above is a detailed tutorial on MySQL5.6.31 winx64.zip installation and configuration. I hope it will help you. If you have any questions, please leave a message and I will reply to you in time. Thank you very much for your support for the help House website!