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

This article has shared the mysql 8.0.16 installation configuration method picture and text tutorial for your reference, the specific content is as follows

1. Download the installation package

2. Installation tutorial

(1) configure environment variables

(2) generate data files

(3) install MySQL

(4) start the service

(5) Log in to MySQL

(6) query user password

(7) set and modify user password

(8) exit

1. Download the installation package

Download the latest version of Oracle from the official website:

After clicking download, you can choose to sign up for an Oracle account or skip downloading directly.

After the download is complete, select a disk to place and decompress, such as

(2) generate data files

Run cmd as an administrator

Enter E:\ mysql\ mysql-8.0.16-winx64\ bin >

Execute the command: mysqld-- initialize-insecure-- user=mysql generates the data directory under the E:\ mysql\ mysql-8.0.16-winx64\ bin directory

(3) install MySQL

Continue with the command: mysqld-install

(4) start the service

Continue with the command: net start MySQL

(5) Log in to MySQL

Log in to mysql: (because the password has not been set before, the password is empty. You do not need to enter the password, you can enter directly.)

Here are the solutions for Mysql forgetting root password and changing root password

1. The following are the operating steps of the Windows operating system:

1. Shut down the running MySQL service-- > net stop mysql

two。 Open the DOS window and change to the mysql\ bin directory.

3. Enter mysqld-- console-- skip-grant-tables-- shared-memory enter. -- skip-grant-tables means to skip authority table authentication when starting the MySQL service. Note that there are two "-" in front of skip, so the DOS window cannot enter it.

4. Open another DOS window and go to the mysql\ bin directory.

5. Enter mysql enter, and if successful, the MySQL prompt > will appear.

6. Connect permissions database: use mysql;.

7. Change password: update mysql.user set authentication_string= ("root123") where user='root'

The following statement appears to indicate that the modification was successful

Query OK, 1 row affected (0.01sec)

Rows matched: 1 Changed: 1 Warnings: 0

8. Refresh permissions (required): flush privileges;

9. Exit quit.

10. Log out of the system and re-enter.

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.