\ud658\uacbd <\/p>\n
OS : Ubuntu \/ CentOS
\nMYSQL : 5.6 version<\/p>\n
\ud2b9\uc815 \uc0ac\uc6a9\uc790 \uacc4\uc815\uc758 \uc678\ubd80\uc811\uc18d \ud5c8\uc6a9\ud558\uae30 – \uc5ec\uae30\uc11c\ub294 root \ub97c \uc608\ub85c \ub4e0\ub2e4. <\/p>\n
1. mysql \uc811\uc18d \ud6c4 mysql database \uc120\ud0dd
\nmysql> use mysql;<\/p>\n
2. user \ud14c\uc774\ube14 \uc0b4\ud3b4\ubcf4\uae30
\nmysql> select host, user, password from user;<\/p>\n
root \uc758 host \uac12\ub4e4\uc740 localhost, 127.0.0.1 \ub4f1\uc73c\ub85c \uae30\ubcf8 \ub4f1\ub85d\uc5d0
\n% \ub610\ub294 IP \ucd94\uac00<\/p>\n
3. \uad8c\ud55c \uc124\uc815
\nmysql -u root -p \ub85c \ub4e4\uc5b4\uac00\uc11c<\/p>\n
mysql> grant all privileges on *.* to ‘root’@’%’ identified by ‘root\uc758 \ud328\uc2a4\uc6cc\ub4dc’;
\nQuery OK, 0 rows affected (0.03 sec)<\/p>\n
4. \ub4f1\ub85d\ud655\uc778\ud558\uae30
\nmysql> select host, user, password from user;<\/p>\n
root \uacc4\uc815\uc758 host \ud544\ub4dc\uc5d0 % \uac00 \ub4f1\ub85d\ub418\uc5c8\ub294\uc9c0 \ud655\uc778\ud55c\ub2e4. <\/p>\n
5. refrash
\nmysql> flush privileges;
\nQuery OK, 0 rows affected (0.00 sec)<\/p>\n
\uc704 \ub2e8\uacc4\ub294 my.cnf \ud30c\uc77c \uc218\uc815\ud6c4 \uc11c\ubc84\ub97c \uc7ac\uc2dc\uc791\ud560 \uac83\uc774\uae30 \ub54c\ubb38\uc5d0 \uad73\uc774 \uc548\ud574\ub3c4 \ub41c\ub2e4. <\/p>\n
6. my.cnf \uc5d0\uc11c \uc678\ubd80\uc811\uc18d \uad00\ub828\uc0ac\ud56d \ubcc0\uacbd\ud558\uae30
\nuser@home:~$ sudo vim \/etc\/mysql\/my.cnf <\/p>\n
\ud30c\uc77c \ub0b4\uc6a9\uc911
\n#bind-address = 127.0.0.1
\n\ubd80\ubd84 \uc8fc\uc11d\ucc98\ub9ac\ud6c4 \uc800\uc7a5\ud558\uae30 <\/p>\n
7. mysql \uc7ac\uc2dc\uc791
\nuser@home:~$ sudo \/etc\/init.d\/mysql restart <\/p>\n
8. \uc644\ub8cc. <\/p>\n","protected":false},"excerpt":{"rendered":"