mysql远程登录

允许ip为192.168.1.123的主机连接到mysql服务器，用户名mysql密码mysql

GRANT ALL PRIVILEGES ON *.* TO 'mysql'@'192.168.1.123' IDENTIFIED BY 'mysql' WITH GRANT OPTION;

select * from user；发现权限已经进来了～搞定