MySQL5.6.31 winx64.zip installation and configuration tutorial

#1. Download

#

#2. Unzip to local and modify necessary configuration my*.ini

#3.mysql install

Start cmd in admin mode
cd mysql directory/bin

Execute the installation: mysqld -install

Start the mysql service: net start mysql

Shut down the mysql service: net stop mysql

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

There are already written ini files starting with "my-" in the root directory, such as: my-default.ini. Make a copy, change the file name to my.ini, and add the following content:

[mysqld]
#Set the character set to utf8
loose-default-character-set = utf8
character-set-server = utf8
basedir = your mysql path datadir = your mysql path/data
[client]
#Set the client character set default-character-set = utf8

PS: [client] Add this piece to the end

#5. Change Root Password

1. Specify the root user to log in to MySQL through mysql -u username -p. After entering, press Enter to be prompted to enter the password.

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');

The above example changes the password of user root to shapolang;

Log in again and enter the new password shapolang.

The above is the detailed installation and configuration tutorial of MySQL5.6.31 winx64.zip introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!