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

Modify the password of the MySQL database in XAMPP

XAMPP serves developers only and cannot be used in production environments. First of all, the MySQL administrator (root) does not set a password, and users can access the mysql server directly through phpmyadmin, modify the data in the database, or access it over the network.

To secure the MySQL database, you must set a password for the MySQL administrator (root) as follows:

Log in to phpmyadmin as root user, and set the password of root user in the permissions of phpmyadmin. The operation interface is as follows:

Figure 1

Figure 2

After you change the MySQL database password, you also change the relevant information in phpmyadmin. The methods are as follows:

Find phpMyAdmin in the xampp file and modify its configuration file, that is, the config.inc.php file, which needs to be modified as follows:

Figure 3

Set auth_type to "http"; set the value of password to your own password. Then access the database through the browser.

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.