关于MySql数据库的使用,可以借助数据库管理工具Navicat等工具,以下介绍如何授权给外网去访问MySql数据库
Part One:任意主机以固定用户名及密码访问MySql数据库(此处以root和password为例)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root' @ '%' IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> flush privileges;
Part Two:IP为192.168.1.153的主机以用户myuser和密码mypwd连接到mysql服务器
mysql> GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.153' IDENTIFIED BY 'mypwd' WITH GRANT OPTION;
mysql> flush privileges;