1.更改配置文件
sudo vi /etc/mysql/my.cnf
# 注释下面一行,否则window上面的客户端会报ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.x.x'
# bind-address = 127.0.0.1
2. 重新启动mysql服务
sudo service /etc/init.d/mysql restart
3. 配置mysql服务器
1) 登录Ubuntu上面的MySQL,并输入密码
mysql -u root -p
2)选择数据库
use mysql;
3)授权
grant all PRIVILEGES on *.* to 用户名@'客户端ip' identified by '密码';
4) 刷新
flush privileges;
5) 退出
quit