phpmyadmin cannot log in using root

phpMyAdmin is a MySQL database management tool based on PHP and structured in Web-Base mode on the website host, allowing administrators to use the Web interface to manage MySQL databases.

Mysql5.7 version, by default root prohibits logging in with a password through phpmyadmin.

So, after newly installing MySQL and phpmyadmin, if you use root to log in, the following prompt message will appear:

无法登录 MySQL 服务器
mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'

The most recent simple solution is to directly add a new complete server from the server command line. Account with permissions:

GRANT ALL PRIVILEGES ON *.* TO '用户名'@'localhost' IDENTIFIED BY '密码' WITH GRANT OPTION;

The above is the detailed content of phpmyadmin cannot log in using root. For more information, please follow other related articles on the PHP Chinese website!