Mysql局域网访问授权

如果允许用户myuser从ip为192.168.1.1的主机连接到mysql服务器，并使用password作为密码

 

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.1' IDENTIFIED BY 'password' WITH GRANT OPTION;