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

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

How to solve the problem that phpMyAdmin cannot log in in linux

Problem description

First of all, log in on phpmyadmin and show that you can't log in, because mysql is reinstalled, so I tried to find the login password before, but as I said on the Internet, the first login is usually the user name root, then the password is empty, and then login directly on the web page and find that I still can't log in.

Solution method

Then I tried to log in in the linux terminal and found a lot of ways on the Internet.

Here is a hint that it is best not to go directly to the file to change, which may cause the whole program to collapse directly, but when you forget your password, you can go to config.default.php to check the password.

The following is the case where you cannot log in on shell

No more nonsense, here are the steps to solve the problem

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.

That's it. Problem solved.

The above is all the contents of the article "what to do if phpMyAdmin can not log in in linux". 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.