MySQL8 Forgot Password Solution (Picture and Text Example)

The content of this article is about the solution for forgetting the password in MySQL8 (picture and text examples). It has certain reference value. Friends in need can refer to it. I hope it will be helpful to you. helped.

Readers who have studied MySQL may find that MySQL is updated very quickly. In terms of installation methods, MySQL provides two classic installation methods: decompression and one-click. Although they are two installation methods, I would also recommend choosing decompression installation, which is not only fast but also clean. In terms of operating systems, MySQL also supports multiple types of operating systems, such as linux, windows, etc. The following are the operating systems with several major changes to MySQL.

Through research and analysis, it is not difficult to find that: MySQL’s iterative change process from low version to high version, increasingly stringent security is one of its major features. Let's take an example. Before version 6, when you forgot your password and reset it, you only need to perform the following two steps: (Recommended course: MySQL Tutorial)

Step 1: Skip the permission table

mysqld –skip-grant-tables

Step 2: Leave the password blank

UPDATE user SET authentication_string='' WHERE user='root';

However, this solution is not applicable in MySQL8.

This article will solve the problem of password reset for MySQL 8 if you forget it. Mainly includes three aspects: Content 1: Brief description of decompression installation of MySQL 8

Content 2: Forgot password reset password solution 1

Content 3: Forgot password Reset password solution two

1 Installation

1. Download the installation package from the official website (the official website provides two installation methods: visual installation method and decompression method). The example is based on decompression. Official website download address https://dev.mysql.com/downloads/mysql/

2. Unzip the installation package and place it under the C:\MySQL directory

3. Configure environment variables

MySQL_HOME="C:\MySQL\mysql-8.0.15-winx64"
PATH="%MySQL_HOME%\bin"

4. Open dos as administrator

(1) Start the service

mysqld --install

(2) Initialize and generate the initialization password (MySQL7 does not have a data directory, install the data directory initially)

mysqld --initialize --user=mysql --console

(3) Start the service

net start mysql

(4) Log in to

account root, the password is the temporary password A*v)(Ivw7xjQ, after logging in, you need to change

(5) Change root password

Format: alter user 'username'@'login host' identified by 'password (custom)';

(6) New password login

(7) Extended command

Remove service: mysql -- remove

Stop mysql service: mysql stop mysql

Exit mysql:exit

二 Solve the problem of forgotten password

(1) Solution 1

---

1. Enter dos as administrator

2. Stop the mysql service

net stop mysql

3. Start without password

mysqld --console --skip-grant-tables --shared-memory

##4. Open another dos window and log in without password

##5. Clear the password

Note: authentication_string uses plugin encryption, so set it to empty. Do not set it to other values

##6. Start the service

Close the two open dos windows, then reopen a dos window as an administrator and start the service

net start mysql

7. Log in without password

mysql -u root

8. Reset the password

After modification, you can log in with the new password.

9. Login with new password

（二）方案二：利用参数 --init-file参数

1.停止服务

net stop mysql

2.在c:\MySQL 目录下创建ResetPWD.txt文件，文件内容为

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

3.执行ResetPWD.txt文件

mysqld --init-file=c:\mysql\ResetPWD.txt --console，执行完毕后，关闭dos窗口

4.启动mysql

net start mysql

5.用新密码登录

The above is the detailed content of MySQL8 Forgot Password Solution (Picture and Text Example). For more information, please follow other related articles on the PHP Chinese website!