How to modify the mysql password on the Xampp server (illustration), xamppmysql

How to modify the mysql password on the Xampp server (illustration), xamppmysql

Today, when I was engaged in php, I found that if we use the Xampp server's built-in database mysql, we must first modify the mysql password. As we all know, the initial mysql surface is empty, however, if the password used to connect to the database is blank, an error will be reported. Many methods to solve similar problems are found on the Internet, which are to open the mysql command console. The solution is as follows:

However, according to the online statement, there is still a problem following the steps, and the mysql password has not been changed. Next I will introduce you to the steps for successful modification:

1. Click MySQL admin to enter the phpMyAdmin page;

2. Click an account to go to the Account Management page;

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

4. Go to the page shown in, and click Change Password;

5. After designing your own password, click execute. The password has been modified successfully, but the problem is that the phpMyAdmin page is no longer displayed, but access is denied, the reason is that we modified the mysql access password;

6. Open the Xampp \ phpMyAdmin \ config_inc.php file, change the config in the following image to cookie, complete the mysql password modification step, and restart Xampp, click to refresh the phpMyAdmin page.