[MySql] 외부 접속 설정

mysql> select host, user from user;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| %         | root             |
| 127.0.0.1 | root             |
| ::1       | root             |
| localhost | debian-sys-maint |
| localhost | root             |
+-----------+------------------+
5 rows in set (0.00 sec)

mysql>

%는 모든 아이피로부터 접속 허용.

$ update user set host = "%" where host = "127.0.0.1" and user = "root";
$ flush privileges;