Get the App
SLTechnology News&Howtos  ›  Development  › 

The default login of phpMyAdmin under XAMPP does not require verification.

Shulou Source: shulou.com Published: 2022-06-03 05:24:20 11月22日 Update

This article shows you the default login of phpMyAdmin under XAMPP does not need to verify the solution, the content is concise and easy to understand, absolutely can make your eyes bright, through the detailed introduction of this article, I hope you can get something.

XAMPP default phpMyAdmin login does not require verification, we need to make some settings. Including root user password settings, and phpMyAdmin configuration file settings.

1. Root user password setting.

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

Type the command "mysqladmin-u root-p password your password * *" and type enter to complete the setting.

You can also directly enter the phpmyadmin, mysql library in the user table, there is root information, you can set the password inside. It is important to 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'

two。 Modify the configuration file for phpMyAdmin.

Go to the phpmyadmin directory under xampp and enter the configuration file config.inc.php into the file. 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'] ="

Pay attention to the red display. You will OK if you change it to this. To re-enter phpMyAdmin, you need to verify your account password.

The above is the solution to the default login of phpMyAdmin under XAMPP without verification. Have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Tags: Password authentication file content command configuration method login skill user directory knowledge concise concise information function place that is prompt article Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Shulou Information Linux MySQL Xiaomi macOS