centos - 弱弱的问一下，mysql如何能做到本地与指定内网ip同时访问？

Question

centos下如何做到如题，由于要做平衡数据库迁移，谢谢！

Answer 1

update mysql.user set Host = '127.0.0.1' where User = 'root';
This is the modification

If there are several IPs, copy this record and leave other fields unchanged, just change the host