我正在远程访问数据库。我可以使用用户名和密码通过终端访问数据库,但在浏览器中,它显示以下错误消息。
Cannot log in to the MySQL server mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)
命令的输出select user, host from mysql.user order by user;
| user | host |
+------------------+------------+
| debian-sys-maint | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| phpmyadmin | localhost |
| root | localhost |
| root | Ipaddress of remote system |
| root | % |
+------------------+------------+