How to change the administrator password in phpmyadmin

phpmyadmin How to change the administrator password:

Recommended: phpmyadmin introductory tutorial

1. After logging in to phpMyAdmin, See the "Permissions" link at the top,

2, go in and you can see the list of administrator account names, click "Edit Permissions" in the list of administrators that need to be modified,

3, on the page There will be a password box below, just enter it and save it.

After completing the modification, you need to modify your login password in config.inc.php of phpmyadmin, otherwise phpmyadmin cannot connect to mysql.

You need to modify the configuration file of phpmyadmin. Open the config.inc.php file with Notepad, find the following parts and modify them

$cfg['Servers'][$i ]['host'] = 'localhost';

$cfg['Servers'][$i]['port'] = '3306';

$cfg['Servers' ][$i]['user'] = 'Fill in your username here';

$cfg['Servers'][$i]['password'] = 'Fill in your MySQL password here';

$cfg['Servers'][$i]['AllowNoPassword'] = true;

After saving config.inc.php, restart the server to access phpmyadmin.

Related recommendations: PHP video tutorial

The above is the detailed content of How to change the administrator password in phpmyadmin. For more information, please follow other related articles on the PHP Chinese website!