mysql配置远程连接踩坑2022-11-08 07:46:34 问题一 Duplicate entry '%-root' for key 'PRIMARY' select user,host from user; 查看是否已经有 host为’%'的root用户 #刷新mysql flush privileges; #删除掉host为localhost的用户 delete from user where user = ‘root’ and host = ‘localhost’; #再次刷新,重启mysql即可 flush privileges; 上一篇:如何在suse机器上授予“无root用户”权限来启动/停止/重启mysql服务器?下一篇:Navicat连接阿里云服务器MSQL数据库