Xampp to modify the Mysql default null password (root password) method to share _mysql

Referring to some of the methods provided on the Internet, it is very complicated to find that. Here's a quick and easy way to share.

First, the information about the MySQL user is stored in the user table of the MySQL database, and the password field (Password) of the table is stored through the Password method.

Understand the above prompts, then modify the password is simple, run the following SQL statement directly (this will modify the password to jb51.net):

Copy Code code as follows:

UPDATE user SET Password=password (' jb51.net ') WHERE user= ' root ';

After the above operation, the password is modified.

If you want to enter the Localhost/phpmyadmin directly in the future can also go directly to the phpMyAdmin management interface without entering the username and password, you need to do the following:

Locate the phpMyAdmin configuration file, the config.inc.php in the phpMyAdmin directory, and locate the following code:

Copy Code code 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;

Copy Code code as follows:

/* Authentication type and Info * *
$cfg [' Servers '] [$i] [' auth_type '] = ' config ';
$cfg [' Servers '] [$i] [' user '] = ' root ';
$cfg [' Servers '] [$i] [' password '] = ' jb51.net ';
$cfg [' Servers '] [$i] [' extension '] = ' mysql ';
$cfg [' Servers '] [$i] [' allownopassword '] = true;