Shulou(Shulou.com)06/01 Report--

Xiaobian to share with you under XAMPP phpMyAdmin default login does not need to verify how to do, I believe most people do not know how to share this article for your reference, I hope you read this article after a great harvest, let us go to understand it!

XAMPP default phpMyAdmin login is not required to verify, we need to make some settings. Includes settings for root password and phpMyAdmin profile.

1. Root password settings.

You can choose to do it at the command prompt. Go to xampp/mysql/bin under xampp installation directory

Type in the command "mysqladmin -u root -p password ***" Type Enter to complete the setup

You can also directly enter phpmyadmin, mysql library user table, there is root information, you can set the password inside. Note that it is best to use the command to set it, using the password function.

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

2. Modify the phpMyAdmin configuration file.

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

/* 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'] = ";

Note the red display, you modify it like this is OK. Enter phpMyAdmin to verify your password.

The above is "phpMyAdmin default login under XAMPP does not need to verify how to do" all the content of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.