mysql 외부접근 허용

mysql 외부접근 허용


mysql> INSERT INTO mysql.user (host,USER,password) VALUES ('192.168.0.0.','root',password('Password'));

Query OK, 1 row affected, 3 warnings (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@192.168.0.0.;

Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)