Shulou(Shulou.com)06/01 Report--

This article mainly introduces the error can not log on to phpmyadmin how to do, the article is very detailed, has a certain reference value, interested friends must read it!

The solution to being unable to log in to phpmyadmin due to an error:

Find config.inc.php and change the password directly.

If you can't find it, create your own config.inc.php file and put it in the first episode folder:

$cfg ['PmaAbsoluteUri'] = "; $cfg [' Servers'] [1] ['host'] =" localhost "; $cfg [' Servers'] [1] ['auth_type'] =' config';$cfg ['Servers'] [1] [' user'] =" root "; $cfg ['Servers'] [1] [' password'] =" your new password ";? >

1 phpmyadmin phpmyadmin cannot log in after changing the password. It is possible that phpmyadmin failed to change the phpmyadmin password, so you can log in by using the original password directly.

Mysql reset password:

Mysql > use mysqlmysql > set password for 'root'@'localhost'=password (' newpasswd'); mysql > set password for 'root'@'%'=password (' newpasswd')

2, it is also possible that I forgot the password I just changed. You can change the Mysql password by following the steps below

The specific steps are as follows:

1. Close the running MySQL.

2. Open the DOS window and change to the mysql\ bin directory.

3. Enter mysqld-nt-- skip-grant-tables enter. If there is no prompt, that's right.

4. Open another DOS window (because the DOS window just now cannot be moved), and change to the mysql\ bin directory (cd).

5. Enter mysql to enter. If successful, the MySQL prompt will appear >

6. Connect permissions database > use mysql; (> is an existing prompt, don't forget the last semicolon)

7. Change password: > update user set password=password ("123") where user=" 123"

8. Refresh permissions (required) > flush privileges

9. Exit >\ Q

10. Log out of the system, re-enter, open MySQL, and log in with the user name 123 and the new password 123 you just set.

The above is all the contents of the article "what to do if you can't log in to phpmyadmin if there is an error?" Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.