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

What if phpmyadmin cannot log in with root? I believe that many inexperienced people are at a loss about this, so this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

PhpMyAdmin is a database management tool based on PHP and constructed on the host of the website in the way of Web-Base, which allows managers to use Web interface to manage MySQL database.

Mysql5.7 version, the default root forbids login through phpmyadmin with a password.

Therefore, after newly installing MySQL and phpmyadmin, if you log in using root, the following prompt appears:

Unable to log in to MySQL server mysqli_real_connect (): (HY000/1698): Access denied for user 'root'@'localhost'

The most recent simple solution is to add a fully privileged account directly from the server command line:

GRANT ALL PRIVILEGES ON *. * TO 'username' @ 'localhost' IDENTIFIED BY' password 'WITH GRANT OPTION; after reading the above, have you mastered the solution that phpmyadmin can't log in with root? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for 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.