通过本文主要向大家介绍了mysql远程访问权限,mysql 远程访问,ubuntu mysql远程访问,mysql授权远程访问,mysql设置远程访问等相关知识,希望本文的分享对您有所帮助
user:myuser pwd:mypassword 从任何主机连接到mysql服务器
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
user:myuser pwd:mypassword 从192.168.1.3连接到mysql服务器
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
</div>