{"id":521,"date":"2014-12-29T21:59:12","date_gmt":"2014-12-30T06:59:12","guid":{"rendered":"http:\/\/blog.box.kr\/?p=521"},"modified":"2014-12-29T21:59:12","modified_gmt":"2014-12-30T06:59:12","slug":"mysql-%ec%a0%91%ec%86%8d-%ed%94%84%eb%a1%9c%ed%86%a0%ec%bd%9c-%eb%ac%b8%ec%a0%9c","status":"publish","type":"post","link":"https:\/\/blog.box.kr\/?p=521","title":{"rendered":"MYSql \uc811\uc18d \ud504\ub85c\ud1a0\ucf5c \ubb38\uc81c"},"content":{"rendered":"

Q1. \u00a0Mysql \uc811\uc18d\uc2dc\uc5d0 ”\u00a0MYSQL ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref used (client option ‘secure_auth’ enabled)<\/a>\u00a0” \uc624\ub958 \ubc1c\uc0dd<\/p>\n

\uc6d0\uc778: \uc0ac\uc6a9\uc790 \uc554\ud638 \ud574\uc26c\uac12\uc744 \uc608\uc804 \uac83\uc744 \uc0ac\uc6a9\ud574\uc11c \uc0dd\uae30\ub294 \ubb38\uc81c<\/p>\n

\ud574\uacb0 1 : \u00a0<\/span>\u00a0–skip-secure-auth<\/strong><\/span> \u00a0\uc635\uc158 \uc0ac\uc6a9
\n=> \uc811\uc18d \ud560\ub54c Mysql\uc758 \ud074\ub77c\uc774\uc5b8\ud2b8\uc758 \uc554\ud638 Hash\uc218\uc900\uc744 \ub0ae \ucdb0\uc11c \uc811\uc18d ( \uc784\uc2dc\uc801\uc778 \ubc29\ubc95 )\u00a0<\/span><\/p>\n

\ud574\uacb0 2: \ubcf4\ub2e4 \uadfc\ubcf8 \uc801\uc778 \ud574\uacb0 \ubc29\ubc95..
\nMysql ><\/span> use<\/span> mysql<\/span>;
\n<\/span><\/span>Database<\/span> changed
\n<\/span>Mysql >\u00a0describe <\/span>user<\/span>;
\n<\/span>\u00a0 \u00a0 describe <\/span>user<\/span>;
\n<\/span>+<\/span>———————–+———————————–+——+—–+———+——-+
\n<\/span>\u00a0|<\/span> Field <\/span>|<\/span> Type <\/span>|<\/span> Null<\/span> |<\/span> Key<\/span> |<\/span> Default<\/span> |<\/span> Extra <\/span>|
\n<\/span>+<\/span>———————–+———————————–+——+—–+———+——-+
\n<\/span>\u00a0 \u00a0\u00a0|<\/span> Host <\/span>|<\/span> char<\/span>(<\/span>60<\/span>)<\/span> |<\/span> NO <\/span>|<\/span> PRI <\/span>|<\/span> |<\/span> |
\n<\/span>\u00a0 \u00a0\u00a0|<\/span> User<\/span> |<\/span> char<\/span>(<\/span>16<\/span>)<\/span> |<\/span> NO <\/span>|<\/span> PRI <\/span>|<\/span> |<\/span> |
\n<\/span>\u00a0 \u00a0\u00a0|<\/span> Password <\/span>|<\/span> char<\/span>(<\/span>41<\/span>)<\/span> |<\/span> NO <\/span>|<\/span> |<\/span> |<\/span> |<\/span><\/p>\n

password \ud544\ub4dc\uac00 41 bytes \uc774\uc0c1\uc778 \uac83\uc744 \ud655\uc778 \ud574\uc57c \ud568. \uc0c8\ub85c\uc6b4 \uc554\ud638 \ud574\uc26c\ub294 \uc801\uc5b4\ub3c4 41 \ubc14\uc774\ud2b8\uac00
\n\ub418\uc5b4\uc57c \ud568<\/p>\n

Mysql ><\/span> show variables <\/span>like<\/span> ‘%pass%’<\/span>;
\n<\/span>\u00a0 \u00a0\u00a0+<\/span>———————-+——-+
\n<\/span>\u00a0 \u00a0\u00a0|<\/span> Variable_name \u00a0 \u00a0<\/span>|<\/span> Value <\/span>|
\n<\/span>\u00a0 \u00a0\u00a0+<\/span>———————-+——-+
\n<\/span>\u00a0 \u00a0\u00a0|<\/span> old_passwords \u00a0 \u00a0<\/span>|<\/span> ON \u00a0<\/span> |
\n<\/span>\u00a0 \u00a0\u00a0|<\/span> report_password <\/span>|<\/span>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0|
\n<\/span>\u00a0 \u00a0\u00a0+<\/span>———————+——-+
\n<\/span>\u00a0 \u00a0\u00a02<\/span> rows<\/span> in<\/span> set<\/span> (<\/span>0.06<\/span> sec<\/span>)<\/span><\/p>\n

\"old_passwords\" \uc774 \uac12\uc744 OFF\ub85c \ub9cc\ub4e4\uc5b4\uc57c \ud568<\/code>:<\/p>\n

Mysql ><\/span> set<\/span> session old_passwords <\/span>=<\/span> 'OFF'<\/span>;<\/span>\n    Query OK<\/span>,<\/span> 0<\/span> rows<\/span> affected <\/span>(<\/span>0.05<\/span> sec<\/span>)<\/span>\n\nMysql ><\/span> show variables <\/span>like<\/span> '%pass%'<\/span>;<\/span>\n    show variables <\/span>like<\/span> '%pass%'<\/span>;<\/span>\n    +<\/span>-----------------+-------+<\/span>\n    |<\/span> Variable_name   <\/span>|<\/span> Value <\/span>|<\/span>\n    +<\/span>-----------------+-------+<\/span>\n    |<\/span> old_passwords   <\/span>|<\/span> OFF<\/span>   |<\/span>\n    |<\/span> report_password <\/span>|<\/span>       |<\/span>\n    +<\/span>-----------------+-------+<\/span>\n    2<\/span> rows<\/span> in<\/span> set<\/span> (<\/span>0.06<\/span> sec<\/span>)<\/span><\/code><\/pre>\n
\ub410\uc73c\uba74.. \ud655\uc778 \ucc28\uc6d0\uc5d0\uc11c \uc0ac\uc6a9\uc790 \ub9cc\ub4e4\uc5b4 \ubcf8\ub2e4..<\/p>\n
 Mysql ><\/span> create<\/span> user<\/span> 'erich'<\/span> IDENTIFIED <\/span>BY<\/span> 'SEKRIT PASSWORD'<\/span>;<\/span><\/code><\/pre>\n
.\uc544\ub798\ucc98\ub7fc \uae38\uac8c \ub098\uc624\uba74 \uc131\uacf5..<\/p>\n
Mysql ><\/span> select<\/span> *<\/span> from<\/span> user<\/span> order<\/span> by<\/span> User<\/span>;<\/span>\n    +<\/span>-----------+--------------+-------------------------------------------+--------<\/span>\n    |<\/span> Host      <\/span>|<\/span> User<\/span>         |<\/span> Password                                  <\/span>|<\/span> Select_\n    <\/span>+<\/span>-----------+--------------+-------------------------------------------+--------<\/span>\n    |<\/span> localhost <\/span>|<\/span> someguy      <\/span>|<\/span> 3<\/span>d9505dd323e53f1                          <\/span>|<\/span> Y\n    <\/span>|<\/span> %<\/span>         |<\/span> someotherguy <\/span>|<\/span> 79<\/span>b3df3b004bb855                          <\/span>|<\/span> Y\n    <\/span>|<\/span> %<\/span>         |<\/span> erich        <\/span>|<\/span> *<\/span>D2589EF6B59146801234567897BB190123456789 <\/span>|<\/span> N\n    <\/span>|<\/span> %<\/span>         |<\/span> anotheroldguy<\/span>|<\/span> 60577e0<\/span>d77b9212b                          <\/span>|<\/span> Y      <\/span><\/code><\/pre>\n
\uc774\uc0c1..<\/p>\n
\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Q1. \u00a0Mysql \uc811\uc18d\uc2dc\uc5d0 ”\u00a0MYSQL ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref used (client option ‘secure_auth’ enabled)\u00a0” \uc624\ub958 \ubc1c\uc0dd \uc6d0\uc778: \uc0ac\uc6a9\uc790 \uc554\ud638 \ud574\uc26c\uac12\uc744 \uc608\uc804 \uac83\uc744 \uc0ac\uc6a9\ud574\uc11c \uc0dd\uae30\ub294 \ubb38\uc81c \ud574\uacb0 1 : \u00a0\u00a0–skip-secure-auth \u00a0\uc635\uc158 \uc0ac\uc6a9 => \uc811\uc18d \ud560\ub54c Mysql\uc758 \ud074\ub77c\uc774\uc5b8\ud2b8\uc758 \uc554\ud638 Hash\uc218\uc900\uc744 \ub0ae \ucdb0\uc11c \uc811\uc18d ( \uc784\uc2dc\uc801\uc778 \ubc29\ubc95 )\u00a0 \ud574\uacb0 2: \ubcf4\ub2e4 \uadfc\ubcf8 \uc801\uc778 \ud574\uacb0 \ubc29\ubc95.. Mysql > use mysql; Database changed Mysql >\u00a0describe user; \u00a0 \u00a0 describe user; +———————–+———————————–+——+—–+———+——-+ \u00a0| Field | Type | Null | Key | Default | Extra | +———————–+———————————–+——+—–+———+——-+ \u00a0 \u00a0\u00a0| Host | char(60) | NO | PRI | | | \u00a0 \u00a0\u00a0| User | char(16) | NO | PRI | | | \u00a0 \u00a0\u00a0| Password | char(41) | NO | | | | password \ud544\ub4dc\uac00 41 bytes \uc774\uc0c1\uc778 \uac83\uc744 \ud655\uc778 \ud574\uc57c \ud568. \uc0c8\ub85c\uc6b4 \uc554\ud638 \ud574\uc26c\ub294 \uc801\uc5b4\ub3c4 41 \ubc14\uc774\ud2b8\uac00 \ub418\uc5b4\uc57c \ud568 Mysql > show variables like ‘%pass%’; \u00a0 \u00a0\u00a0+———————-+——-+ \u00a0 \u00a0\u00a0| Variable_name \u00a0 \u00a0| Value | \u00a0 \u00a0\u00a0+———————-+——-+ \u00a0 \u00a0\u00a0| old_passwords \u00a0 \u00a0| ON \u00a0 | \u00a0 \u00a0\u00a0| report_password |\u00a0 \u00a0 \u00a0 \u00a0 \u00a0| \u00a0 \u00a0\u00a0+———————+——-+ \u00a0 \u00a0\u00a02 rows in set (0.06 sec) “old_passwords” \uc774 \uac12\uc744 OFF\ub85c \ub9cc\ub4e4\uc5b4\uc57c \ud568: Mysql > set session old_passwords = ‘OFF’; Query OK, 0 rows affected (0.05 sec) Mysql […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"ngg_post_thumbnail":0,"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[12,5],"tags":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5q9Zn-8p","jetpack-related-posts":[{"id":653,"url":"https:\/\/blog.box.kr\/?p=653","url_meta":{"origin":521,"position":0},"title":"[\ud38c]Too many connection \ubb38\uc81c \ud574\uacb0","date":"2015-04-05","format":false,"excerpt":"http:\/\/netholic.tistory.com\/116 \u00a0 \u00a0 \uc774\ubc88\ud574 \ucd08\ubd80\ud130 \uc2dc\uc791\ub41c too many connection \ubb38\uc81c\uac00 \ud558\ub8e8\uc5d0 \ud55c\ubc88\uc529 mysql \uc744 \ubed7\uac8c \ub9cc\ub4e4\uc5c8\ub2e4. \ub418\ub294\ub300\ub85c... \uc544\ubb34\uac83\ub3c4 \ubaa8\ub978\ucc44\ub85c \ub9cc\ub4e0 \uc6b4\uc601\ud234\uc774 \uadf8 \uc6d0\uc778... \ucffc\ub9ac\ub3c4 10\ucd08 \uc774\uc0c1 \uac78\ub9ac\ub294 \uac83\ub3c4 \uc874\uc7ac\ud588\uace0..\uc778\ub371\uc2a4\ub3c4 \uc81c\ub300\ub85c \uc548\uac78\ub824\uc788\uace0.. \uadf8\ub798\uc11c \uc2ac\ub85c\uc6b0 \ucffc\ub9ac\ub97c \uc7a1\uace0 \uc778\ub371\uc2a4\ub3c4 \uc81c\ub300\ub85c \uac78\uc5b4\uc11c...\uadf8\ub7f0 \ucffc\ub9ac\ubb38\uc81c\ub97c \uc5c6\uc570\uc73c\ub85c\uc11c \ucee4\ub125\uc158 \ubb38\uc81c\ub294 \uc5c6\uc5b4\uc9c8 \uc904 \uc54c\uc558\ub2e4. \uadf8\ub7f0\ub370 \uc5ec\uc804\ud788 \ud558\ub8e8\uc5d0 \ud55c\ubc88\uc529...\uc11c\ubc84\ub97c \ub0b4\ub838\ub2e4\u2026","rel":"","context":"In "\uae30\uc220\uc790\ub8cc"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1161,"url":"https:\/\/blog.box.kr\/?p=1161","url_meta":{"origin":521,"position":1},"title":"POCO \ub77c\uc774\ube0c\ub7ec\ub9ac\ub85c MYSQL  Query\uc2dc\uc5d0 “unknown field type” \uc624\ub958","date":"2016-08-31","format":false,"excerpt":"\uc6d0\uc778\uc740.. \u00a0POCO\uc5d0\uc11c\u00a0MYSQL\uc758 TIMESTAMP \ud0c0\uc785\uc744 \uc9c0\uc6d0 \ud558\uc9c0 \uc54a\uc544\uc11c \uc0dd\uae34 \ubb38\uc81c. \uc774\ub97c \ud574\uacb0 \ud558\uae30 \uc704\ud574\uc11c POCO\ub77c\uc774\ube0c\ub7ec\ub9ac \uc18c\uc2a4\ub97c \uc544\ub798\uc640 \uac19\uc774 \uc218\uc815 \ud55c \ud6c4\uc5d0 \uc7ac \ucef4\ud30c\uc77c \ud574\uc900\ub2e4. POCO \uc18c\uc2a4 \ud3f4\ub354\uc5d0\uc11c Data\/MySQL\/src\/ResultMetadata.cpp \uc758 \ub0b4\uc6a9\uc744 \uc544\ub798\uc640 \uac19\uc774 \uc218\uc815 std::size_t fieldSize(const MYSQL_FIELD& field) \/\/\/ Convert field MySQL-type and field MySQL-length to actual field length { ... case\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":709,"url":"https:\/\/blog.box.kr\/?p=709","url_meta":{"origin":521,"position":2},"title":"[\ud38c] HOWTO: Turn off MySQL reverse DNS lookup to speed up response times","date":"2015-04-15","format":false,"excerpt":"\ub0b4\uc6a9\uc744 \uc694\uc57d \ud558\uc790\ub9cc.. mysql\uc774 \uc811\uc18d \ud560\ub54c\u00a0reverse DNS lookup\uc744 \ud558\ub294\ub370 \uc774\ub54c \uc2dc\uac04\uc774 \ub9ce\uc774 \uac78\ub9ac\ub2c8 \uc774\ub97c skip\ucc98\ub9ac \ud558\uba74 \uc811\uc18d \uc18d\ub3c4\uac00 \ub9ce\uc774 \ube68\ub77c \uc9c4\ub2e4\ub294 \uc774\uc57c\uae30.. \u00a0 \u00a0 http:\/\/developer.sugarcrm.com\/2012\/01\/10\/howto-turn-off-mysql-reverse-dns-lookup-to-speed-up-response-times\/ Our support team was recently working on a case where pages were taking 5 seconds or longer for each load, even after tackling all of\u2026","rel":"","context":"In "\uae30\uc220\uc790\ub8cc"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":519,"url":"https:\/\/blog.box.kr\/?p=519","url_meta":{"origin":521,"position":3},"title":"MYSQL \uc0ac\uc6a9\uc790 \uc0dd\uc131\ubd80\ud130 \uad8c\ud55c \ubd80\uc5ec \uae4c\uc9c0..","date":"2014-12-29","format":false,"excerpt":"1. DATABASE \uc0dd\uc131 mysql> CREATE DATABASE \ub514\ube44\uba85 2. \uc0ac\uc6a9\uc790 \uc0dd\uc131 \ubc0f \uad8c\ud55c \ubd80\uc5ec mysql> \u00a0CREATE USER '\uc0ac\uc6a9\uc790\uba85'@'\uc811\uc18d\ud638\uc2a4\ud2b8(localhost, %, ip )' IDENTIFIED BY '\uc554\ud638'; \u00a0 mysql>\u00a0GRANT ALL PRIVILEGES ON \ub514\ube44\uba85.* TO '\uc0ac\uc6a9\uc790\uba85'@'\uc811\uc18d\ud638\uc2a4\ud2b8(localhost, %, ip )'\u00a0\u00a0WITH GRANT OPTION; \ub610\ub294 \u00a0 mysql> GRANT RELOAD,PROCESS ON \ub514\ube44\uba85.* TO '\uc0ac\uc6a9\uc790\uba85'@'localhost'; \/\/ \uc774\ub807\uac8c \ud544\uc694\ud55c \uad8c\ud55c\ub9cc \ucc0d\uc5b4\uc11c...\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":649,"url":"https:\/\/blog.box.kr\/?p=649","url_meta":{"origin":521,"position":4},"title":"[\ud38c]Tomcat7 tomcat-jdbc \uc124\uc815 – Broken pipe \uc5d0\ub7ec \ud68c\ud53c","date":"2015-04-05","format":false,"excerpt":"tomcat-jdbc\ub85c MySQL\uc5d0 \uc5f0\uacb0\ud55c \uacbd\uc6b0 \"java.net.SocketException: Broken pipe\" \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0\ub97c \uac00\ub054 \ubcfc \uc218 \uc788\ub2e4. \ub300\ubd80\ubd84\uc758 \uacbd\uc6b0 connection idle time\uc774 MySQL\uc5d0 \uc124\uc815\ub41c wait_timeout\uc744 \uc9c0\ub098\uc11c DB\uc5d0\uc11c \uc5f0\uacb0\uc744 \ub04a\uc740 \uac83\uc774\ub2e4. \uc774\ub97c \ubc29\uc9c0\ud558\ub824\uba74 connection\uc774 \uc77c\uc815 \uae30\uac04\ub3d9\uc548 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc73c\uba74 close\ub418\ub3c4\ub85d \uc124\uc815\ud558\uac70\ub098 connection \ub300\uc5ec\uc2dc\uc5d0 connection\uc744 \uccb4\ud06c\ud558\ub3c4\ub85d \ud558\uba74 \ub41c\ub2e4. \uc124\uc815 1 - \uc77c\uc815 \uae30\uac04\ub3d9\uc548 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc73c\uba74 connection\uc744\u2026","rel":"","context":"In "\uae30\uc220\uc790\ub8cc"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":694,"url":"https:\/\/blog.box.kr\/?p=694","url_meta":{"origin":521,"position":5},"title":"* APM\uc124\uce58","date":"2015-04-15","format":false,"excerpt":"1. \uc124\uc815 \ubc29\ud654\ubcbd \ucf1c\uc838 80 \ud3ec\ud2b8, 3306 \ud3ec\ud2b8 vi \/etc\/sysconfig\/iptables -A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT -A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT \/etc\/init.d\/iptables restart #\ub9c8\uc9c0\ub9c9\uc73c\ub85c \ub2e4\uc2dc \ubc29\ud654\ubcbd \ub54c\ubb38\uc5d0 \uc124\uc815\uc774 \uc801\uc6a9\ub429\ub2c8\ub2e4 2. \ub2eb\uae30SELINUX vi \/etc\/selinux\/config\u2026","rel":"","context":"In "\uae30\uc220\uc790\ub8cc"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/521"}],"collection":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=521"}],"version-history":[{"count":0,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/521\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=521"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}