Ubuntu 下使用mysql
# mysql -uroot -p
新建admin用户
> grant all PRIVILEGES on *.* to admin@"%" identified by "admin";
> use information_schema
> select * from USER_PRIVILEGES;
可查看新建的用户
注释掉 /etc/mysql/my.cnf中
bind-address = 127.0.0.1
最后重启 mysql
/etc/init.d/mysql restart
然后即可进行远程连接