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

This article mainly introduces mysql 8.0.17 how to install the configuration, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Installer download:

First, log on to MySQL's website and download the installation package for MySQL 8.0.17. Official website address: https://www.mysql.com/

After opening the MySQL official website, on the page that appears, click the DOWNLOADS button:

In the page that pops up, click Community, as shown in the following figure:

Next, we go to the MySQL Community download page, we find MySQL Community Server, and click the download button, as shown in the following figure:

After clicking the DOWNLOAD button, a new page pops up, we find MySQL Community Server8.0.17 in the middle of the new page, and click Go To Download Page on the lower right to go to the real download page. As shown in the following figure:

After entering the real download page, we come to the bottom of the page, we can see that there are two downloadable files, in order to avoid downloading the MySQL installer, I choose to download the second installer, that is, the larger one. As shown in the following figure:

After clicking the download button, a page will pop up to remind you to log in or register. We don't care about it, just go to the bottom of the page and click download only. As shown in the following figure:

It is important to note that the installer for MySQL is 32-bit, but the installer installs both 32-bit and 64-bit MySQL.

Installation steps:

First of all, find the downloaded installer and double-click to run it, which will bring up an installation type selection interface. Here I choose to install only the server, as shown in the following figure:

Then click Next, and we come to the interface that sets the installation path and the data storage path. Here, I chose to put them all on disk D. As shown in the following figure:

After the path is set, continue to click Next to go to the installation interface, and then click the Execute button, as shown below:

Next, click the Next button all the way, as shown in the following figure:

After clicking the Next button again, we come to the interface for creating users and setting passwords. Let's first set the password for the root user (remember this password), and then click the Add User below to create a new user, as shown in the following figure:

After clicking the Add User button, we come to the interface for configuring information for the newly created user, which can be selected by default except for the user name and password. As shown in the following figure:

One thing to point out here is that the default value of the Host option means that any host can connect to the MySQL database.

After clicking the OK button, we go to the Windows Service settings interface. We don't need to make any changes, just click Next, as shown in the following figure:

Then go to the application configuration interface, click the Execute button, and wait for the execution to be completed, as shown below:

When the execution result is shown in the following figure, we can click the Finish button:

After clicking the Finish button, we come to the product configuration interface, and we can see from the status that the product has been configured. As shown in the following figure:

Next, click Next again to pop up the following screen, and we click Finish:

At this point, complete the installation of MySQL8.0.17.

Next, copy the installation path of MySQL to the bin level, mine is D:\ MySQL Server 8.0\ bin, and add it to the environment variable.

Add steps: right-click on this computer-- > Properties-- > Advanced system Settings-- > Environment variables-- > Select path-- > Edit in the system variables

-- > New-- > copy and paste D:\ MySQL Server 8.0\ bin-- > confirm for three times in a row.

Supplement 1:

When MySQL8.0.17 is installed successfully, we can find the command line clients (and two) that come with MySQL in the start interface, as shown in the following figure:

The names of the two command line clients are similar, with-Unicode at the end of one name. The difference between the two is that each module of MySQL is encoded differently, as shown in the following figure:

In general mode:

In Unicode mode:

To prevent garbled problems, we can choose to use the command line client in Unicode mode.

Supplement 2:

In addition to the client tools included with MySQL, we can also use third-party client tools. Here is how to solve the 2059 error when connecting to MySQL database with Navicat Premium, as shown in the following figure:

The reason for this error is that in previous versions of mysql8, the encryption rule was mysql_native_password, while after mysql8 the encryption rule was caching_sha2_password. To solve this problem, you can change the encryption rule for MySQL user login to mysql_native_password:

After successfully connecting to the MySQL database server, enter the following statement in turn:

For user root:

# set password to never expire ALTER USER 'root'@'localhost' IDENTIFIED BY' password' PASSWORD EXPIRE NEVER;# modify encryption rules, and set new user password ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' new password; # Refresh permission FLUSH PRIVILEGES

For the newly created user yahui:

The% after ALTER USER 'yahui'@'%' IDENTIFIED BY' password' PASSWORD EXPIRE NEVER; # @ indicates any host ALTER USER 'yahui'@'%' IDENTIFIED WITH mysql_native_password BY' new password; the% after # @ indicates any host FLUSH PRIVILEGES # Refresh permissions Thank you for reading this article carefully. I hope the article "how to install and configure mysql 8.0.17" shared by the editor will be helpful to you. At the same time, I hope you will support us and follow the industry information channel. More related knowledge is waiting for you to learn!

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.