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

This article shares the mysql 8.0.19 winx64 installation tutorial for your reference. The details are as follows

1. Download mysql-8.0.19-winx64

1.1 entry address: https://dev.mysql.com/downloads/mysql/

1.2 decompress the zip package, and place the extracted file mysql-8.0.19-winx64 file in the desired location, such as under disk D, as shown below:

1.3 configure environment variables (to avoid repeatedly switching paths when operating under the CMD window)

Add D:\ mysql-8.0.19-winx64\ bin under Path

After the environment variable is set, reopen CMD or Windows Powershell later, and you can directly type mysql to log in without having to change to the bin directory of mysql and execute the instructions.

1.4 there is no need to write my.ini configuration files (note)

Now there are no my.ini (or my-default.ini) files after the new version of mysql is installed. And we do not need to add additional ourselves, because after adding, it may lead to the situation that mysql cannot be started, which I have tried. Because before, many blog tutorials on the Internet would say to add my.ini (or my-default.ini) files, but we don't need to add them now.

2. Initialization and service installation of MySQL

2.1 press the "win" key to open the start menu, enter "cmd" in the search box, select the "command prompt" program in the search results, and right-select "run as administrator"

2.2 initialization

Open CMD or Windows Powershell with administrator privileges

Use the command: mysqld-- initialize-- console

After using the CMD command, it is as follows:

C:\ Windows\ system32 > D:\ Python\ mysql-8.0.12-winx64\ bin\ mysqld-- initialize-- console2018-09-13T14:36:55.758742Z 0 [System] [MY-013169] [Server] D:\ Python\ mysql-8.0.12-winx64\ bin\ mysqld (mysqld 8.0.12) initializing of server in progress as process 31042018-09-13T14:37:12.072904Z 5 [MY-010454] [Server] A temporary * * password is generated for root Localhost: `4P! w2fqBruGi` * * 2018-09-13T14:37:23.274980Z 0 [System] [MY-013170] [Server] D:\ Python\ mysql-8.0.12-winx64\ bin\ mysqld (mysqld 8.0.12) initializing of server has completed

Write down the password, the password here is 4Prisw2fqBruGi, the password is randomly generated and everyone is different, the password generated here will be used later when you change the password.

2.3 install the mysql service

Use the command: mysqld-- install

C:\ Windows\ system32 > D:\ Python\ mysql-8.0.12-winx64\ bin\ mysqld-installService successfully installed.

2.4 enabling Services

Use the command: net start mysql

C:\ Windows\ system32 > D:\ Python\ mysql-8.0.12-winx64\ bin > the net start mysqlMySQL service is starting.. the MySQL service has started successfully.

2.5 change password

Enter the command to log in: mysql-u root-p

Enter the password you just saved, such as 4Prisw2fqBruGi

Use the command: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' New password

Note that the password must be more than 6 digits

For example, the password I set is 123456.

D:\ Python\ mysql-8.0.12-winx64\ bin > mysql- u root-pEnter password: * Welcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 8Server version: 8.0.12mysql > ALTER user 'root'@'localhost' IDENTIFIED BY' 123456'- >; Query OK, 0 rows affected (1.98 sec)

2.6 Log in with a new password

Use the command: mysql-u root-p

D:\ Python\ mysql-8.0.12-winx64\ bin > mysql- u root-pEnter password: * Welcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 10Server version: 8.0.12 MySQL Community Server-GPLCopyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.mysql >

Wonderful topic sharing:

Installation tutorials for different versions of mysql

Installation tutorials for each version of mysql5.7

Installation tutorials for each version of mysql5.6

Installation tutorials for each version of mysql8.0

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support 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.