Where is the phpmyadmin password saved?

Where is the phpmyadmin password saved?

phpmyadmin itself has no password, the password is actually in the databasemysqlInside, you can reset the root password through mysql.

Modify phpmyadmin root password

1. First log in to phpmyadmin with the root account, then click on the left to enter the mysql database, and click "mysql" at the top to enter the sql input interface. Enter the following command:

update user set password=password('123456') where User='root'

where 123456 is the password you want to change. Remember not to manually change the password directly in the database.

2. Then enter the libraries directory under the phpmyadmin directory and modify the config.default.php file. Find $cfg['Servers'][$i]['password'] = ' ', change

to $cfg['Servers'][$i][ 'password'] = '123456';

123456 is the password you want.

3. The new password will take effect after restarting mysql.

For more PHP related knowledge, please visit PHP Chinese website!

The above is the detailed content of Where is the phpmyadmin password saved?. For more information, please follow other related articles on the PHP Chinese website!