少し前までは普通にrailsでのアプリ開発ができていたのですが、数週間ぶりにローカルでアプリをつくろうとしたところ、rake db:createでエラーが出てしまいました。
諸々やってもうまくいかなかったため、MySQLをbrewコマンドでアンインストールして、再度インストールしましたが、それでも解決できませんでした。。
ざっくりとした質問で申し訳ありませんが、どなたかアドバイスをいただけると幸いです。
環境
mac OS
Rails 6.0.2.1
ruby 2.5.1
mysql
エラー詳細
(base) $ rails new アプリ名 -d mysql (base) $ cd アプリ名 (base) $ rake db:create rake aborted! LoadError: Error loading the 'mysql2' Active Record adapter. Missing a gem it depends on? cannot load such file -- mysql2 Caused by: LoadError: cannot load such file -- mysql2 Caused by: Bootsnap::LoadPathCache::FallbackScan: Tasks: TOP => db:create => db:load_config (See full trace by running task with --trace)
関係があるかどうかわかりませんが、
+---------------+-----------+ | user | host | +---------------+-----------+ | mysql.session | localhost | | mysql.sys | localhost | | root | localhost | +---------------+-----------+
以前はMySQLのuserが上記のようになっていた気がするのですが、今回調べてみたところ、
以下のようにrootのみになってしまっていました。
こちらもWEBで調べましたが、追加方法が不明で対応できていません。。
(base) $ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 Server version: 5.6.43 Homebrew Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select user, host from user; +------+-----------+ | user | host | +------+-----------+ | root | localhost | +------+-----------+ 1 row in set (0.01 sec)
追加
Gemfile
source 'https://rubygems.org' git_source(:github) { |repo| "https://github.com/#{repo}.git" } ruby '2.5.1' # Bundle edge Rails instead: gem 'rails', github: 'rails/rails' gem 'rails', '~> 6.0.2', '>= 6.0.2.1' # Use mysql as the database for Active Record gem 'mysql2', '>= 0.4.4' # Use Puma as the app server gem 'puma', '~> 4.1' # Use SCSS for stylesheets gem 'sass-rails', '>= 6' # Transpile app-like JavaScript. Read more: https://github.com/rails/webpacker gem 'webpacker', '~> 4.0' # Turbolinks makes navigating your web application faster. Read more: https://github.com/turbolinks/turbolinks gem 'turbolinks', '~> 5' # Build JSON APIs with ease. Read more: https://github.com/rails/jbuilder gem 'jbuilder', '~> 2.7' # Use Redis adapter to run Action Cable in production # gem 'redis', '~> 4.0' # Use Active Model has_secure_password # gem 'bcrypt', '~> 3.1.7' # Use Active Storage variant # gem 'image_processing', '~> 1.2' # Reduces boot times through caching; required in config/boot.rb gem 'bootsnap', '>= 1.4.2', require: false group :development, :test do # Call 'byebug' anywhere in the code to stop execution and get a debugger console gem 'byebug', platforms: [:mri, :mingw, :x64_mingw] end group :development do # Access an interactive console on exception pages or by calling 'console' anywhere in the code. gem 'web-console', '>= 3.3.0' gem 'listen', '>= 3.0.5', '< 3.2' # Spring speeds up development by keeping your application running in the background. Read more: https://github.com/rails/spring gem 'spring' gem 'spring-watcher-listen', '~> 2.0.0' end group :test do # Adds support for Capybara system testing and selenium driver gem 'capybara', '>= 2.15' gem 'selenium-webdriver' # Easy installation and use of web drivers to run system tests with browsers gem 'webdrivers' end # Windows does not include zoneinfo files, so bundle the tzinfo-data gem gem 'tzinfo-data', platforms: [:mingw, :mswin, :x64_mingw, :jruby]
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。
2020/01/13 15:56
2020/01/14 00:25
2020/01/14 01:22 編集