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

Editor to share with you how to solve the problem that phpmyadmin can not log in. I hope you will gain a lot after reading this article. Let's discuss it together.

Stop the mysql service

Service mysql stop

Set database permissions to allow everyone to log in, that is, skip verification (if you are interested, you can take a look at the skip-grant command, which I have little knowledge of)

Mysqld-skip-grant-tables

After the execution of the command, we have logged in without verification, and then set up authentication and add users.

Mysqld-skip-grant-tables-user=root (root is the user name you want to set.-Don't be wrong)

Then open a remote link, the current terminal does not need to be closed, at this time, we do not need a password to log in directly.

Mysql-u root-p

After logging in, we use the mysql command to set the username and password we want.

After reading this article, I believe you have a certain understanding of how to solve the problem that phpmyadmin can not log in. Want to know more about it. Welcome to follow the industry information channel. Thank you for your reading!

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.