How to install the MySQL compressed package version?

MySQL is a small and exquisite but powerful database that is very popular currently. However, the installation package provided by the official website has two formats, one is in msi format and the other is in zip format. Many people unzip the zip format and find that there is no setup.exe. They are confused when faced with a bunch of files and don't know how to install it. The following article will introduce it to you, I hope it will be helpful to you.

Steps to install the Mysql compressed package version:

1. Download the mysql compressed package file.

Download address: http://dev.mysql.com/downloads/mysql/

①Select the corresponding mysql version: as shown

②Select the corresponding version according to the computer system, click Download to enter the jump page for downloading without login (that is, no need to register and log in on the website): As shown in Figure 1 and Figure 2

Click "No thanks, just start my download." to start the download

2. Decompress the compressed package and install it.

The installation package in zip format needs to be decompressed by yourself. After decompression, MySQL can actually be used, but it needs to be configured.

After decompressing, you need to put the folder in a suitable location, you can put it anywhere you want. Example: Place the folder in the path D:\mysql, directory structure: D:\mysql\mysql-5.6.33-winx64.

1. Configure the my.ini file.

In D:\mysql\mysql-5.6.33-winx64\ (note that this directory must be the same as your own directory. I downloaded version 5.6 here. If you downloaded version 5.5, This directory is different) Create a new configuration file in the directory, the file name is my.ini, and then copy the following configuration code to my.ini (the path in the code must be changed to your own file storage path). As shown in the picture:

Code:

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

2. Install the mysql service:

Run as administrator Find this cmd.exe in the C:\Windows\System32 directory. Be sure to run it as an administrator, otherwise the installation will not be successful.

After opening the cmd window as an administrator, switch the directory to the bin directory where you decompressed the file, then enter mysqld install and press Enter to run. Note that it is mysqld. Not mysql. Just enter the command in my picture directly into cmd. As shown in the picture:

The installation is successful. As shown in the picture:

After the installation is successful, someone directly enters mysql -uroot After -p and then press Enter, it still prompts that the database cannot be connected. Why is this? This is because after successfully installing mysql, you need to enable the mysql service before it can be used.

3. Start the mysql service.

①Control Panel-"Management Tools-"Services-"mysql-"Start.

At this point, you can use the mysql service. After installation, if a 1066 error occurs during the startup process, it is because of a problem with the my.ini configuration. Pay attention to see if the path in my.ini has been modified to your own path.

When you enter the command mysql -uroot -p to connect to the database, you will be prompted to enter a password. The root password is blank by default. Just press Enter.

The above is the detailed content of How to install the MySQL compressed package version?. For more information, please follow other related articles on the PHP Chinese website!