phpmyadmin cannot log in using root
- 尚Original
- 2019-10-31 15:55:115676browse
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!
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Where is the phpmyadmin username and password?Next article：Where is the phpmyadmin username and password?