Modify the password for the MySQL database in XAMPP

Modify the password for the MySQL database in XAMPP

XAMPP is only for developers and cannot be used in production environments. First, the MySQL administrator (root) does not set a password, and the user can access the MySQL server directly through phpMyAdmin, modify the data in the database, or access it over the network.

To ensure the security of your MySQL database, you must set the password for MySQL administrator (root) as follows:

log in as root user phpMyAdmin, set the root user's password in the phpMyAdmin permissions, the interface is as follows :

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/8D/27/wKiom1iPUvXTzuTpAAHrZAanBLU072.jpg-wh_500x0-wm_3 -wmp_4-s_1984165741.jpg "title=" 2017-01-30_223336.jpg "alt=" Wkiol1ipt3wy6d4naahrzaanblu643.jpg-wh_50 "/>

Figure 1

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/8D/27/wKiom1iPUw3BHTYbAAJNLUAqKk0373.jpg-wh_500x0-wm_3 -wmp_4-s_4220005905.jpg "title=" 2017-01-30_223717.jpg "alt=" Wkiom1ipugczlijyaajnluaqkk0675.jpg-wh_50 "/>

Figure 2

After you change the MySQL database password, also change the information in the phpMyAdmin. Here's how:

In the Xampp file found phpMyAdmin, modify its configuration file, that is, the config.inc.php file, need to be modified as follows:

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M01/8D/25/wKioL1iPUzGwhOhUAABhzDvsZao803.jpg-wh_500x0-wm_3 -wmp_4-s_3385476662.jpg "title=" qq20170130224514.jpg "alt=" Wkiol1ipuynj-prtaabhzdvszao679.jpg-wh_50 "/>

Figure 3

Set Auth_type to "HTTP"; Set the value of password to its own password. The database is then accessed through the browser.

This article is from the "Rangers" blog, please be sure to keep this source http://ccnupxz.blog.51cto.com/8803964/1894438

Modify the password for the MySQL database in XAMPP