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

How do I install mysql 8.0.16 on a windows system? I believe that many inexperienced people are at a loss about this, so this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

1. Download MySQL 8.0.16

The official link can download the zip package directly.

Decompress it after download. My decompression location is D:\ Program Files (x86)\ mysql-8.0.16-winx64

two。 Then modify the environment variable.

Add the variable MYSQL_HOME to the system variable with the value of the installation path D:\ Program Files (x86)\ mysql-8.0.16-winx64\ mysql-8.0.16-winx64.

Add% MYSQL_HOME%\ bin to path

Notice that there is no semicolon after here.

3. Initialize and install

Note that the new version does not need to create data folders and my.ini files as on the Internet.

Open cmd directly as an administrator and enter the command:

Mysqld-initialize-console

After initializing the serve, the following display:

Note that the yellow one is a temporary random password, which can be recorded and need to be used later. At the same time, the data folder is generated under the path.

Install after initialization, using:

Mysqld-install

If you want to uninstall, you can use mysqld-- remove

4. Start the service and change the password

Start the service with the following command

Net start mysql

After startup, you need to change your password and enter the command to log in:

Mysql-uroot-p

Log in with the temporary password you just generated, and then use the command

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' New password

Change it to your own password. Here, the new password needs more than 6 digits.

Enter quit; to exit mysql

5. Log in to mysql

Start the mysql service first, and note that you are running cmd as an administrator. It is not possible to open powershell by right-clicking shift+ in a folder, because it does not have administrator privileges. After opening it, enter:

Enter mysql-uroot-p after startup

Then enter the password to log in. Here-p means to enter a password. If you don't have a password, you don't have to add-p.

6. Modify the password

If you want to change the password, open cmd with administrator privileges and enter:

Mysqladmin-u root-p password new password

Then enter the old password and you can change it successfully.

7. Power on and start mysql automatically

Because it is troublesome to start manually every time, you can set boot Windows to start mysql automatically.

As an administrator, cmd enters the command line window and runs

Mysqld-nt-- install after reading the above, do you know how to install mysql 8.0.16 in the windows system? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

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.