Detailed graphic tutorial introducing the installation and configuration of MySQL5.6.31 winx64.zip

This article mainly introduces MySQL5.6.31 winx64.zip Installation Detailed configuration tutorial, very good, has reference value, friends in need You can refer to the following

#1. Download

##2. Unzip it locally and modify the necessary configuration my*.ini

##3.mysql install

admin模式启动cmd
cd mysql目录/bin

Perform the installation: mysqld -install

Start the mysql service: net start mysql

Close the mysql service: net stop mysql

4.mysql encoding configuration

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

[mysqld]
#设置字符集为utf8
loose-default-character-set = utf8
character-set-server = utf8
basedir = 你的mysql路径
datadir = 你的mysql路径/data
[client]
#设置客户端字符集
default-character-set = utf8

PS:[client] Add this block to the end

5. Modification Root password
## 1. Specify root

user login

MySQL through mysql -u username-p. After entering, press Enter and you will 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('shapo
lang
');

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

Log in again and enter the new password shapolang and it will be ok;

The above is the detailed content of Detailed graphic tutorial introducing the installation and configuration of MySQL5.6.31 winx64.zip. For more information, please follow other related articles on the PHP Chinese website!