How to modify the password of mysql root and phpmyadmin in apmserv

Apmserv is an integrated phpmysqlapache application development environment. after installation, it helps me configure the environment and phpmyadmin, next I will introduce phpmyadmin password while modifying the root password... apmserv is an Integrated php mysql apache application development environment. after installation, it helps me configure the environment and phpmyadmin, next I will introduce how to change the phpmyadmin password while modifying the root password.

Using apmserv 5.2.6 to build a PHP environment, and managing the mysql database through apmser.5.2.6 automatically enters the phpmyadmin logon interface. the root account password is blank by default, when you enter phpmyadmin, the system prompts you to change the root password or the password will be vulnerable to intrusion.

The following two methods are provided to change the root password:

1. use phpmyadmin to change the root password

First, log on to phpmyadmin with the root account, click on the left to enter the mysql database, click "mysql" on the top to enter the SQL input interface, and enter the following command:

Update user set password = password ('000000') where User = 'root'

Click "execute" in the lower-right corner. the modification is successful. then, go to the libraries directory under The phpmyadmin directory and modify the config. default. php file.

Find $ cfg ['servers'] [$ I] ['password'] = '', change it to $ cfg ['servers'] [$ I] ['password'] = '000000'; 123456 is the password. please try logging in now.

2. how does APMserv modify the Mysql password?

Go to the APMserv installation directory (assuming the current path is "D:/Program Files/APMServ5.2.6") and enter cd D:/Program Files/APMServ5.2.6. the code is as follows:

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

As mentioned above, the system prompts you to Enter the original Password (Enter Password) after running: the default value is null. press Enter to restart APMserv.

Address:

Reprinted at will, but please attach the article address :-)