_php tutorial on modifying the root and phpMyAdmin password methods of MySQL in Apmserv

Apmserv is an integrated PHP MySQL Apache application development environment, after installation to help me configure the environment and there are phpmyadmin, below I would like to change the root password at the same time to change the phpMyAdmin password.

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

Two ways to change the root password are provided below:

1. Change the root password with phpMyAdmin

First login to the phpMyAdmin with the root account, then click on the left to enter the MySQL database, click on the top of "MySQL" to enter 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 on "Execute" in the bottom right corner to see the changes succeed.

Then go to the Libraries directory under phpMyAdmin and modify the config.default.php file.

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

Now get on the landing 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 for the original password after running (enter Password): Default empty direct carriage return

Restart the Apmserv.

http://www.bkjia.com/PHPjc/632914.html www.bkjia.com true http://www.bkjia.com/PHPjc/632914.html techarticle Apmserv is an integrated PHP MySQL Apache application development environment, after installation to help me configure the environment and there are phpmyadmin, let me introduce in the change root password at the same time ...

