Shulou(Shulou.com)06/01 Report--

This article is to share with you the content of a case of configuring an unzipped version of mysql. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

How to configure the extracted mysql: first initialize the data directory, then install the MySQL service with the code [bin\ mysqld-- install], and finally change to the bin directory and execute the command [net start mysql].

How to configure the decompressed version of mysql:

1. First download the community server version of MySQL (MySQL Community Server) from MySQL's official website. Click on [Downloads]-- [MySQL Community Edition]-- [MySQL Community Server], and finally select [Windows (x86c64MCbit), ZIP Archive] in the download list. After downloading the package, unzip it to an installation directory.

2. Find the my-default.ini configuration file under the extracted folder, copy a new ini file, rename it to my.ini, open it for editing, add a line under [client]: default-character-set=gbk, and then set basedir and datadir.

[mysqld]

# set the installation directory of mysql

Basedir=C:\ MyInstalledSofts\ mysql-5.7.17-winx64

# set the data storage directory of the mysql database. It must be data or\\ xxx\\ data

Datadir=C:\ MyInstalledSofts\ mysql-5.7.17-winx64\ data

3. Add the environment variable MYSQL_HOME, whose value is the path of the installation directory of MySQL. Add ";% MTSQL_HOME%\ bin;" to the environment variable path

4. Initialize the data directory. From a command prompt, change the directory to the root of the MySQL installation, and execute the command: bin\ mysqld-- defaults-file=my.ini-- initialize-insecure.

5. Install MySQL service. Execute the command again from the root of the MySQL installation: bin\ mysqld-- install, and prompt "Service successfully installed" after successful installation.

6. Finally, change to the bin directory and execute the command: net start mysql, you can start the MySQL service you just installed. After the startup is successful, you can use MySQL normally.

Thank you for reading! The case of configuring the decompressed version of mysql is shared here. I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.