Set the phpmyadmin password (change the phpmyadmin password)

Source: Internet
Author: User
Tags auth mysql in mysql login phpmyadmin


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.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.