Detailed example of the basic tutorial for installing the mysql decompression package

For novices, the installation of the mysql decompression package also needs to be learned. This article mainly introduces the basic tutorial for the installation of the mysql decompression package in detail. It has certain reference value. Interested friends can refer to it. I hope it can Help everyone.

1. Download the installation package
2. Configure the my.ini file

The configuration information is as follows:

[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8 
[mysqld]
#设置3306端口
port = 3306 
# 设置mysql的安装目录
basedir=F:\bianyi\mysql-5.6.24-win32
# 设置mysql数据库的数据的存放目录
datadir=F:\bianyi\mysql-5.6.24-win32\data
# 允许最大连接数
max_connections=200
# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB

3. Install the service

After opening the cmd window as an administrator, switch the directory to the bin directory where you extracted the file, and then enter vity/SouthEast )

4. Start service login verification

Continue to enter: net start mysql. After the service is started, enter: mysql -uroot -p

5. Change password

Continue to enter: set password for root@localhost = password('12456');

where During this process, the installation service failed because it was not run as an administrator:

Related recommendations:

Encoding settings for MySQL installation Detailed graphic and text explanation

Detailed graphic and text explanation of MySQL installation

Summary of issues regarding MySQL installation methods and configuration methods

The above is the detailed content of Detailed example of the basic tutorial for installing the mysql decompression package. For more information, please follow other related articles on the PHP Chinese website!