ERROR 1396 (HY000): Operation ALTER USER failed for ‘root‘@‘%‘

mysql8 执行这个报错 ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'%'

修改不了 host 允许远程连接

解决方法：

USE mysql;

SELECT user, host FROM user;

 可以看到 root 对应 host 是 localhost

+------------------+-----------+
| user             | host      |
+------------------+-----------+
| debian-sys-maint | localhost |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
+------------------+-----------+

UPDATE user SET host='%' WHERE user='root';

FLUSH PRIVILEGES;

+------------------+-----------+
| user             | host      |
+------------------+-----------+
| root             | %         |
| debian-sys-maint | localhost |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
+------------------+-----------+

现在就可以远程连接了