配置mysql仅localhost可访问

navicat查询输入

USE mysql;
UPDATE user SET account_locked='Y' WHERE User='root' AND Host='%';

配置完查询 ：select host from user where user = 'root'; 结果为

成功！