Shulou(Shulou.com)05/31 Report--

This article is about the root password of mysql database forgotten solution content. Xiaobian thinks it is quite practical, so share it with everyone for reference. Let's follow Xiaobian and have a look.

1. Log in to the system as root user and enter the terminal.

[root@localhost /]#

II. Kill the process

Method 1,[root@localhost /]#killall mysqld

Method 2.[root@localhost /]#ps -aux //View all processes and find the pid of the mysql process

then

[root@localhost /]#kill pid //pid is the process number of mysql

III. Start mysqld with the parameter--skip-grant-tables

[root@localhost /]#/usr/local/mysql/bin/mysqld_safe --skip-grant-tables&

//where/usr.../ bin is my mysql installation directory

[root#/usr/local/mysql/bin/mysql //enter mysql

mysql> use mysql //switch to mysql database

mysql> UPDATE user SET password=password('123456') WHERE user='root';

//Change the root password to 123456

Thank you for reading! About "mysql database root password forgotten solution" This article is shared here, I hope the above content can be of some help to everyone, so that everyone can learn more knowledge, if you think the article is good, you can share it to let more people see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.