Mysql远程访问
Mysql远程访问
Mysql安装后,只能在主机上通过localhost访问,不能通过远程,这就给远程调试在造成不可避免的干扰.因此,本文旨在修改Mysql的配置,能够通过远程访问Mysql的数据库.本机环境,Ubuntu16.04
1 修改/etc/mysql/mysql.conf.d/mysqld.cnf
#bind-address = 127.0.0.1
bind-address = 0.0.0.0
2 在终端中输入下面命令进入数据库
mysql -u root -p
3 选择数据库
USE mysql;
4 查看当前数据库的账号及登录方式
SELECT User, Host FROM user;
输出
+------------------+-----------+
| User | Host |
+------------------+-----------+
| root | localhost |
| debian-sys-maint | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| phpmyadmin | localhost |
+------------------+-----------+
5 rows in set (0.00 sec)
5 修改root的host为'%'
update user set host = '%' where user = 'root';
6 重启数据库,至此完成数据库的远程访问.
sudo service mysql restart