当前位置:Gxlcms > 数据库问题 > kali配置phpmyadmin报错mysqli::__construct(): (HY000/1698): Access denied for user 'root'@'localhost' 解决办法

kali配置phpmyadmin报错mysqli::__construct(): (HY000/1698): Access denied for user 'root'@'localhost' 解决办法

时间:2021-07-01 10:21:17 帮助过:7人阅读

* * MySQL user * * @global string $cfg[‘Servers‘][$i][‘user‘] */ $cfg[Servers][$i][user] = root_sql; /** * MySQL password (only needed with ‘config‘ auth_type) * * @global string $cfg[‘Servers‘][$i][‘password‘] */ $cfg[Servers][$i][password] = yourpasswd;

注(ip为127.0.0.1    端口为空) 

 

 

4.登录即可

账号:root_sql         密码:yourpasswd

 

当然以上情况是新建用户赋予权限,但是如果你想把本来的phpmyadmin账户赋予所有权限,那么你只要执行

GRANT ALL PRIVILEGES ON *.* TO ‘phpmyadmin‘@‘localhost‘ IDENTIFIED BY ‘yourpasswd‘;
FLUSH PRIVILEGES;
然后再执行2,3步操作就行了

kali配置phpmyadmin报错mysqli::__construct(): (HY000/1698): Access denied for user 'root'@'localhost' 解决办法

标签:ges   模式   sql   string   art   host   账户   dmi   用户权限   

人气教程排行