{"id":539,"date":"2012-08-28T00:22:36","date_gmt":"2012-08-27T15:22:36","guid":{"rendered":"http:\/\/auctionpro.co.kr\/WPress\/?p=539"},"modified":"2012-08-28T00:26:29","modified_gmt":"2012-08-27T15:26:29","slug":"centos5-4%ec%97%90-mysql-%ec%84%a4%ec%b9%98-timeout-error-occurred-trying-to-start-mysql-daemon","status":"publish","type":"post","link":"https:\/\/www.auctionpro.co.kr\/?p=539","title":{"rendered":"CentOS5.4\uc5d0 Mysql \uc124\uce58 : Timeout error occurred trying to start MySQL Daemon."},"content":{"rendered":"<p>1. yum\uc744 \uc774\uc6a9\ud55c \uc124\uce58<br \/>\n# yum -y install mysql mysql-server mysql-connector-odbc mysql-devel<br \/>\npackage 4\uac1c\uac00 \uc124\uce58 \ub429\ub2c8\ub2e4.<\/p>\n<p>2. \/etc\/my.cnf \ud3b8\uc9d1<br \/>\n\uc11c\ubc84 \uc6b4\uc601 \ud658\uacbd\uc5d0 \ub530\ub978 \uae30\ubcf8 \uc124\uc815 \ubc29\ubc95<br \/>\n# cp \/usr\/share\/mysql\/my-medium.cnf \/etc\/my.cnf<br \/>\n\uc704 \uba85\ub839\uc5b4\ub85c \ubcf5\uc0ac\ub97c \ud55c \uc774\ud6c4\uc5d0<br \/>\n# vi \/etc\/my.cnf<br \/>\n\uc544\ub798 \uc635\uc158 \ubd80\ubd84\uc744 \ucd94\uac00 \ud569\ub2c8\ub2e4.<\/p>\n<p>[client]<br \/>\ndefault-character-set = utf8<\/p>\n<p>[mysqld]<br \/>\ninit_connect = SET collation_connection = utf8_general_ci<br \/>\ninit_connect = SET NAMES utf8<br \/>\ndefault-character-set = utf8<br \/>\ncharacter-set-server = utf8<br \/>\ncollation-server = utf8_general_ci<\/p>\n<p>[mysqldump]<br \/>\ndefault-character-set = utf8<\/p>\n<p>[mysql]<br \/>\ndefault-character-set = utf8<\/p>\n<p>3. MySQL \uc11c\ubc84 \uc7ac\uc2dc\uc791<br \/>\n# service mysqld restart<\/p>\n<p>\uc704 \uba85\ub839\uc5b4\ub97c \ud574\ub3c4 \uc5d0\ub7ec\uac00 \uc0dd\uae38\uacbd\uc6b0\uc5d0\ub294<br \/>\n<span style=\"color: #ff0000;\"># chown -R mysql.mysql \/var\/lib\/mysql\/<\/span><br \/>\n<span style=\"color: #ff0000;\"> # chmod g+w \/var\/run\/mysqld\/<\/span><br \/>\n<span style=\"color: #ff0000;\"> # chgrp mysql \/var\/run\/mysqld\/<\/span><br \/>\n\uc704 \uc138 \uc904\uc744 \uc785\ub825\ud574\uc11c \uad8c\ud55c\uc744 \ub123\uc5b4\uc90d\ub2c8\ub2e4.<\/p>\n<p>4. root \uacc4\uc815<br \/>\n# mysql -u root -p mysql<br \/>\nmysql&gt; GRANT ALL PRIVILEGES ON *.* to root@&#8221;%&#8221; IDENTIFIED BY &#8216;\ud328\uc2a4\uc6cc\ub4dc&#8217; WITH GRANT OPTION;<br \/>\nmysql&gt; flush privileges;<\/p>\n<p>\ucc38\uace0:http:\/\/blog.taeco.info\/192<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>1. yum\uc744 \uc774\uc6a9\ud55c \uc124\uce58 # yum -y install mysql mysql-server mysql-connector-odbc mysql-devel package 4\uac1c\uac00 \uc124\uce58 \ub429\ub2c8\ub2e4. 2. \/etc\/my.cnf \ud3b8\uc9d1 \uc11c\ubc84 \uc6b4\uc601 \ud658\uacbd\uc5d0 \ub530\ub978 \uae30\ubcf8 \uc124\uc815 <a class=\"mh-excerpt-more\" href=\"https:\/\/www.auctionpro.co.kr\/?p=539\" title=\"CentOS5.4\uc5d0 Mysql \uc124\uce58 : Timeout error occurred trying to start MySQL Daemon.\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[11],"tags":[],"class_list":["post-539","post","type-post","status-publish","format-standard","hentry","category-centos"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/539","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=539"}],"version-history":[{"count":0,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/539\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=539"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=539"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=539"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}