{"id":32,"date":"2015-12-08T06:28:52","date_gmt":"2015-12-08T06:28:52","guid":{"rendered":"http:\/\/www.onepage.co.kr\/wordpress\/?p=32"},"modified":"2016-04-01T00:28:24","modified_gmt":"2016-03-31T15:28:24","slug":"mysql-remote-rootor-user-access-authorization-config","status":"publish","type":"post","link":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/2015\/12\/08\/mysql-remote-rootor-user-access-authorization-config\/","title":{"rendered":"[MySQL] \uc6d0\uaca9\uc5d0\uc11c Root(or user)\ub85c \uc811\uc18d\ud5c8\uc6a9 \ubc0f \ubaa8\ub4e0\uad8c\ud55c \uc124\uc815"},"content":{"rendered":"

\u200b<\/a><\/p>\n

http:\/\/jonnychoe.egloos.com\/5217253<\/div>\n
<root\ub85c \ub85c\uadf8\uc778><\/div>\n
# mysql -uroot -p<\/div>\n
password: *****<\/div>\n
<\/div>\n
mysql>use mysql<\/div>\n
<\/div>\n
<\ub85c\uadf8\uc778 \ud560\u00a0\uc0ac\uc6a9\uc790 \uc0dd\uc131><\/div>\n
mysql>insert into user(host,user,password) values(‘\uc811\uc18d\ud5c8\uc6a9\ud560 \ud638\uc2a4\ud2b8\ub124\uc784 or IP’,’root’,password(‘\ud328\uc2a4\uc6cc\ub4dc’));<\/div>\n
<\/div>\n
<\uad8c\ud55c\uc8fc\uae30><\/div>\n
mysql>\u00a0grant all privileges on *.* to ‘root’@’%’ identified by ‘\uc554\ud638’ with grant option;<\/div>\n
mysql> flush privileges<\/div>\n
<\/div>\n
mysql> select * from user where User = ‘root’<\/div>\n
<\/div>\n
<\uc6d0\uaca9\uc9c0\uc5d0\uc11c \uc811\uc18d : -h \uc635\uc158><\/div>\n
# mysql -h\u00a0host -u user -p<\/div>\n
<\/div>\n
<\/div>\n
\ucd08\uae30 mysql root \ud328\uc2a4\uc6cc\ub4dc \uc124\uc815 \ubc0f \ube44\ubc88 \ubcc0\uacbd\uacfc root \ube44\ubc88 \uc783\uc5b4\ubc84\ub838\uc744 \uacbd\uc6b0 \ubcc0\uacbd \ud558\ub294\ubc29\ubc95<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
1. \ucd08\uae30 mysql root \ud328\uc2a4\uc6cc\ub4dc \uc124\uc815\ud558\uae30<\/div>\n
mysql \uc11c\ubc84\uc5d0 \ud328\uc2a4\uc6cc\ub4dc \uc5c6\uc774 \ub85c\uadf8\uc778 \ud558\uac8c\ub418\uba74 \uc11c\ubc84\uc5d0 \ub9cc\ub4e4\uc5b4\uc9c4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub098 \ud14c\uc774\ube14<\/div>\n
\uae30\ud0c0 \uc774\uacf3\uc5d0 \uc800\uc7a5\ub41c \uc790\ub8cc\uac00 \uc678\ubd80\uc778\uc5d0\uac8c \ub178\ucd9c\ub420 \uc218 \uc788\ub2e4. \ub530\ub77c\uc11c \uc774\ub7ec\ud55c \ubcf4\uc548\uc744 \ubaa9\uc801\uc73c\ub85c<\/div>\n
root \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc9c0\uc815\ud558\uba74 mysql \uc11c\ubc84\ub97c \uc548\uc804\ud558\uac8c \ubcf4\ud638\ud560 \uc218 \uc788\ub2e4.<\/div>\n
<\/div>\n
mysql> use mysql;<\/div>\n
mysql> update user set password=password(‘123456′) where user=’root’;<\/div>\n
Query OK, 2 rows affected (0.03 sec)<\/div>\n
Rows matched: 2 Changed: 2 Warnings: 0<\/div>\n
mysql> flush privileges; <— \uc801\uc6a9<\/div>\n
flush privileges; \ub97c \ud558\uc9c0 \uc54a\uc73c\uba74 mysql\uc5d0\uc11c \ube60\uc838\ub098\uc640\uc11c root \ub85c\uadf8\uc778\uc774 \uc548\ub41c\ub2e4.<\/div>\n
\ud655\uc778\ud55c\ub2e4.<\/div>\n
mysql> select host, user, password from user;<\/div>\n
+—————————————————————-+<\/div>\n
| Host user password |<\/div>\n
+—————————————————————-+<\/div>\n
| localhost root 2e01146f5c065853 |<\/div>\n
| localhost.localdomain root 2e01146f5c065853 |<\/div>\n
+—————————————————————-+<\/div>\n
<\/div>\n
mysql> \\q<\/div>\n
Bye<\/div>\n
————————————————————————————<\/div>\n
[\uc8fc\uc758]# mysql -u root -p<\/div>\n
Enter password:<\/div>\n
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)<\/div>\n
\uadf8\ub300\ub294 mysql \uc744 shutdown \ud558\uac70\ub098 reload \ud558\uba74 \ub41c\ub2e4.<\/div>\n
# \/usr\/local\/mysql\/bin\/mysqladmin -u root -p shutdown<\/div>\n
\ud558\uba74 \ud328\uc2a4\uc6cc\ub4dc\ub97c \ubb3b\ub294\ub370 \uc774\ub54c \uc785\ub825\ud558\uba74 \uc124\uc815\ud55c mysql\uc774 \uc801\uc6a9\uc774\ub41c\ub2e4.<\/div>\n
# \/usr\/local\/mysql\/bin\/mysqladmin -u root -p reload;<\/div>\n
————————————————————————————<\/div>\n
<\/div>\n
# mysql -u root -p [Enter] \/\/ root \ud328\uc2a4\uc6cc\ub4dc\ub85c \ub85c\uadf8\uc778<\/div>\n
Enter password: ******<\/div>\n
<\/div>\n
\u203b Mysql \uc11c\ubc84\uc5d0 root \ud328\uc2a4\uc6cc\ub4dc\uac00 \uc124\uc815\ub418\uba74 \uc774\uc81c \ubd80\ud130\ub294 mysql \uc11c\ubc84\uc5d0 \uc811\uc18d\ud558\uae30 \uc704\ud574\uc11c\ub294\u00a0<\/span><\/div>\n
\uc704\uc640 \uac19\uc774 -u \ub4a4\uc5d0 root\uc785\ub825\ud558\uace0 -p \uc635\uc158\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc0ac\uc6a9\ud55c\ub2e4\ub294 \uac83\uc744 \uba85\uc2dc\ud574\uc57c \ud55c\ub2e4.<\/div>\n
\uadf8\ub9ac\uace0 \uc5d4\ud130\ub97c \uce58\uba74 root \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ubc1b\uae30 \uc704\ud574 \ucee4\uc11c\uac00 \uba48\ucd98\ub2e4.<\/div>\n
(mysql \uba85\ub839\uc5b4\ub9cc \uc785\ub825\ud558\uace0 \uc5d4\ud130\ub97c \uce58\uba74 \ud328\uc2a4\uc6cc\ub4dc\ub97c \ubb3b\uc9c0 \uc55f\uace0 \ubc14\ub85c mysql> \ud504\ub86c\ud504\ud2b8\uac00 \ub098\uc628 \uc61b \uc2dc\uc808\uc744 \uc0dd\uac01\ud574 \ubcf4\uba74 \uae08\ubc29 \ucc28\uc774\ub97c \ub290\ub084\uc218 \uc788\uc74c)<\/div>\n
<\/div>\n
2. \ub8e8\ud2b8 \ube44\ubc88 \ubcc0\uacbd<\/div>\n
mysql> use mysql;<\/div>\n
mysql> update user set password=password(‘123456′) where user=’root’;<\/div>\n
mysql> flush privileges;<\/div>\n
<\/div>\n
3. root \ud328\uc2a4\uc6cc\ub4dc\ub97c \ubd84\uc2e4\ud55c \uacbd\uc6b0(\uc751\uae09\uc870\uce58)<\/div>\n
<\/div>\n
mysql\uc744 \uc624\ub7ab\ub3d9\uc548 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc558\uc744 \uacbd\uc6b0\uc5d0 \uac04\ud639 root\ud328\uc2a4\uc6cc\ub4dc\uac00 \uae30\uc5b5\ub098\uc9c8\uc54a\uc544\uc11c \ub2f9\ud669\ud560 \ub54c\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc2dc\uc2a4\ud15c\uad00\ub9ac\uc790\ub77c\uba74 \uc2dc\uc2a4\ud15c\uc758 root\ub098 MySQL\uc758 root\uc758 \uc554\ud638\ub97c \uc78a\uc5b4 \ubc84\ub838\uc744 \ub54c\ub97c \ub300\ube44\ud574\uc11c \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc0c8\ub85c \uc124\uc815\ud558\ub294 \ubc29\ubc95\uc744 \ubc18\ub4dc\uc2dc \uc219\uc9c0\ud558\uace0 \uc788\uc5b4\uc57c \ud560 \uac83\uc785\ub2c8\ub2e4.<\/div>\n
<\/div>\n
\u2460 \uc2e4\ud589\uc911\uc778 msyql \uc885\ub8cc<\/div>\n
<\/div>\n
# ps -ef | grep mysqld<\/div>\n
root 9567 1 0 Mar16 ? 00:00:00 sh .\/mysqld_safe<\/div>\n
root 9576 9567 0 Mar16 ? 00:00:00 \/usr\/local\/mysql\/libexec\/mysqld<\/div>\n
root 9578 9576 0 Mar16 ? 00:00:00 \/usr\/local\/mysql\/libexec\/mysqld<\/div>\n
root 9579 9578 0 Mar16 ? 00:00:00 \/usr\/local\/mysql\/libexec\/mysqld<\/div>\n
<\/div>\n
# killall mysqld<\/div>\n
<\/div>\n
\u2461 grant-table \ubbf8\uc0ac\uc6a9\ubaa8\ub4dc\ub85c mysql\uc2dc\uc791(\uad8c\ud55c \ud14c\uc774\ube14\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 \uc635\uc158\uc73c\ub85c \ub370\ubaac \uc2e4\ud589)<\/div>\n
<\/div>\n
nt\uc77c \uacbd\uc6b0 :<\/div>\n
c:\\program files\\mysql\\mysql server 4.1\\bin>mysqld-nt –standalone –skip-grant-tables<\/div>\n
\ub9cc\uc57d Error 2003 Hy000 Can’t connect to MySQL server on ‘localhost’ \uc640 \uac19\uc740 \uba54\uc138\uc9c0\uac00 \ub098\uc628\ub2e4\uba74<\/div>\n
<\/div>\n
c:\\program files\\mysql\\mysql server 4.1\\bin>mysqld –defaults-file=”c:\\program files\\mysql\\mysql server 4.1\\my.ini” –consol –skip-grant-tables<\/div>\n
\ub530\ub85c \ud504\ub86c\ud504\ud2b8\ub294 \ub5a8\uc5b4\uc9c0\uc9c0 \uc54a\uc73c\ubbc0\ub85c \uc0c8\ub85c cmd\ucc3d\uc744 \uc5f4\uc5b4\uc11c \uc811\uc18d\ud574 \ubcf8\ub2e4.<\/div>\n
<\/div>\n
<\/div>\n
# .\/safe_mysqld –skip-grant-tables &<\/div>\n
[1] 12084<\/div>\n
# Starting mysqld daemon with databases from \/usr\/local\/mysql\/data<\/div>\n
#<\/div>\n
<\/div>\n
# .\/mysql -u root mysql<\/div>\n
Reading table information for completion of table and column names<\/div>\n
You can turn off this feature to get a quicker startup with -A<\/div>\n
Welcome to the MySQL monitor. Commands end with ; or \\g.<\/div>\n
Your MySQL connection id is 1 to server version: 3.22.24<\/div>\n
Type ‘help’ for help.<\/div>\n
mysql><\/div>\n
<\/div>\n
\u203b mysqld_safe \uba85\ub839\uc5b4\ub294 mysql \ub370\ubaac\uc744 \uc2e4\ud589\uc2dc\ud0a8\ub2e4.<\/div>\n
<\/div>\n
\u2462 update\ubb38\uc73c\ub85c root\uc0ac\uc6a9\uc790 \ud328\uc2a4\uc6cc\ub4dc \uac31\uc2e0<\/div>\n
<\/div>\n
mysql> update user set password=password(‘123’) where user = ‘root’;<\/div>\n
Query OK, 3 rows affected (0.00 sec)<\/div>\n
Rows matched: 3 Changed: 3 Warnings: 0<\/div>\n
mysql> flush privileges;<\/div>\n
Query OK, 0 rows affected (0.01 sec)<\/div>\n
mysql> \\q<\/div>\n
Bye<\/div>\n
<\/div>\n
\u2463 \uc2e4\ud589\uc911\uc778 mysql \ub2e4\uc2dc \uc885\ub8cc(\uad8c\ud55c \ud14c\uc774\ube14\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 \ub370\ubaac\uc744 \uc885\ub8cc)<\/div>\n
<\/div>\n
# ps -ef | grep mysqld<\/div>\n
root 12084 11558 0 20:10 pts\/2 00:00:00 sh .\/mysqld_safe –skip-grant-ta<\/div>\n
root 12090 12084 0 20:10 pts\/2 00:00:00 \/usr\/local\/mysql\/libexec\/mysqld<\/div>\n
root 12092 12090 0 20:10 pts\/2 00:00:00 \/usr\/local\/mysql\/libexec\/mysqld<\/div>\n
root 12093 12092 0 20:10 pts\/2 00:00:00 \/usr\/local\/mysql\/libexec\/mysqld<\/div>\n
#<\/div>\n
# killall mysqld<\/div>\n
mysqld daemon ended<\/div>\n
[1]+ Done .\/mysqld_safe –skip-grant-tables<\/div>\n
#<\/div>\n
<\/div>\n
\u2464 Mysql \ub370\ubaac \uc7ac \uc2e4\ud589 \ud6c4 \uac31\uc2e0\ub41c \ud328\uc2a4\uc6cc\ub4dc\ub85c \ub85c\uadf8\uc778<\/div>\n
<\/div>\n
# .\/safe_mysqld &<\/div>\n
[1] 12102<\/div>\n
# Starting mysqld daemon with databases from \/usr\/local\/mysql\/data<\/div>\n
#<\/div>\n
<\/div>\n
# ps -ef | grep mysql<\/div>\n
root 12102 11558 0 20:13 pts\/2 00:00:00 sh .\/mysqld_safe<\/div>\n
root 12108 12102 0 20:13 pts\/2 00:00:00 \/usr\/local\/mysql\/libexec\/mysqld<\/div>\n
root 12110 12108 0 20:13 pts\/2 00:00:00 \/usr\/local\/mysql\/libexec\/mysqld<\/div>\n
root 12111 12110 0 20:13 pts\/2 00:00:00 \/usr\/local\/mysql\/libexec\/mysqld<\/div>\n
<\/div>\n
# mysql -u root -p<\/div>\n
Enter Password: ***************<\/div>\n","protected":false},"excerpt":{"rendered":"

\u200b http:\/\/jonnychoe.egloos.com\/5217253 <root\ub85c \ub85c\uadf8\uc778> # mysql -uroot -p password: ***** mysql>use mysql <\ub85c\uadf8\uc778 \ud560\u00a0\uc0ac\uc6a9\uc790 \uc0dd\uc131> mysql>insert into user(host,user,password) values(‘\uc811\uc18d\ud5c8\uc6a9\ud560 \ud638\uc2a4\ud2b8\ub124\uc784 or IP’,’root’,password(‘\ud328\uc2a4\uc6cc\ub4dc’)); <\uad8c\ud55c\uc8fc\uae30> mysql>\u00a0grant all privileges on *.* to ‘root’@’%’ identified by ‘\uc554\ud638’ with grant option; mysql> flush privileges mysql> select * from user where User = ‘root’ <\uc6d0\uaca9\uc9c0\uc5d0\uc11c \uc811\uc18d : -h \uc635\uc158> # mysql […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-32","post","type-post","status-publish","format-standard","hentry","category-mariadb-mysql"],"_links":{"self":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/32","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=32"}],"version-history":[{"count":2,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/32\/revisions"}],"predecessor-version":[{"id":383,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/32\/revisions\/383"}],"wp:attachment":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=32"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=32"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=32"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}