navicat 远程连接 mysql

use mysql
-- 查看用户
select host,user from user;
-- 更新host
update user set host='%' where user='laremehpe';
-- 授予laremehpe用户 user表的查看、添加、更新权限
grant select,insert,update on user.* to 'laremehpe'@'%' with grant option;
-- 授予laremehpe用户所有表的远程管理权限
grant all privileges on *.* to 'laremehpe'@'%';