There are many ways to change the mysql password. The most common method is to use phpmyadmin to change the password. it is very difficult to modify the mysql password in command mode if we don't want to run commands like ours, next I will introduce phpmyadmin to modify mys... there are many ways to change the mysql password. The most common method is to use phpmyadmin to change the password. it is very difficult to modify the mysql password in command mode if we don't want to run commands like ours, next, I will introduce phpmyadmin's method for changing the mysql password.
Password change method:
1. log on to the phpmyadmin console in a browser and click "permission ".
2. check the root user and click "edit permission ".
3. in the middle of the page, find the "change password" column, enter the new password twice, and click the "execute" button.
Note: after you change the password, you will be prompted when you use phpmyadmin to log on. after you fix the Mysql password in phpMyAdmin, phpMyAdmin cannot log on. The error message is:
Welcome to phpMyAdmin 2.9.0
Probably reason of this is that you did not create configuration file. You might want to use setup script to create one.
Error
MySQL returns:
#1045-Access denied for user: 'root @ localhost' (Using password: NO)
Solution:
Go to the installation directory of xampp and modify xampp/phpMyAdmin/config. inc. in the php file, locate and set the password to start modification. for example, $ cfg ['servers'] [$ I] ['password'] = '2016 ';
In addition, after clicking "permission", we can see the users of the entire database as follows. you can click "operation" to change the user password again and modify config. inc. php.
Article link:
Save this article for favorites!