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

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.