XAMPP Modify the Mysql default password method _mysql

Here to introduce xampp modify the MySQL default password probably the process is to use the XAMPP phpMyAdmin into the modified MySQL password, modify the XAMPP after we modify the password phpMyAdmin, so that the complete revision of the MySQL default password.

About the process

In MySQL, set the password to open IE input URL localhostphpadmin, point users see the root user, pull down, find the place to modify the password, enter the password, carry out the operation, and finally go to your XAMPP installation directory to find the Phpadmin folder, Open the Find config.inc.php file, open to find a MySQL configuration to change the config cookie to the password where it is just set the password.

Specific methods

Enter Http://localhost/phpmyamdin on the browser address into the database Control Panel, and then select the name for the MySQL database, as shown in the user table, where the two user's password for root is null.

We can manually edit the password of the root user in the image database above. Point quick Edit, or edit can edit the password, such as password: 123456, then fill out "*6bb4837eb74329105ee4568dda7dc67ed2ca2ad9" (excluding quotes)

After editing the following figure

If you want to change the password to another, you can directly execute the west of the SQL statement, the new_password into their own password can be:

UPDATE user SET Password=password (' New_password ') WHERE user= ' root ';

In addition, since the MySQL root user password has been modified, then the corresponding password configuration in phpMyAdmin to be modified to find the configuration file, such as mine is

f:mppphpmyadminconfig.inc.php

Find the following code

The code is as follows

Authentication type and Info * * $cfg [' Servers '] [$i] [' auth_type ']
= ' config '; $cfg [' Servers '] [$i] [' user ']
= ' Root '; $cfg [' Servers '] [$i] [' password ']
= '; $cfg [' Servers '] [$i] [' extension ']
= ' mysql '; $cfg [' Servers '] [$i [' Allownopassword ']
= true;

Amended to

The code is as follows

Authentication type and Info * * $cfg [' Servers '] [$i] [' auth_type ']
= ' config '; $cfg [' Servers '] [$i] [' user ']
= ' Root '; $cfg [' Servers '] [$i] [' password ']
= ' 123456 '; $cfg [' Servers '] [$i] [' extension ']
= ' mysql '; $cfg [' Servers ' [$i] [' allownopassword ']
= true;

This will require you to restart the login phpMyAdmin.

The above is a small set to introduce the XAMPP to modify the MySQL default password method, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!