How to configure the installation-free version of MySQL

MySQL is a common relational database management system. Usually we need to download and install it to use it. But sometimes we want to be able to use MySQL quickly without having to go through tedious downloads and installations.

At this time, we can use the installation-free version of MySQL. The installation-free version of MySQL, also called the green version and the portable version, refers to a version that can be used directly without installation. Run the relevant programs above and you can use the MySQL database. The following describes how to configure the installation-free version of MySQL.

1. Download the installation-free version of MySQL

First you need to download the installation-free version of MySQL. It can be downloaded from the official website of MySQL or from some other software download websites. For convenience, some websites will package and upload different versions of MySQL together. We need to download the corresponding version according to our own needs.

2. Unzip the installation-free version of MySQL

After downloading the installation-free version of MySQL, we need to unzip it. After unzipping, you can see a folder containing all MySQL files. We need to put it in a location that is easy for us to remember, such as the root directory of the C drive.

3. Create a MySQL data folder and modify the configuration file

After decompressing the installation-free version of MySQL, we need to create a MySQL data folder. In this folder, we can store MySQL data and log files. For example, create a new folder in the root directory of drive C and name it mysqldata. This is MySQL's default data storage location.

Next, we need to modify the MySQL configuration file. The configuration file is located in the my.ini file in the root directory of MySQL. We need to open it and find the fields of [mysqld]. Add the following parameters under this field:

[mysqld]
basedir=C:\mysql
datadir=C:\mysqldata

where basedir represents the installation path of MySQL (that is, the path to the decompressed MySQL folder), and datadir represents the storage path of the MySQL data file (that is, the newly created the path to the mysqldata folder).

4. Start the MySQL service

After completing the above steps, we need to start the MySQL service. In the bin folder under the MySQL root directory, find the mysqld.exe file. We need to click on it to start the MySQL service. If permission issues occur, you can right-click mysqld.exe and select "Run as administrator".

After we start the MySQL service, we can see that the MySQL service is already running in the Windows service list.

5. Connect to MySQL

Finally, we need to connect to MySQL. We can use the MySQL client to connect to MySQL, enter the MySQL username and password we configured in the opened window, and then we can successfully connect to MySQL.

Summary

The above is the configuration method of MySQL installation-free version. The installation-free version of MySQL helps us use MySQL quickly without having to download and install it. Although it will be a little troublesome to use, after configuring it, we can use MySQL anywhere. Hope this article is helpful to everyone!

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