Introduction of the root and phpMyAdmin cryptography methods in Apmserv to modify MySQL

Use Apmserv 5.2.6 build PHP environment, through the apmser.5.2.6 management MySQL database, will automatically enter the phpMyAdmin login interface, the root account password default is empty, enter the phpMyAdmin prompts need to modify root Passwords are otherwise vulnerable to intrusion.

Here are two ways to modify the root password:

1. Change the root password with phpMyAdmin

First with the root account login phpMyAdmin, and then click on the left to enter the MySQL database, at the top of the click "MySQL" into the SQL input interface. Enter the following command:

The code is as follows	Copy Code
Update user set Password=password (' 123456′) where user= ' root '

Then click "Execute" in the lower right corner to see that the modification was successful.

Then you have to enter the phpMyAdmin under the Libraries directory, modify config.default.php file.

Find $cfg[' Servers ' [$i] [' password '] = ', modified to $cfg[' Servers '] [$i] [' password '] = ' 123456′; 123456 is the password.

Now log in and try it.

2, Apmserv Modify the MySQL password method

Enter the Apmserv installation directory (assuming the current path is "D:/program Files/apmserv5.2.6″").

Input CD D:/program files/apmserv5.2.6

The code is as follows	Copy Code
D:/program FILES/APMSERV5.2.6>CD Mysql5.1/bin D:/program files/apmserv5.2.6/mysql5.1/bin>mysqladmin-u root-p Password 123456

Mentioned above.. Prompt to enter the original password (enter Password): Default Empty direct return

Restart Apmserv.