How to forget the mysql password under Linux

This article mainly introduces "how to forget the mysql password under Linux". In the daily operation, I believe that many people have doubts about how to forget the mysql password under Linux. The editor consulted all kinds of information and sorted out a simple and easy-to-use method of operation. I hope it will be helpful to answer the doubt of "how to forget the mysql password under Linux". Next, please follow the editor to study!

The initial password is empty. Log in to mysql with an empty password to execute the following statement

Mysql > use mysql;mysql > update user set password=password ("root") where user='root';mysql > flush privileges;mysql > quit; Modification / opt/lampp/phpmyadmin/config.inc.php

Find the following code:

$cfg ['servers'] [$I] [' auth_type'] = 'config';$cfg [' servers'] [$I] ['user'] =' root';$cfg ['servers'] [$I] [' password'] =''; $cfg ['servers'] [$I] [' extension'] = 'mysql';$cfg [' servers'] [$I] ['allownopassword'] = true

Modified to:

$cfg ['servers'] [$I] [' auth_type'] = 'config';$cfg [' servers'] [$I] ['user'] =' root';$cfg ['servers'] [$I] [' password'] = 'root';$cfg [' servers'] [$I] ['extension'] =' mysql';$cfg ['servers'] [$I] [' allownopassword'] = true; at this point, the study of "how to forget mysql password under Linux" is over. I hope to solve everyone's doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!