Graphical steps to change mysql password on Xampp server

If we use the Xampp server’s own database mysql, we must first change the mysql password. The following editor will share with you how to change the mysql password on the Xampp server. Friends who need it can refer to it

Today myself In the process of working on PHP, I found that if we use the Xampp server's own database MySQL, we must first change the password of MySQL. As we all know, the initial interface of MySQL is empty, but if the password is empty when connecting to the database, an error will be reported. I found many solutions to similar problems on the Internet. They all open the command console of mysql. The solution is as shown below

But according to what is said on the Internet, just sit down and follow the steps. There is a problem, the mysql password has not been changed. Next, I will introduce you to the steps to successfully change it:

1. Click MySQL admin to enter the phpMyAdmin page;

2. Click Account to enter the account management page;

3. Select the root localhost account and click Modify Permissions;

4. Enter the page as shown below and click to change the password;

5. After designing your own password, click Execute. At this time, the password has been modified. Success, but a problem arises. This page is no longer a phpMyAdmin page, but access is denied because we changed the mysql access password;

6. Open Xampp\phpMyAdmin\config_inc.php file, change the config in the picture below to cookie. At this time, the entire step of changing the mysql password is completed, then restart Xampp, click to refresh the phpMyAdmin page and you can proceed.

The above is the detailed content of Graphical steps to change mysql password on Xampp server. For more information, please follow other related articles on the PHP Chinese website!