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
The inline-block property value becomes very usef...
Table of contents 1. Introduction 2. filter() 3. ...
Table of contents 1. Functional description 2. Pa...
Table of contents Written in front Environment de...
Table of contents What is ref How to use ref Plac...
<div class="box"> <img /> &...
This should be something that many people have do...
Preface Today, when I was designing a feedback fo...
Table of contents Standard execution process opti...
First install ssh in Linux, taking centos as an e...
Table of contents Multiple conditional statements...
Pseudo-elements and pseudo-classes Speaking of th...
I would like to ask a question. In Dreamweaver, I...
Table of contents 1 Introduction 2 Prerequisites ...
Table of contents 1. Docker configuration 2. Crea...