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

Apmserv introduces how to change the password of mysql root and phpmyadmin. Apmserv is an integrated phpmysqlapache application development environment. after installation, it helps me configure the environment and phpmyadmin, next I will introduce how to change the root password and make apmserv an Integrated php mysql apache application development environment. after installation, I will help you 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

Log on to phpmyadmin with the root account, click mysql on the left to enter the mysql database, and click mysql on the top to enter the SQL input interface. Enter the following command:

The code is as follows:
Update user set password = password ('000000') where User = 'root'

Click "execute" in the lower-right corner. the modification is successful.

Go to the libraries directory under phpmyadmin and modify the config. default. php file.

Find $ cfg ['servers'] [$ I] ['password'] = '', change to $ cfg ['servers'] [$ I] ['password'] = '000000'; 123456 is the password.

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 ″).

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 .. after running, the system prompts you to Enter the original Password (Enter Password): The default value is null and press Enter.

Restart APMserv.

Mysql apache application development environment. after installation, I have configured the environment for me and phpmyadmin. next I will introduce how to change the root password...