How to change the account password in phpmyadmin?

How to change the account password in phpmyadmin?

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

2. Go in and you can see the administrator's account name list, and the administrator list that needs to be modified. Click "Edit Permissions"

3. There will be a password box at the bottom of the page. Just enter it and save it.

Remember, after the change, you need to modify your login password in phpmyadmin's config.inc.php, otherwise phpmyadmin cannot connect to mysql

You need to modify phpmyadmin's Configuration file, use Notepad to open the config.inc.php file, find the following parts and modify

$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['user'] = '这里填写用户名';
$cfg['Servers'][$i]['password'] = '这里填写你的MySQL密码';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

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

Recommended: phpMyAdmin usage tutorial

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