How to install the installation-free version of MySQL on Windows systems

MySQL is currently one of the most popular open source database management systems and can run freely on different operating systems and platforms. Although MySQL has been widely used, the official installation program is often complicated and requires users to have a certain technical foundation. Of course, if you need to set up a MySQL environment on your own computer, you do not need to operate the complicated official installation program. This article will teach you how to install the installation-free version of MySQL on Windows systems.

1. Download the MySQL compressed package

First, we need to go to the MySQL official website (https://dev.mysql.com/downloads/mysql) to download the MySQL compressed package. Select "MySQL Community Server" on the official website homepage to enter the download page, then select the Windows version and click the "Download" button to download. Note that you select the "Without installer" version here. This is the installation-free version of MySQL.

2. Decompress the compressed package

After downloading the compressed package, decompress it to the directory you want. Here we choose to decompress it to the root directory of the C drive. After decompression is completed, you can see the directory structure of the folder, which includes the bin directory, data directory, etc. Among them, the bin directory contains the necessary programs to run the MySQL service, and the data directory contains the data files of the MySQL database.

3. Create the my.ini file

Create the my.ini file in the bin directory. The file content is as follows:

[mysql]

Set up mysql Client default character set

default-character-set=utf8

[mysqld]

Set 3306 port

port=3306

Set the installation directory of mysql

basedir=C:\mysql

Set the directory where the data of the mysql database is stored

datadir=C:\mysql\data

Maximum number of connections allowed

max_connections=200

The character set used by the server defaults to the 8-bit encoded latin1 character set

character-set-server=utf8

4. Configure environment variables

In order to enable the command window to start the MySQL service and client program, you need to add the bin directory of the installation path to the system's PATH environment variable.

Add the MySQL installation path to the system's PATH environment variable, taking "C:\mysql\bin" as an example.

5. Initialization data

Enter the bin directory on the command line and execute the command mysqld --initialize-insecure --console. The function of this command is to initialize MySQL data, create initial data files, and generate encryption passwords.

mysqld --initialize-insecure --console

After executing the above command, check whether the files in the data directory have been initialized. If so, execute the following command to start the MySQL service.

6. Start the service

Enter the bin directory of mysql through the command line, and enter the following command on the command line to start the mysql service.

mysqld --defaults-file="D:\mysql\my.ini" --console

At this time we can test whether the MySQL service has been started normally through the command line, execute the following command ：

mysql -u root -p

After entering the password, you can enter the MySQL console interface.

7. Summary

The above is the method of installing MySQL based on the installation-free form. Compared with the official installation program, the installation-free version is simpler and more convenient to install. Of course, if you are not familiar with the application of MySQL technology before use, it is recommended to read official documents or tutorials so that you can better use MySQL.

The above is the detailed content of How to install the installation-free version of MySQL on Windows systems. For more information, please follow other related articles on the PHP Chinese website!