Set the phpmyadmin password (change the phpmyadmin password)

You can download phpmyadmin from the official website, and then modify config. cfg. php in the directory.

1. Use cookie authorization mode

Change 'auth _ type' to 'cooker', and then modify 'blowfish _ secret' to use an arbitrary string as the cookie's encrypted string. If no encryption key exists, the system displays "the configuration file currently requires a top secret phrase password (blowfish_secret)". The configuration file is as follows:

$ Cfg ['servers'] [$ I] ['auth _ type'] = 'cooker ';

$ Cfg ['blowfish _ secret'] = '44e2f5aece2855. 8080 ';

After the modification is completed, enter the logon window

Web login page in http authorization mode

II. Use the config authorization mode

Config requires these parameters:

$ Cfg ['servers'] [$ I] ['auth _ type'] = 'config'; // authorization mode

$ Cfg ['servers'] [$ I] ['user'] = 'root'; // mysql login user

$ Cfg ['servers'] [$ I] ['password'] = '000000'; // mysql login user password

3. Use http authorization mode

$ Cfg ['servers'] [$ I] ['auth _ type'] = 'http ';

Http authorization mode logon window

Note: If the mysql server uses version 4.1 or later and the client connection uses the mysql4.1 version, use the OLD_PASSWORD function when setting the password for the user. For example:

Mysql> set password = OLD_PASSWORD ('20140901 ')

Mysql>/G

What should I do if I forget my phpmyadmin password?

1. Disable the mysql service.

# Service mysql stop

If an error message such as mysql: unrecognized service is displayed.

First, check for mysql. server and use: find/-name "mysql. server"

Run the/usr/local/mysql/share/mysql. server stop command to disable mysql.

2. Start mysql in security mode to skip the authorization table.

First, check the mysqld_safe program. You can use the find/-name "mysqld_safe" command to find the program. It is in the mysql installation directory by default.

# Find/-name "mysqld_safe"

Start mysql in security mode to skip the authorization table

3. Log on to mysql with the root account and change the password to re-authorize

Create a connection to log on to the ECS

1) first enter the mysql-u root command to log on to mysql

2) enter update mysql. user set password = PASSWORD ('000000') where User = 'root'; update mysql password to 123456789

3) quit mysql

4. Restart the mysql service.

1) killall mysqld ends all mysql processes

2) service mysql start mysql

3) press enter from mysql-u root-p and enter the password, which is the mysql password you just reset.