Shulou(Shulou.com)05/31 Report--

This article is about how to install MySQL Community Server 5.6.39. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

MySQL downloads and installs detailed tutorials as follows

1. Download the MySQL database to visit the official website:

two。 Click MySQL Community Server under the Community module under the DOWNLOADS module to download.

Since the latest version is MySQL Community Server 5.7.21

It is suggested that bloggers download the historical version. The download of this blog is 5.6.39.

Download steps:

Enter and select the version and host of MySQL

According to your computer to choose the appropriate number of digits to download, this machine is 64-bit, click download.

Go to the next page, which needs to register for a MySQL account, or download it without registering.

Click No thanks, just start my download, and select the directory you want to download.

3. To configure the MySQL database, follow these steps:

There are two types of MySQL installation files, one is in msi format and the other is in zip format. The zip format is decompressed by itself, and after decompression, MySQL can actually be used, but it needs to be configured.

If the user is not configured to use MySQL directly, the error shown will occur. This is because there are no environment variables configured. Configuring environment variables is simple:

My computer-> Properties-> Advanced-> Environment variables

Select PATH and add after it: the path to your mysql bin folder: d:\ Program Files\ JavaTool\ MySQL\ mysql-5.6.39-winx64\ bin

After configuring the environment variables, you also need to modify the configuration file (if there is no configuration, the error in the figure will occur when you start up later! Error 2: the file cannot be found by the system. The default configuration file for mysql-5.6.1X is at D:\ Program Files\ JavaTool\ MySQL\ mysql-5.6.39-winx64my-default.ini, or create a my.ini file yourself.

Modify or add a configuration to it:

Basedir=D:\ Program Files\ JavaTool\ MySQL\ mysql-5.6.39-winx64 (the directory where mysql resides)

Datadir=D:\ Program Files\ JavaTool\ MySQL\ mysql-5.6.39-winx64\ data (directory where mysql resides\ data)

Note: the encoding of my.ini files must be English (such as ANSI in windows), not UTF-8 or GBK, etc.

Run cmd as an administrator (be sure to run as an administrator, otherwise there are not enough privileges)

Enter the command: cd D:\ Program Files\ JavaTool\ MySQL\ mysql-5.6.39-winx64\ bin to enter the bin folder of mysql (no matter whether you have configured the environment variable or not, enter the bin folder, otherwise the startup service will still report error 2)

Enter mysqld-install (if you do not run as an administrator, there will be an error due to insufficient permissions: Install/Remove of the Service Denied!)

Installation succeeded

To start the service, enter the command: net start mysql. The startup is successful as shown in the figure.

After the service starts successfully, enter the command: mysql-u root-p (no password for the first login, press enter directly)!

Enter directly and log in successfully as shown in the figure.

Error summary:

If there is an error when starting the service, please note:

At this time, there are often errors 2 and 1067.

1. If "error 2 system cannot find the file", check whether the configuration file has been modified or if you have entered the bin directory. If the configuration file has been modified correctly and entered the bin folder, you need to delete mysql (enter mysqld-remove) and then reinstall (enter mysqld-install).

two。 If error 1067 occurs, it is a configuration file modification error to verify that the configuration file is correct.

Thank you for reading! This is the end of this article on "how to install MySQL Community Server 5.6.39". 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 for more people to see!

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.