ubuntu设置mysql远程访问

ubuntu上搭建mysql服务器,远程访问。

1 设置配置文件,把bind-address的那行注释了。

2 mysql中执行grant all PRIVILEGES on db_name.* to ‘username’@’xxx.xxx.xx.x’ identified by ‘password’ WITH GRANT OPTION;