How to change the database root password in phpmyadmin

First log in to phpmyadmin with the root account, then enter the mysql database, click "sql" 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.

Then click "Execute" in the lower right corner. If you see "Affected x rows", it means the modification is successful.

Then you need to enter the libraries directory under the phpmyadmin directory (the new version is this directory, or it may be in the root directory C:\wamp\apps\phpmyadmin3.5.1 ), modify the config.default.php file. Find $cfg['Servers'][$i]['password'] = ' ', change it to $cfg['Servers'][$i]['password']= ' 123456'; 123456 is the password you want.

The new password will take effect after restarting mysql.

Also modify the configuration file of your project in the www directory (C:\wamp\www\smarthome\Home\Conf) config.php, and modify the following two items

'DB_USER'=>'root' 'DB_PWD'=>'123456'

Done!

Recommended related articles and tutorials: phpmyadmin tutorial

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