{"id":169,"date":"2018-11-26T17:34:14","date_gmt":"2018-11-26T17:34:14","guid":{"rendered":"https:\/\/oidema-jp.com\/media\/2018-11-26-173414\/"},"modified":"2023-04-21T10:29:38","modified_gmt":"2023-04-21T01:29:38","slug":"2018-11-26-173414","status":"publish","type":"post","link":"https:\/\/oidema-jp.com\/media\/2018-11-26-173414\/","title":{"rendered":"mysql8.0.1\u306b\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u3057\u305f\u3089Rails\u306b\u6012\u3089\u308c\u305f"},"content":{"rendered":"<h2 id=\"i-0\">\u8d77\u3053\u3063\u305f\u4e8b<\/h2>\n<p><code>rails s<\/code>\u3067\u30ed\u30fc\u30ab\u30eb\u3067\u30a2\u30d7\u30ea\u3092\u8d77\u52d5\u3057\u3088\u3046\u3068\u3057\u305f\u3068\u3053\u308d\u3001mysql\u306e\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u305f\u305f\u3081\u5bfe\u5fdc\u3092\u884c\u3063\u305f\u3002<\/p>\n<p>\u5185\u5bb9\u3092\u7406\u89e3\u3057\u3066\u3044\u306a\u3044\u304c\u3001\u5f8c\u304b\u3089\u632f\u308a\u8fd4\u308b\u305f\u3081\u5bfe\u5fdc\u3092\u3053\u3053\u306b\u30e1\u30e2\u3057\u3066\u304a\u304f\u3002<\/p>\n<h2 id=\"i-1\">\u767a\u751f\u3057\u305f\u30a8\u30e9\u30fc<\/h2>\n<blockquote><p>\/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/mysql2-0.4.10\/lib\/mysql2.rb:31:in <code>require': dlopen(\/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/mysql2-0.4.10\/lib\/mysql2\/mysql2.bundle, 9): Library not loaded: \/usr\/local\/opt\/mysql\/lib\/libmysqlclient.20.dylib (LoadError)<br \/>\nReferenced from: \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/mysql2-0.4.10\/lib\/mysql2\/mysql2.bundle<br \/>\nReason: image not found - \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/mysql2-0.4.10\/lib\/mysql2\/mysql2.bundle<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/mysql2-0.4.10\/lib\/mysql2.rb:31:in<\/code>\u2018<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/bundler-1.16.5\/lib\/bundler\/runtime.rb:81:in <code>require'<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/bundler-1.16.5\/lib\/bundler\/runtime.rb:81:in<\/code>block (2 levels) in require\u2019<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/<a class=\"keyword\" href=\"http:\/\/d.hatena.ne.jp\/keyword\/ruby\">ru<\/a>b<a class=\"keyword\" href=\"http:\/\/d.hatena.ne.jp\/keyword\/ruby\">y<\/a>\/gems\/2.3.0\/gems\/bundler-1.16.5\/lib\/bundler\/runtime.rb:76:in <code>each'<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/bundler-1.16.5\/lib\/bundler\/runtime.rb:76:in<\/code>block in require\u2019<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/bundler-1.16.5\/lib\/bundler\/runtime.rb:65:in <code>each'<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/bundler-1.16.5\/lib\/bundler\/runtime.rb:65:in<\/code>require\u2019<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/bundler-1.16.5\/lib\/bundler.rb:114:in <code>require'<br \/>\nfrom \/Users\/user_name\/projects\/chat-space\/config\/application.rb:5:in<\/code>\u2018<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/railties-5.0.7\/lib\/rails\/commands\/commands_tasks.rb:88:in <code>require'<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/railties-5.0.7\/lib\/rails\/commands\/commands_tasks.rb:88:in<\/code>block in server\u2019<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/railties-5.0.7\/lib\/rails\/commands\/commands_tasks.rb:85:in <code>tap'<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/railties-5.0.7\/lib\/rails\/commands\/commands_tasks.rb:85:in<\/code>server\u2019<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/railties-5.0.7\/lib\/rails\/commands\/commands_tasks.rb:49:in <code>run_command!'<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/railties-5.0.7\/lib\/rails\/commands.rb:18:in<\/code>\u2018<br \/>\nfrom \/Users\/user_name\/projects\/chat-space\/bin\/rails:9:in <code>require'<br \/>\nfrom \/Users\/user_name\/projects\/chat-space\/bin\/rails:9:in<\/code>\u2018<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/spring-2.0.2\/lib\/spring\/client\/rails.rb:28:in <code>load'<br \/>\nfrom \/Users\/user_name\u540d\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/spring-2.0.2\/lib\/spring\/client\/rails.rb:28:in<\/code>call\u2019<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/spring-2.0.2\/lib\/spring\/client\/command.rb:7:in <code>call'<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/spring-2.0.2\/lib\/spring\/client.rb:30:in<\/code>run\u2019<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/spring-2.0.2\/bin\/spring:49:in <code>&lt;top (required)&gt;'<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/spring-2.0.2\/lib\/spring\/binstub.rb:31:in<\/code>load\u2019<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/gems\/2.3.0\/gems\/spring-2.0.2\/lib\/spring\/binstub.rb:31:in <code>&lt;top (required)&gt;'<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/2.3.0\/rubygems\/core_ext\/kernel_require.rb:68:in<\/code>require\u2019<br \/>\nfrom \/Users\/user_name\/.rbenv\/versions\/2.3.1\/lib\/ruby\/2.3.0\/rubygems\/core_ext\/kernel_require.rb:68:in <code>require'<br \/>\nfrom \/Users\/user_name\/projects\/chat-space\/bin\/spring:15:in<\/code>\u2018<br \/>\nfrom bin\/rails:3:in <code>load'<br \/>\nfrom bin\/rails:3:in<\/code><\/p>\n<p><main>\u2018<\/p>\n<p><\/main><\/p><\/blockquote>\n<p>\u6b21\u306b<code>bundle doctor<\/code>\u3067\u539f\u56e0\u3092\u8abf\u3079\u3066\u307f\u308b\u3002<\/p>\n<pre class=\"code\" data-lang=\"\" data-unlink=\"\">bundle doctor<\/pre>\n<p>\u3053\u3046\u3044\u3046\u306e\u304c\u5e30\u3063\u3066\u304d\u305f\u3002<\/p>\n<blockquote><p>The Gemfile\u2019s dependencies are satisfied<br \/>\nThe following gems are missing OS dependencies:<br \/>\n* mysql2: \/usr\/local\/opt\/mysql\/lib\/libmysqlclient.20.dylib<\/p><\/blockquote>\n<h2 id=\"i-2\">\u89e3\u6c7a\u306e\u305f\u3081\u306b\u5b9f\u884c\u3057\u305f\u30b3\u30de\u30f3\u30c9<\/h2>\n<pre class=\"code\" data-lang=\"\" data-unlink=\"\">bundle exec gem uninstall mysql2 &amp;&amp; bundle install<\/pre>\n<p>\u3053\u3093\u306a\u306e\u304c\u51fa\u3066\u304f\u308b<\/p>\n<blockquote><p>Select gem to uninstall:<\/p>\n<p>1. mysql2-0.3.18<\/p>\n<p>2. mysql2-0.3.20<\/p>\n<p>3. mysql2-0.3.21<\/p>\n<p>4. mysql2-0.4.5<\/p>\n<p>5. mysql2-0.4.10<\/p>\n<p>6. mysql2-0.5.1<\/p>\n<p>7. All versions<\/p><\/blockquote>\n<ol>\n<li>All versions\u3067\u5b9f\u884c\u3057\u305f\u3002<\/li>\n<\/ol>\n<p>\u6b21\u306b\u3053\u3061\u3089\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c<\/p>\n<pre class=\"code\" data-lang=\"\" data-unlink=\"\">mysql_upgrade -uroot<\/pre>\n<p>\u3053\u3093\u306a\u306e\u304c\u5e30\u3063\u3066\u304d\u305f\u3002<\/p>\n<blockquote><p>Checking if update is needed.<br \/>\nChecking server version.<br \/>\nError: Server version (5.6.42) does not match with the version of<br \/>\nthe server (8.0.12) with which this program was built\/distributed. You can<br \/>\nuse \u2013skip-version-check to skip this check.<\/p><\/blockquote>\n<p>\u3053\u3061\u3089\u3082\u5b9f\u884c\u3057\u3066\u307f\u308b<\/p>\n<pre class=\"code\" data-lang=\"\" data-unlink=\"\">ls -l \/usr\/local\/opt\/mysql\/lib<\/pre>\n<blockquote><p>total 22408<br \/>\n-rw-r\u2013r\u2013 1 user_name staff 5418880 11 26 01:16 libmysqlclient.21.dylib<br \/>\n-r\u2013r\u2013r\u2013 1 user_name staff 6038128 6 29 01:42 libmysqlclient.a<br \/>\nlrwxr-xr-x 1 user_name staff 23 6 29 01:42 libmysqlclient.dylib -&gt; libmysqlclient.21.dylib<br \/>\n-r\u2013r\u2013r\u2013 1 user_name staff 9760 6 29 01:42 libmysqlservices.a<br \/>\ndrwxr-xr-x 3 user_name staff 96 11 26 01:16 pkgconfig<br \/>\ndrwxr-xr-x 91 user_name staff 2912 6 29 01:42 plugin<\/p><\/blockquote>\n<p>\u3068\u308a\u3042\u3048\u305a\u3001\u3053\u306e\u30b3\u30de\u30f3\u30c9\u9054\u3092\u6d41\u3059\u3068\u30a8\u30e9\u30fc\u306f\u89e3\u6c7a\u3057\u305f\u3002<\/p>\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td>\n<div style=\"border: 1px solid #95a5a6; border-radius: .75rem; background-color: #ffffff; width: 824px; margin: 0px; padding: 5px; text-align: center; overflow: hidden;\">\n<table>\n<tbody>\n<tr>\n<td style=\"width: 400px;\"><a style=\"word-wrap: break-word;\" href=\"https:\/\/hb.afl.rakuten.co.jp\/hgc\/1804a342.334a3c66.1804a343.381802a7\/?pc=https%3A%2F%2Fitem.rakuten.co.jp%2Fbook%2F15628625%2F&amp;m=http%3A%2F%2Fm.rakuten.co.jp%2Fbook%2Fi%2F19319301%2F&amp;link_type=picttext&amp;ut=eyJwYWdlIjoiaXRlbSIsInR5cGUiOiJwaWN0dGV4dCIsInNpemUiOiI0MDB4NDAwIiwibmFtIjoxLCJuYW1wIjoicmlnaHQiLCJjb20iOjEsImNvbXAiOiJkb3duIiwicHJpY2UiOjEsImJvciI6MSwiY29sIjoxLCJiYnRuIjoxfQ%3D%3D\" target=\"_blank\" rel=\"nofollow noopener noreferrer\"><img decoding=\"async\" style=\"margin: 2px;\" title=\"[\u5546\u54c1\u4fa1\u683c\u306b\u95a2\u3057\u307e\u3057\u3066\u306f\u3001\u30ea\u30f3\u30af\u304c\u4f5c\u6210\u3055\u308c\u305f\u6642\u70b9\u3068\u73fe\u6642\u70b9\u3067\u60c5\u5831\u304c\u5909\u66f4\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u304c\u3054\u3056\u3044\u307e\u3059\u3002]\" src=\"https:\/\/hbb.afl.rakuten.co.jp\/hgb\/1804a342.334a3c66.1804a343.381802a7\/?me_id=1213310&amp;item_id=19319301&amp;m=https%3A%2F%2Fthumbnail.image.rakuten.co.jp%2F%400_mall%2Fbook%2Fcabinet%2F2227%2F9784839962227.jpg%3F_ex%3D80x80&amp;pc=https%3A%2F%2Fthumbnail.image.rakuten.co.jp%2F%400_mall%2Fbook%2Fcabinet%2F2227%2F9784839962227.jpg%3F_ex%3D400x400&amp;s=400x400&amp;t=picttext\" alt=\"[\u5546\u54c1\u4fa1\u683c\u306b\u95a2\u3057\u307e\u3057\u3066\u306f\u3001\u30ea\u30f3\u30af\u304c\u4f5c\u6210\u3055\u308c\u305f\u6642\u70b9\u3068\u73fe\u6642\u70b9\u3067\u60c5\u5831\u304c\u5909\u66f4\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u304c\u3054\u3056\u3044\u307e\u3059\u3002]\" border=\"0\"><\/a><\/td>\n<td style=\"vertical-align: top; width: 408px;\">\n<p style=\"font-size: 12px; line-height: 1.4em; text-align: left; margin: 0px; padding: 2px 6px; word-wrap: break-word;\"><a style=\"word-wrap: break-word;\" href=\"https:\/\/hb.afl.rakuten.co.jp\/hgc\/1804a342.334a3c66.1804a343.381802a7\/?pc=https%3A%2F%2Fitem.rakuten.co.jp%2Fbook%2F15628625%2F&amp;m=http%3A%2F%2Fm.rakuten.co.jp%2Fbook%2Fi%2F19319301%2F&amp;link_type=picttext&amp;ut=eyJwYWdlIjoiaXRlbSIsInR5cGUiOiJwaWN0dGV4dCIsInNpemUiOiI0MDB4NDAwIiwibmFtIjoxLCJuYW1wIjoicmlnaHQiLCJjb20iOjEsImNvbXAiOiJkb3duIiwicHJpY2UiOjEsImJvciI6MSwiY29sIjoxLCJiYnRuIjoxfQ%3D%3D\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">\u73fe\u5834\u3067\u4f7f\u3048\u308b Ruby on Rails 5\u901f\u7fd2\u5b9f\u8df5\u30ac\u30a4\u30c9 [ \u5927\u5834\u5be7\u5b50 ]<\/a><br \/>\n\u4fa1\u683c\uff1a3758\u5186\uff08\u7a0e\u8fbc\u3001\u9001\u6599\u7121\u6599) <span style=\"color: #bbb;\">(2019\/3\/6\u6642\u70b9)<\/span><\/p>\n<div style=\"margin: 15px;\"><a style=\"word-wrap: break-word;\" href=\"https:\/\/hb.afl.rakuten.co.jp\/hgc\/1804a342.334a3c66.1804a343.381802a7\/?pc=https%3A%2F%2Fitem.rakuten.co.jp%2Fbook%2F15628625%2F&amp;m=http%3A%2F%2Fm.rakuten.co.jp%2Fbook%2Fi%2F19319301%2F&amp;link_type=picttext&amp;ut=eyJwYWdlIjoiaXRlbSIsInR5cGUiOiJwaWN0dGV4dCIsInNpemUiOiI0MDB4NDAwIiwibmFtIjoxLCJuYW1wIjoicmlnaHQiLCJjb20iOjEsImNvbXAiOiJkb3duIiwicHJpY2UiOjEsImJvciI6MSwiY29sIjoxLCJiYnRuIjoxfQ%3D%3D\" target=\"_blank\" rel=\"nofollow noopener noreferrer\"><img decoding=\"async\" style=\"float: left; max-height: 27px; width: auto; margin-top: 5px;\" src=\"https:\/\/static.affiliate.rakuten.co.jp\/makelink\/rl.svg\"><\/a><\/p>\n<div style=\"float: right; width: 50%; height: 32px; background-color: #bf0000; color: #fff !important; font-size: 14px; font-weight: 500; line-height: 32px; margin-left: 1px; padding: 0 12px; border-radius: 16px; cursor: pointer; text-align: center;\">\u697d\u5929\u3067\u8cfc\u5165<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p style=\"color: #000000; font-size: 12px; line-height: 1.4em; margin: 5px; word-wrap: break-word;\">\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>\u8d77\u3053\u3063\u305f\u4e8b rails s\u3067\u30ed\u30fc\u30ab\u30eb\u3067\u30a2\u30d7\u30ea\u3092\u8d77\u52d5\u3057\u3088\u3046\u3068\u3057\u305f\u3068\u3053\u308d\u3001mysql\u306e\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u305f\u305f\u3081\u5bfe\u5fdc\u3092\u884c\u3063\u305f\u3002 \u5185\u5bb9\u3092\u7406\u89e3\u3057\u3066\u3044\u306a\u3044\u304c\u3001\u5f8c\u304b\u3089\u632f\u308a\u8fd4\u308b\u305f\u3081\u5bfe\u5fdc\u3092\u3053\u3053\u306b\u30e1\u30e2\u3057\u3066\u304a\u304f\u3002 \u767a\u751f\u3057\u305f\u30a8\u30e9\u30fc \/Users\/u &#8230; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"om_disable_all_campaigns":false,"footnotes":""},"categories":[21,15],"tags":[],"class_list":{"0":"post-169","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-rails","7":"category-15","8":"entry","9":"nothumb"},"acf":[],"aioseo_notices":[],"mb":[],"mfb_rest_fields":["title","aioseo_notices"],"_links":{"self":[{"href":"https:\/\/oidema-jp.com\/media\/wp-json\/wp\/v2\/posts\/169","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oidema-jp.com\/media\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oidema-jp.com\/media\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oidema-jp.com\/media\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oidema-jp.com\/media\/wp-json\/wp\/v2\/comments?post=169"}],"version-history":[{"count":2,"href":"https:\/\/oidema-jp.com\/media\/wp-json\/wp\/v2\/posts\/169\/revisions"}],"predecessor-version":[{"id":1458,"href":"https:\/\/oidema-jp.com\/media\/wp-json\/wp\/v2\/posts\/169\/revisions\/1458"}],"wp:attachment":[{"href":"https:\/\/oidema-jp.com\/media\/wp-json\/wp\/v2\/media?parent=169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oidema-jp.com\/media\/wp-json\/wp\/v2\/categories?post=169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oidema-jp.com\/media\/wp-json\/wp\/v2\/tags?post=169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}