Solution to forgetting mysql password under linux

Solution to forgetting mysql password under linux

The problem is as follows: I entered the command mysql -uroot -p, but I forgot the password.

Step 1: Stop the mysql service

There are methods on the Internet to open /etc/my.cnf and modify it, but I didn't find the file in this directory at all. Maybe it’s due to the version!

Enter the command to stop the mysql service: /etc/init.d/mysql stop

Step 2: Start mysql safely and skip the authorization table: mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

Step 3: Reset MySQL password

Input: mysql -uroot -p. You don’t need to enter a password at this time. Just press Enter to enter.

Enter the statement: use mysql, that is, select a database, enter the statement to reset the password, and I found the following problem, which means that the password column is not included

So the authentication_string column should be modified

Then enter the command: flush privileges to refresh the MySQL system privilege related tables. quit Exit mysql

Step 4: Restart the service and enter the newly set password to log in

Restart the mysql service: /etc/init.d/mysql restart

Enter the password and enter mysql.

For more information, please see the topic: MySQL password operation summary

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.

You may also be interested in:
  • How to solve the problem of forgetting MySQL password
  • How to modify mysql user password and how to solve mysql password forgetting
  • Detailed explanation of the solution to forget the root password of mysql in windows environment
  • Solution to forgetting the root password of mysql under windows
  • Solution to forgetting mysql password
  • Mysql forgotten password solution

<<:  js to achieve simple calendar effect

>>:  Implementation of Nginx domain name forwarding

Recommend

5 ways to quickly remove the blank space of Inline-Block in HTML

The inline-block property value becomes very usef...

Summary of several common methods of JavaScript arrays

Table of contents 1. Introduction 2. filter() 3. ...

$nextTick explanation that you can understand at a glance

Table of contents 1. Functional description 2. Pa...

React ref usage examples

Table of contents What is ref How to use ref Plac...

A simple LED digital clock implementation method in CSS3

This should be something that many people have do...

How to insert Emoji expressions into MySQL

Preface Today, when I was designing a feedback fo...

Detailed explanation of MySQL Group by optimization

Table of contents Standard execution process opti...

ftp remotely connect to Linux via SSH

First install ssh in Linux, taking centos as an e...

A brief discussion on how to write beautiful conditional expressions in JS

Table of contents Multiple conditional statements...

Use of CSS3's focus-within selector

Pseudo-elements and pseudo-classes Speaking of th...

HTML table only displays the outer border of the table

I would like to ask a question. In Dreamweaver, I...

Docker overlay realizes container intercommunication across hosts

Table of contents 1. Docker configuration 2. Crea...