Solution to the problem that the default login of phpMyAdmin under XAMPP does not require verification

The following column phpMyAdmin Tutorial will introduce to you the solution to the problem that the default login of phpMyAdmin under XAMPP does not require verification. I hope it will be helpful to friends in need!

XAMPP defaultphpMyAdminLogin does not require verification and requires us to make some settings. Including the setting of the root user password and the setting of the phpMyAdmin configuration file.

1. Root user password setting.

You can choose to do it in the command prompt. Enter the xampp installation directory xampp/mysql/bin

Type the command "mysqladmin -u root -p password your password***" and press Enter to complete the settings

You can also enter phpmyadmin directly Here, the user table in the mysql library has root information, and the password can be set in it. It should be noted that it is best to use commands to set it and use the password function.

update user set password=PASSWORD(’123456′) where user=’root’;

2. Modify the configuration file of phpMyAdmin.

Enter the phpmyadmin directory under xampp, there is the configuration file config.inc.php, and enter the file. You can see the following content:

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = ‘http’;
$cfg['Servers'][$i]['user'] = ‘root’;
$cfg['Servers'][$i]['password'] = ”;
$cfg['Servers'][$i]['extension'] = ‘mysql’;
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = ”;

Pay attention to the place shown in red, you can modify it like this and it will be OK. To enter phpMyAdmin, you need to verify the account password.

The above is the detailed content of Solution to the problem that the default login of phpMyAdmin under XAMPP does not require verification. For more information, please follow other related articles on the PHP Chinese website!