[mysql] root 암호 바꾸기, 외부 접근하기

[mysql] root 암호 바꾸기, 외부 접근하기

mysql>

mysql> use mysql;
Database changed
mysql> update user set password=password('!password') where user='root';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 3  Changed: 0  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'root'@'%' identified by '!password';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql>

[mysql] root 암호 바꾸기, 외부 접근하기