{"id":744,"date":"2012-11-09T14:02:18","date_gmt":"2012-11-09T05:02:18","guid":{"rendered":"http:\/\/www.whoocus.com\/blog\/?p=744"},"modified":"2012-11-09T14:47:22","modified_gmt":"2012-11-09T05:47:22","slug":"centos5-8%e3%81%abmysql5-5%e3%82%92%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/www.blowfish.co.jp\/?p=744","title":{"rendered":"CentOS5.8\u306bMySQL5.5\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b"},"content":{"rendered":"<p>\u4e45\u3057\u3076\u308a\u306b\u30b5\u30fc\u30d0\u69cb\u7bc9\u3059\u308b\u3053\u3068\u3068\u306a\u308a\u3001CentOS5.8\u306bMySQL5.5\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3088\u3046\u3068\u3059\u308b\u3002<\/p>\n<p><a href=\"https:\/\/www.blowfish.co.jp\/?p=28\">\u4ee5\u524d\u306e\u8a18\u4e8b<\/a>\u304b\u3089\u3001\u65e2\u306b1\u5e74\u4ee5\u4e0a\u304c\u7d4c\u3063\u3066\u3001\u3082\u306f\u3084\u305d\u306e\u901a\u308a\u306b\u52d5\u4f5c\u3057\u3066\u3044\u306a\u3044\u3053\u3068\u306b\u6c17\u4ed8\u304f\u3002<\/p>\n<p>\u518d\u5ea6\u899a\u3048\u66f8\u304d\u3068\u3059\u308b\u3002<\/p>\n<p>\u25a0yum \u30ec\u30dd\u30b8\u30c8\u30ea\u306e\u8ffd\u52a0<br \/>\n[bash]<br \/>\nwget http:\/\/dl.iuscommunity.org\/pub\/ius\/stable\/Redhat\/5\/x86_64\/ius-release-1.0-10.ius.el5.noarch.rpm<br \/>\nwget http:\/\/dl.iuscommunity.org\/pub\/ius\/stable\/Redhat\/5\/x86_64\/epel-release-5-4.noarch.rpm<\/p>\n<p>rpm -Uvh epel-release-5-4.noarch.rpm<br \/>\n\u8b66\u544a: epel-release-5-4.noarch.rpm: \u30d8\u30c3\u30c0 V4 DSA signature: NOKEY, key ID 9cd4953f<br \/>\n\u6e96\u5099\u4e2d&#8230;                ########################################### [100%]<br \/>\n   1:epel-release           ########################################### [100%]<br \/>\nrpm -Uvh ius-release-1.0-10.ius.el5.noarch.rpm<br \/>\n\u8b66\u544a: ius-release-1.0-10.ius.el5.noarch.rpm: \u30d8\u30c3\u30c0 V4 DSA signature: NOKEY, key ID 9cd4953f<br \/>\n\u6e96\u5099\u4e2d&#8230;                ########################################### [100%]<br \/>\n   1:ius-release            ########################################### [100%]<br \/>\n[\/bash]<\/p>\n<p>\u25a0ius,epel\u304b\u3089\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3002<br \/>\n[bash]<br \/>\nyum &#8211;enablerepo=ius,epel install mysql<br \/>\nLoaded plugins: fastestmirror<br \/>\nLoading mirror speeds from cached hostfile<br \/>\n * base: ftp.oss.eznetsols.org<br \/>\n * epel: ftp.iij.ad.jp<br \/>\n * extras: ftp.oss.eznetsols.org<br \/>\n * ius: archive.linux.duke.edu<br \/>\n * updates: ftp.oss.eznetsols.org<br \/>\nepel                                                                          | 3.7 kB     00:00<br \/>\nepel\/primary_db                                                               | 3.8 MB     00:00<br \/>\nius                                                                           | 2.2 kB     00:00<br \/>\nius\/primary_db                                                                | 166 kB     00:00<br \/>\nSetting up Install Process<br \/>\nResolving Dependencies<br \/>\n&#8211;&gt; Running transaction check<br \/>\n&#8212;&gt; Package mysql.i386 0:5.0.95-1.el5_7.1 set to be updated<br \/>\n&#8212;&gt; Package mysql.x86_64 0:5.0.95-1.el5_7.1 set to be updated<br \/>\n&#8211;&gt; Finished Dependency Resolution<\/p>\n<p>Dependencies Resolved<\/p>\n<p>=====================================================================================================<br \/>\n Package             Arch                 Version                        Repository             Size<br \/>\n=====================================================================================================<br \/>\nInstalling:<br \/>\n mysql               i386                 5.0.95-1.el5_7.1               updates               4.9 M<br \/>\n mysql               x86_64               5.0.95-1.el5_7.1               updates               4.9 M<\/p>\n<p>Transaction Summary<br \/>\n=====================================================================================================<br \/>\nInstall       2 Package(s)<br \/>\nUpgrade       0 Package(s)<\/p>\n<p>Total download size: 9.8 M<br \/>\n[\/bash]<\/p>\n<p>\u6b8b\u5ff5\u306a\u304c\u3089\u30015.0\u306e\u307e\u307e\u306a\u306e\u3067\u3001No!!<br \/>\n[bash]<br \/>\nIs this ok [y\/N]: N<br \/>\nExiting on user Command<br \/>\nComplete!<br \/>\n[\/bash]<\/p>\n<p>\u25a0\u518d\u5ea6\u30d0\u30fc\u30b8\u30e7\u30f3\u6307\u5b9a\u3057\u3066\u5b9f\u884c\u3002<br \/>\n[bash]<br \/>\nyum &#8211;enablerepo=ius,epel install mysql55<br \/>\nLoaded plugins: fastestmirror<br \/>\nLoading mirror speeds from cached hostfile<br \/>\n * base: ftp.oss.eznetsols.org<br \/>\n * epel: ftp.iij.ad.jp<br \/>\n * extras: ftp.oss.eznetsols.org<br \/>\n * ius: archive.linux.duke.edu<br \/>\n * updates: ftp.oss.eznetsols.org<br \/>\nSetting up Install Process<br \/>\nResolving Dependencies<br \/>\n&#8211;&gt; Running transaction check<br \/>\n&#8212;&gt; Package mysql55.x86_64 0:5.5.28-2.ius.el5 set to be updated<br \/>\n&#8211;&gt; Processing Dependency: mysql55-libs = 5.5.28-2.ius.el5 for package: mysql55<br \/>\n&#8211;&gt; Processing Dependency: mysqlclient15 for package: mysql55<br \/>\n&#8211;&gt; Running transaction check<br \/>\n&#8212;&gt; Package mysql55-libs.x86_64 0:5.5.28-2.ius.el5 set to be updated<br \/>\n&#8212;&gt; Package mysqlclient15.x86_64 0:5.0.92-3.ius.el5 set to be updated<br \/>\n&#8211;&gt; Finished Dependency Resolution<\/p>\n<p>Dependencies Resolved<\/p>\n<p>=====================================================================================================<br \/>\n Package                    Arch                Version                       Repository        Size<br \/>\n=====================================================================================================<br \/>\nInstalling:<br \/>\n mysql55                    x86_64              5.5.28-2.ius.el5              ius               11 M<br \/>\nInstalling for dependencies:<br \/>\n mysql55-libs               x86_64              5.5.28-2.ius.el5              ius              1.1 M<br \/>\n mysqlclient15              x86_64              5.0.92-3.ius.el5              ius              1.7 M<\/p>\n<p>Transaction Summary<br \/>\n=====================================================================================================<br \/>\nInstall       3 Package(s)<br \/>\nUpgrade       0 Package(s)<\/p>\n<p>Total download size: 14 M<br \/>\nIs this ok [y\/N]: y<br \/>\nDownloading Packages:<br \/>\n(1\/3): mysql55-libs-5.5.28-2.ius.el5.x86_64.rpm                               | 1.1 MB     00:01<br \/>\n(2\/3): mysqlclient15-5.0.92-3.ius.el5.x86_64.rpm                              | 1.7 MB     00:00<br \/>\n(3\/3): mysql55-5.5.28-2.ius.el5.x86_64.rpm                                    |  11 MB     00:02<br \/>\n&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>\nTotal                                                                2.4 MB\/s |  14 MB     00:05<br \/>\n\u8b66\u544a: rpmts_HdrFromFdno: \u30d8\u30c3\u30c0 V4 DSA signature: NOKEY, key ID 9cd4953f<br \/>\nius\/gpgkey                                                                    | 1.3 kB     00:00<br \/>\nImporting GPG key 0x9CD4953F &quot;IUS Community Project &lt;coredev@iuscommunity.org&gt;&quot; from \/etc\/pki\/rpm-gpg\/IUS-COMMUNITY-GPG-KEY<br \/>\nIs this ok [y\/N]: y<br \/>\nRunning rpm_check_debug<br \/>\nRunning Transaction Test<br \/>\nFinished Transaction Test<br \/>\nTransaction Test Succeeded<br \/>\nRunning Transaction<br \/>\n  Installing     : mysqlclient15                                                                 1\/3<br \/>\n  Installing     : mysql55-libs                                                                  2\/3<br \/>\n  Installing     : mysql55                                                                       3\/3<\/p>\n<p>Installed:<br \/>\n  mysql55.x86_64 0:5.5.28-2.ius.el5<\/p>\n<p>Dependency Installed:<br \/>\n  mysql55-libs.x86_64 0:5.5.28-2.ius.el5           mysqlclient15.x86_64 0:5.0.92-3.ius.el5<\/p>\n<p>Complete!<br \/>\n[\/bash]<\/p>\n<p>mysql-server55 \u304c\u8db3\u308a\u306a\u304b\u3063\u305f\u3088\u3046\u3060\u3002<br \/>\n[bash]<br \/>\nyum &#8211;enablerepo=ius,epel install mysql55-server<br \/>\nLoaded plugins: fastestmirror<br \/>\nLoading mirror speeds from cached hostfile<br \/>\n * base: ftp.oss.eznetsols.org<br \/>\n * epel: ftp.iij.ad.jp<br \/>\n * extras: ftp.oss.eznetsols.org<br \/>\n * ius: archive.linux.duke.edu<br \/>\n * updates: ftp.oss.eznetsols.org<br \/>\nSetting up Install Process<br \/>\nResolving Dependencies<br \/>\n&#8211;&gt; Running transaction check<br \/>\n&#8212;&gt; Package mysql55-server.x86_64 0:5.5.28-2.ius.el5 set to be updated<br \/>\n&#8211;&gt; Processing Dependency: perl-DBD-MySQL for package: mysql55-server<br \/>\n&#8211;&gt; Running transaction check<br \/>\n&#8212;&gt; Package perl-DBD-MySQL.x86_64 0:3.0007-2.el5 set to be updated<br \/>\n&#8211;&gt; Finished Dependency Resolution<\/p>\n<p>Dependencies Resolved<\/p>\n<p>=====================================================================================================<br \/>\n Package                    Arch               Version                        Repository        Size<br \/>\n=====================================================================================================<br \/>\nInstalling:<br \/>\n mysql55-server             x86_64             5.5.28-2.ius.el5               ius               12 M<br \/>\nInstalling for dependencies:<br \/>\n perl-DBD-MySQL             x86_64             3.0007-2.el5                   base             148 k<\/p>\n<p>Transaction Summary<br \/>\n=====================================================================================================<br \/>\nInstall       2 Package(s)<br \/>\nUpgrade       0 Package(s)<\/p>\n<p>Total download size: 12 M<br \/>\nIs this ok [y\/N]: y<br \/>\nDownloading Packages:<br \/>\n(1\/2): perl-DBD-MySQL-3.0007-2.el5.x86_64.rpm                                 | 148 kB     00:00<br \/>\n(2\/2): mysql55-server-5.5.28-2.ius.el5.x86_64.rpm                             |  12 MB     00:03<br \/>\n&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>\nTotal                                                                2.9 MB\/s |  12 MB     00:04<br \/>\nRunning rpm_check_debug<br \/>\nRunning Transaction Test<br \/>\nFinished Transaction Test<br \/>\nTransaction Test Succeeded<br \/>\nRunning Transaction<br \/>\n  Installing     : perl-DBD-MySQL                                                                1\/2<br \/>\n  Installing     : mysql55-server                                                                2\/2<\/p>\n<p>Installed:<br \/>\n  mysql55-server.x86_64 0:5.5.28-2.ius.el5<\/p>\n<p>Dependency Installed:<br \/>\n  perl-DBD-MySQL.x86_64 0:3.0007-2.el5<\/p>\n<p>Complete!<br \/>\n[\/bash] <\/p>\n<p>\u4e0a\u624b\u304f\u3044\u3063\u305f\u3088\u3046\u3060\u3002\u7d50\u679c\u3068\u3057\u3066 \/usr\/bin\/\u4ee5\u4e0b\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u308b\u3088\u3046\u3060\u3002<\/p>\n<p>\u25a0MySQL Server\u306e\u8d77\u52d5<br \/>\n[bash]<br \/>\n# \/etc\/rc.d\/init.d\/mysqld start<br \/>\nMySQL \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u521d\u671f\u5316\u4e2d:  Installing MySQL system tables&#8230;<br \/>\nOK<br \/>\nFilling help tables&#8230;<br \/>\nOK<\/p>\n<p>To start mysqld at boot time you have to copy<br \/>\nsupport-files\/mysql.server to the right place for your system<\/p>\n<p>PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !<br \/>\nTo do so, start the server, then issue the following commands:<\/p>\n<p>\/usr\/bin\/mysqladmin -u root password &#8216;new-password&#8217;<br \/>\n\/usr\/bin\/mysqladmin -u root -h 127.0.0.1 password &#8216;new-password&#8217;<\/p>\n<p>Alternatively you can run:<br \/>\n\/usr\/bin\/mysql_secure_installation<\/p>\n<p>which will also give you the option of removing the test<br \/>\ndatabases and anonymous user created by default.  This is<br \/>\nstrongly recommended for production servers.<\/p>\n<p>See the manual for more instructions.<\/p>\n<p>You can start the MySQL daemon with:<br \/>\ncd \/usr ; \/usr\/bin\/mysqld_safe &amp;<\/p>\n<p>You can test the MySQL daemon with mysql-test-run.pl<br \/>\ncd \/usr\/mysql-test ; perl mysql-test-run.pl<\/p>\n<p>Please report any problems with the \/usr\/bin\/mysqlbug script!<\/p>\n<p>                                                           [  OK  ]<br \/>\nmysqld \u3092\u8d77\u52d5\u4e2d:                                           [  OK  ]<br \/>\n[\/bash]<\/p>\n<p>\u25a0MySQL Server\u306e\u81ea\u52d5\u8d77\u52d5\u8a2d\u5b9a<br \/>\n[bash]<br \/>\nchkconfig mysqld on<br \/>\nchkconfig &#8211;list mysqld<br \/>\nmysqld   0:off   1:off   2:on    3:on    4:on    5:on    6:off<br \/>\n[\/bash]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e45\u3057\u3076\u308a\u306b\u30b5\u30fc\u30d0\u69cb\u7bc9\u3059\u308b\u3053\u3068\u3068\u306a\u308a\u3001CentOS5.8\u306bMySQL5.5\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3088\u3046\u3068\u3059\u308b\u3002 \u4ee5\u524d\u306e\u8a18\u4e8b\u304b\u3089\u3001\u65e2\u306b1\u5e74\u4ee5\u4e0a\u304c\u7d4c\u3063\u3066\u3001\u3082\u306f\u3084\u305d\u306e\u901a\u308a\u306b\u52d5\u4f5c\u3057\u3066\u3044\u306a\u3044\u3053\u3068\u306b\u6c17\u4ed8\u304f\u3002 \u518d\u5ea6\u899a\u3048\u66f8\u304d\u3068\u3059\u308b\u3002 \u25a0yum \u30ec [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"saved_in_kubio":false,"footnotes":""},"categories":[5,11,4],"tags":[],"class_list":["post-744","post","type-post","status-publish","format-standard","hentry","category-centos","category-mysql","category-tech"],"_links":{"self":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/744","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=744"}],"version-history":[{"count":8,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/744\/revisions"}],"predecessor-version":[{"id":746,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/744\/revisions\/746"}],"wp:attachment":[{"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=744"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=744"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.blowfish.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=744"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}