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:
|
<<: js to achieve simple calendar effect
>>: Implementation of Nginx domain name forwarding
pt-heartbeat When the database is replicated betw...
1. Introduction I want to use selenium to scrape ...
I recently wrote a mobile page at work, which was...
Use examples to familiarize yourself with the mean...
The css technique for changing the color of an im...
This article shares with you how to import Excel ...
The LIKE operator is used in the WHERE clause to ...
1. Natural layout <br />The layout without a...
Preface I recently encountered this requirement a...
If you have a choice, you should use UTF-8 In fac...
What is k3d? k3d is a small program for running a...
This article introduces how to configure Nginx to...
Table of contents 1. Overview 2. Routing Navigati...
Table of contents Demand background Thought Analy...
I have recently studied the hollowing effect. bac...