Introduction to how to modify the root and phpmyadmin passwords of mysql in apmserv_PHP tutorial

apmserv is an integrated php mysql apache application development environment. After installation, it helped me configure the environment and phpmyadmin. Now I will introduce how to change the phpmyadmin password at the same time as changing the root password.

Use apmserv 5.2.6 to build a PHP environment and manage the mysql database through apmser.5.2.6. You will automatically enter the login interface of phpmyadmin. The root account password is empty by default. When entering phpmyadmin, you will be prompted to change the root password, otherwise it will be easy to be invaded.

The following provide two methods to change the root password:

1. Use phpmyadmin to change the root password

First log in to phpmyadmin with the root account, then click on the left to enter the mysql database, and click "mysql" on the top to enter the sql input interface. Enter the following command:

Enter cd D:/Program Files/APMSer5.2.6

The code is as follows

代码如下	复制代码
update user set password=password(’123456′) where User=’root’

Copy code

update user set password=password(’123456′) where User=’root’

Then click "Execute" in the lower right corner and see that the modification is successful.

Then you need to enter the libraries directory under the phpmyadmin directory and modify the config.default.php file.

Find $cfg['Servers'][$i]['password'] = ' ' and change it to $cfg['Servers'][$i]['password'] = '123456′; 123456 is the password.

Hurry up and log in now to try it out.

代码如下	复制代码
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

2. How to change Mysql password with APMserv

Enter the APMserv installation directory (assuming the current path is "D:/Program Files/APMServ5.2.6").

The code is as follows

Copy code

D:/Program Files/APMSer5.2.6>cd MySQL5.1/bin D:/Program Files/APMSer5.2.6/MySQL5.1/bin>mysqladmin -u root -p password 123456 As mentioned above. After running, you will be prompted to enter the original password (Enter Password): the default is empty and just press Enter Just restart APMserv.

http://www.bkjia.com/PHPjc/632914.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/632914.htmlTechArticleapmserv is an integrated php mysql apache application development environment. After installation, it helped me configure it. Environment and phpmyadmin, let me introduce how to change the root password while...