MySql出现ERROR 1062 (23000): Duplicate entry ‘%-root’ for key ‘PRIMARY’
如果执行update语句时出现ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY' 错误,说明有多个ROOT用户纪录在USER表中了.
需要select host from user where user = 'root';
查看是否设置成功
MySql出现ERROR 1062 (23000): Duplicate entry ‘%-root’ for key ‘PRIMARY’
如果执行update语句时出现ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY' 错误,说明有多个ROOT用户纪录在USER表中了.
需要select host from user where user = 'root';
查看是否设置成功