Use phpMyAdmin to modify the default empty password for MySQL in xampp

XAMPP is a complete set of tools for developing PHP applications, just like installing software, others are configured so that they do not have to go through the cumbersome configuration of Apache, MySQL, PHP modules, which I used to be appserv, is also a very good PHP development tool Set, Just now the latest stable version only support php5.2.x and XAMPP can support to more than 5.3, so swap with XAMPP to develop PHP, Appserv installation will prompt you to enter the MySQL database root user password, set the code and other operations. But XAMPP without any hint, after the installation can directly access the Http://localhost/phpmyadmin management database, that is, the default MySQL password is empty, then we will set the password for MySQL.

MySQL database user information is stored in the database MySQL under the User data table, we use phpMyAdmin to see such as:

Then we click on SQL and run the SQL statement to update the data table contents,

UPDATE User SET Password=password (' password 'WHEREuser= ' Root ';

Password to your password, then click the Execute button in the lower right corner to execute it.

After the execution, the database password will be modified, and then next time to enter the phpMyAdmin will find that there is an error in the Go,

The reason is that after the password has been changed, phpMyAdmin has its own profile profile password has not been modified, its configuration file is the XAMPP installation directory under phpMyAdmin config.inc.php, open this file, will

$cfg [' Servers '] [$i] [' Password ']= ';

"Inside change to your password, the next login will go smoothly." Specific locations such as:

Use phpMyAdmin to modify the default empty password for MySQL in xampp