The easiest way to reset mysql root password

The easiest way to reset mysql root password

My mysql version is MYSQL V5.7.9, please use the older version:

UPDATE mysql.user SET Password=PASSWORD('new password') WHERE User='root';

Mac OS X - Reset MySQL Root Password

Too many passwords to remember? ? Have you forgotten your MySQL root password for Mac OS? Follow these 4 steps to reset your password:

1. Stop mysql server.

Usually in 'System Preferences' > MySQL > 'Stop MySQL Server'

2. Open the terminal and enter:

sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables

3. Open another new terminal and enter:

sudo /usr/local/mysql/bin/mysql -u root

  UPDATE mysql.user SET authentication_string=PASSWORD('your new password') WHERE User='root';

  FLUSH PRIVILEGES;

  exit

4. Restart MySQL.

Okay, that's it.

Knowledge points supplement

Windows:

1. Log in to the system as a system administrator.

2. Open cmd-----net start to check whether mysql is started. If started, stop it with net stop mysql.

3. My mysql is installed in d:\usr\local\mysql4\bin.

4. Skip the permission check and start mysql.

d:\usr\local\mysql\bin\mysqld-nt --skip-grant-tables

5. Reopen cmd. Go to d:\usr\local\mysql4\bin:

d:\usr\local\mysql\bin\mysqladmin -u root flush-privileges password "newpassword"

d:\usr\local\mysql\bin\mysqladmin -u root -p shutdown This sentence prompts you to re-enter the password.

6. In cmd, net start mysql

7. Done.

Linux:

One of the methods to recover MySQL root password

If you forget the MySQL root password, you can reset it using the following method:

1.KILL the MySQL process in the system;

killall -TERM MySQLd

2. Start MySQL with the following command without checking permissions;
safe_MySQLd --skip-grant-tables &

3. Then log in to MySQL as root user with an empty password;

MySQL -u root

4. Change the root user's password;

MySQL> update MySQL.user set password=PASSWORD('new password') where User='root'; 
MySQL> flush privileges; 
MySQL> quit

Restart MySQL and you can log in using the new password.

This is the end of this article about the easiest way to reset the mysql root password. For more information about how to reset the mysql root password under mysql, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!

You may also be interested in:
  • What should I do if I forget my MySQL password? How to reset MySQL root password
  • Detailed method for forgetting the root password or resetting the password in Mysql 5.7
  • How to reset the root password in mysql8.0.12
  • How to reset MySQL root password under Windows
  • Reset mysql root password in linux system
  • How to reset the root user password of MySQL database if you forget it [Graphic]
  • How to reset the root password of Mysql in Windows if you forget it
  • Complete steps to reset the root user password in mysql8
  • How to solve the problem "Unknown column 'password" when resetting MySQL root password
  • A practical record of MySql resetting the root password and failing

<<:  Example of how to build a Harbor public repository with Docker

>>:  Detailed explanation of Nginx status monitoring and log analysis

Recommend

MySQL transaction isolation level details

serializable serialization (no problem) Transacti...

How to build php-nginx-alpine image from scratch in Docker

Although I have run some projects in Docker envir...

WeChat applet realizes the effect of shaking the sieve

This article shares the specific code of the WeCh...

Mini Program implements custom multi-level single-select and multiple-select

This article shares the specific code for impleme...

How to create a Pod in Kubernetes

Table of contents How to create a Pod? kubectl to...

Details on macrotasks and microtasks in JavaScript

Table of contents 1. What are microtasks? 2. What...

Example code for implementing dynamic column filtering in vue+element table

Requirement: When displaying data in a list, ther...

CSS3 realizes the childhood paper airplane

Today we are going to make origami airplanes (the...

Solve the problem of MySql client exiting in seconds (my.ini not found)

Problem description (environment: windows7, MySql...

How to deploy LNMP & phpMyAdmin in docker

Environmental preparation: Deploy lnmp on a host ...

How to use docker to deploy front-end applications

Docker is becoming more and more popular. It can ...

How to install Apache service in Linux operating system

Download link: Operating Environment CentOS 7.6 i...