{"id":25,"date":"2017-11-23T08:00:22","date_gmt":"2017-11-22T23:00:22","guid":{"rendered":"http:\/\/www.itc109.com\/knowledge\/?p=25"},"modified":"2021-09-30T09:00:27","modified_gmt":"2021-09-30T00:00:27","slug":"install-target-version","status":"publish","type":"post","link":"https:\/\/www.itc109.com\/knowledge\/linux\/install-target-version","title":{"rendered":"\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u6307\u5b9a\u3057\u3066MySQL\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b"},"content":{"rendered":"<h4><strong>\u6982\u8981<\/strong><\/h4>\n<hr \/>\n<p>\u6700\u65b0\u7248\u306eMySQL\u3067\u306f\u306a\u304f\u3001\u6307\u5b9a\u3057\u305f\u30d0\u30fc\u30b8\u30e7\u30f3\u306eMySQL\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u624b\u9806\u306b\u3064\u3044\u3066\u8a18\u8f09\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h4><strong>\u624b\u9806<\/strong><\/h4>\n<hr \/>\n<p><strong>1.\u30ea\u30dd\u30b8\u30c8\u30ea\u306e\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/strong><\/p>\n<p>Download MySQL Yum Repository\u3000\u203b2017\/09 \u73fe\u5728<br \/>\n<a href=\"https:\/\/dev.mysql.com\/downloads\/repo\/yum\/\" target=\"_blank\" rel=\"noopener\">https:\/\/dev.mysql.com\/downloads\/repo\/yum\/<\/a><\/p>\n<pre>\r\nsudo yum install http:\/\/dev.mysql.com\/get\/mysql57-community-release-el7-11.noarch.rpm\r\n<\/pre>\n<p>\u5b9f\u884c\u7d50\u679c<\/p>\n<pre>\r\nLoaded plugins: fastestmirror\r\nmysql57-community-release-el7-11.noarch.rpm              |  25 kB     00:00\r\nExamining \/var\/tmp\/yum-root-WxGpfy\/mysql57-community-release-el7-11.noarch.rpm:                                                                                                                                                              mysql57-community-release-el7-11.noarch\r\nMarking \/var\/tmp\/yum-root-WxGpfy\/mysql57-community-release-el7-11.noarch.rpm to                                                                                                                                                              be installed\r\nResolving Dependencies\r\n--> Running transaction check\r\n---> Package mysql57-community-release.noarch 0:el7-11 will be installed\r\n--> Finished Dependency Resolution\r\n\r\nDependencies Resolved\r\n\r\n================================================================================\r\n Package           Arch   Version\r\n                                 Repository                                Size\r\n================================================================================\r\nInstalling:\r\n mysql57-community-release\r\n                   noarch el7-11 \/mysql57-community-release-el7-11.noarch  31 k\r\n\r\nTransaction Summary\r\n================================================================================\r\nInstall  1 Package\r\n\r\nTotal size: 31 k\r\nInstalled size: 31 k\r\n<\/pre>\n<p>\u78ba\u8a8d\u3092\u6c42\u3081\u3089\u308c\u305f\u3089\u300cy\u300d\u3092\u5165\u529b\u3057\u3066Enter<\/p>\n<pre>\r\nIs this ok [y\/d\/N]: y\r\n<\/pre>\n<p>\u5b9f\u884c\u7d50\u679c<\/p>\n<pre>\r\nDownloading packages:\r\nRunning transaction check\r\nRunning transaction test\r\nTransaction test succeeded\r\nRunning transaction\r\n  Installing : mysql57-community-release-el7-11.noarch                      1\/1\r\n  Verifying  : mysql57-community-release-el7-11.noarch                      1\/1\r\n\r\nInstalled:\r\n  mysql57-community-release.noarch 0:el7-11\r\n\r\nComplete!\r\n<\/pre>\n<p>\u6700\u7d42\u884c\u306b\u300cComplete!\u300d\u3068\u8868\u793a\u3055\u308c\u624b\u5165\u308c\u3070\u6210\u529f\u3067\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<p><strong>2.\u30ea\u30dd\u30b8\u30c8\u30ea\u3092\u7de8\u96c6\u3057\u307e\u3059\u3002<\/strong><\/p>\n<p>\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\uff1a\/etc\/yum.repos.d\/mysql-community.repo<\/p>\n<pre>\r\nsudo vi \/etc\/yum.repos.d\/mysql-community.repo\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p>\u4f8b<br \/>\n5.6 \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u305f\u3081\u3001enabled=1<br \/>\n5.7 \u304c\u30c7\u30d5\u30a9\u30eb\u30c8\u3067 1 \u3060\u3063\u305f\u305f\u3081\u3001enabled=0<\/p>\n<pre mark=\"27,34\">\r\n[mysql-connectors-community]\r\nname=MySQL Connectors Community\r\nbaseurl=http:\/\/repo.mysql.com\/yum\/mysql-connectors-community\/el\/7\/$basearch\/\r\nenabled=1\r\ngpgcheck=1\r\ngpgkey=file:\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-mysql\r\n\r\n[mysql-tools-community]\r\nname=MySQL Tools Community\r\nbaseurl=http:\/\/repo.mysql.com\/yum\/mysql-tools-community\/el\/7\/$basearch\/\r\nenabled=1\r\ngpgcheck=1\r\ngpgkey=file:\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-mysql\r\n\r\n# Enable to use MySQL 5.5\r\n[mysql55-community]\r\nname=MySQL 5.5 Community Server\r\nbaseurl=http:\/\/repo.mysql.com\/yum\/mysql-5.5-community\/el\/7\/$basearch\/\r\nenabled=0\r\ngpgcheck=1\r\ngpgkey=file:\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-mysql\r\n\r\n# Enable to use MySQL 5.6\r\n[mysql56-community]\r\nname=MySQL 5.6 Community Server\r\nbaseurl=http:\/\/repo.mysql.com\/yum\/mysql-5.6-community\/el\/7\/$basearch\/\r\nenabled=0\u3000\u2192\u30001\r\ngpgcheck=1\r\ngpgkey=file:\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-mysql\r\n\r\n[mysql57-community]\r\nname=MySQL 5.7 Community Server\r\nbaseurl=http:\/\/repo.mysql.com\/yum\/mysql-5.7-community\/el\/7\/$basearch\/\r\nenabled=1\u3000\u2192\u30000\r\ngpgcheck=1\r\ngpgkey=file:\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-mysql\r\n\r\n[mysql80-community]\r\nname=MySQL 8.0 Community Server\r\nbaseurl=http:\/\/repo.mysql.com\/yum\/mysql-8.0-community\/el\/7\/$basearch\/\r\nenabled=0\r\ngpgcheck=1\r\ngpgkey=file:\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-mysql\r\n\r\n[mysql-tools-preview]\r\nname=MySQL Tools Preview\r\nbaseurl=http:\/\/repo.mysql.com\/yum\/mysql-tools-preview\/el\/7\/$basearch\/\r\nenabled=0\r\ngpgcheck=1\r\ngpgkey=file:\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-mysql\r\n\r\n[mysql-cluster-7.5-community]\r\nname=MySQL Cluster 7.5 Community\r\nbaseurl=http:\/\/repo.mysql.com\/yum\/mysql-cluster-7.5-community\/el\/7\/$basearch\/\r\nenabled=0\r\ngpgcheck=1\r\ngpgkey=file:\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-mysql\r\n\r\n[mysql-cluster-7.6-community]\r\nname=MySQL Cluster 7.6 Community\r\nbaseurl=http:\/\/repo.mysql.com\/yum\/mysql-cluster-7.6-community\/el\/7\/$basearch\/\r\nenabled=0\r\ngpgcheck=1\r\ngpgkey=file:\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-mysql\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p>3.\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<br \/>\n\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n<pre>\r\nsudo yum -y install mysql\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p>4.\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<br \/>\n\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002\u3000\u203bmysql\u306b\u30ed\u30b0\u30a4\u30f3\u3057\u3066\u5b9f\u884c\u3002<\/p>\n<pre>\r\nselect -version();\r\n<\/pre>\n<p>\u5b9f\u884c\u7d50\u679c<\/p>\n<pre>\r\n+------------+\r\n| -version() |\r\n+------------+\r\n|       -5.6 |\r\n+------------+\r\n1 row in set, 1 warning (0.00 sec)\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h4><strong>\u88dc\u8db3<\/strong><\/h4>\n<hr \/>\n<h5><strong>MySQL\u3092\u30a2\u30f3\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b<\/strong><\/h5>\n<p><strong>1.MySQL\u306e\u505c\u6b62<\/strong><\/p>\n<pre>\r\n\/etc\/init.d\/mysqld stop\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>2.MySQL\u306e\u30a2\u30f3\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/strong><\/p>\n<pre>\r\nsudo yum -y remove mysql-server\r\nsudo yum -y remove mysql\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>3.MySQL\u30d5\u30a1\u30a4\u30eb\u306e\u524a\u9664<\/strong><\/p>\n<pre>\r\nrm -rf \/var\/lib\/mysql\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>4.\u78ba\u8a8d<br \/>\n<\/strong><\/p>\n<pre>\r\nrpm -qa | grep -i mysql\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h5><strong>RDS\u306b\u63a5\u7d9a\u3059\u308b<\/strong><\/h5>\n<pre>\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3057\u307e\u3059\u3002\r\n\r\n<pre>\r\nmysql -h RDS\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8 -P \u30dd\u30fc\u30c8\u756a\u53f7 -u \u30e6\u30fc\u30b6\u30fc\u540d -p \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\r\n<\/pre>\n<p>\u5b9f\u884c\u7d50\u679c<\/p>\n<pre>\r\n[ec2-user ~]\r\n\u2193\r\nmysql&amp;gt;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u6982\u8981 \u6700\u65b0\u7248\u306eMySQL\u3067\u306f\u306a\u304f\u3001\u6307\u5b9a\u3057\u305f\u30d0\u30fc\u30b8\u30e7\u30f3\u306eMySQL\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u624b\u9806\u306b\u3064\u3044\u3066\u8a18\u8f09\u3057\u3066\u3044\u307e\u3059\u3002 &nbsp; &nbsp; \u624b\u9806 1.\u30ea\u30dd\u30b8\u30c8\u30ea\u306e\u8ffd\u52a0\u3057\u307e\u3059\u3002 Download MySQL Yum Rep&#8230;<\/p>\n","protected":false},"author":3,"featured_media":46,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[23,3],"tags":[54],"class_list":["post-25","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-linux","tag-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.itc109.com\/knowledge\/wp-content\/uploads\/sites\/2\/logo\/logo-mysql.png","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pacZwp-p","_links":{"self":[{"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/posts\/25","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/comments?post=25"}],"version-history":[{"count":7,"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/posts\/25\/revisions"}],"predecessor-version":[{"id":1792,"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/posts\/25\/revisions\/1792"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/media\/46"}],"wp:attachment":[{"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/media?parent=25"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/categories?post=25"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itc109.com\/knowledge\/wp-json\/wp\/v2\/tags?post=25"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}