What should I do if phpmyadmin cannot log in?

Solution to phpmyadmin 2045 being unable to log in: First open the console and enter [use mysql]; then enter [update user setpassword=PASSWORD (password to be modified)]; finally enter [flush privilege] .

Solution to phpmyadmin being unable to log in:

1. Open the mysql console of phpStudy and prompt for password. The starting password is empty, just press Enter

2. Enter [use mysql], the console prompts [Database changed]

3. Enter

update user set password=PASSWORD('要修改的密码') where user='root';

and the console prompts [ Query OK, XXXXXXXXX]

4. Finally enter [flush privileges;], submit

and then you can visit happily.

Related tutorial recommendations: phpmyadmin

The above is the detailed content of What should I do if phpmyadmin cannot log in?. For more information, please follow other related articles on the PHP Chinese website!