Mysql2::Error::ConnectionError (Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)):
EC2から逃げ帰って来たらこんなこと言われた
Mysql2::Error::ConnectionError (Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)):
とりあえずMYSQLをリセットしてみた
sudo mysql.server restart
ERROR! MySQL server PID file could not be found!
Starting MySQL
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/rajakarunikarukaryoumanoMacBook-Pro.local.pid).
怒られた
データベースを作成してみる
rails db:create
Mysql2::Error: Can't create database 'debate_app_development' (errno: 2)
Couldn't create 'debate_app_development' database. Please check your configuration.
rails aborted!
ActiveRecord::StatementInvalid: Mysql2::Error: Can't create database 'debate_app_development' (errno: 2)
/Users/rajakarunikarukaryouma/projects/debate-app/bin/rails:9:in `<top (required)>'
/Users/rajakarunikarukaryouma/projects/debate-app/bin/spring:15:in `<top (required)>'
bin/rails:3:in `load'
bin/rails:3:in `<main>'
Caused by:
Mysql2::Error: Can't create database 'debate_app_development' (errno: 2)
/Users/rajakarunikarukaryouma/projects/debate-app/bin/rails:9:in `<top (required)>'
/Users/rajakarunikarukaryouma/projects/debate-app/bin/spring:15:in `<top (required)>'
bin/rails:3:in `load'
bin/rails:3:in `<main>'
Tasks: TOP => db:create
(See full trace by running task with --trace)
めっちゃ怒られた
腹が立ってここから色々それっぽいのやりまくった
sudo rm -rf /Library/StartupItems/MYSQL
sudo rm -rf /Library/PreferencePanes/MySQL.prefPane
sudo rm -rf /Library/Receipts/mysql-.pkg
sudo rm -rf /usr/local/Cellar/mysql*
sudo rm -rf /usr/local/bin/mysql*
sudo rm -rf /usr/local/var/mysql*
sudo rm -rf /usr/local/etc/my.cnf
sudo rm -rf /usr/local/share/mysql*
sudo rm -rf /usr/local/opt/mysql*
sudo rm -rf /usr/local/var/mysql/MacBook-Air.local.pid
確認してみたら
rails s
/Users/rajakarunikarukaryouma/.rbenv/versions/2.6.5/lib/ruby/gems/2.6.0/gems/bootsnap-1.5.1/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:23:in `require': dlopen(/Users/rajakarunikarukaryouma/.rbenv/versions/2.6.5/lib/ruby/gems/2.6.0/gems/mysql2-0.5.3/lib/mysql2/mysql2.bundle, 9): Library not loaded: /usr/local/opt/mysql@5.6/lib/libmysqlclient.18.dylib (LoadError)
Referenced from: /Users/rajakarunikarukaryouma/.rbenv/versions/2.6.5/lib/ruby/gems/2.6.0/gems/mysql2-0.5.3/lib/mysql2/mysql2.bundle
Reason: image not found - /Users/rajakarunikarukaryouma/.rbenv/versions/2.6.5/lib/ruby/gems/2.6.0/gems/mysql2-0.5.3/lib/mysql2/mysql2.bundle
怒られた多分大事なのはLoadErrorだからそれで検索かけてみた
そしてbundle installしてみた
まあ結果変わらなかったので
ムカついて殺しまくった
そして色々調べたらこのコマンドの世界には医者がいることが判明した
bundle doctor
こいつが病気を見つけてくれる
早速使ってみた
The following gems are missing OS dependencies:
* mysql2: /usr/local/opt/mysql@5.6/lib/libmysqlclient.18.dylib
これを検索して
bundle exec gem uninstall mysql2
そして、もう一回診断してもらった診断料が無料なのはいいね
The following gems are missing
* mysql2 (0.5.3)
Install missing gems with `bundle install`
言われた通りに
bundle install してみた
そしてrails s
rails s
ActiveRecord::NoDatabaseError (Unknown database 'debate_app_development'):
忘れてた
rails db:create
さあも一度だ!
ActiveRecord::PendingMigrationError (
Migrations are pending. To resolve this issue, run:
rails db:migrate RAILS_ENV=development
泣きたい!!
rails db:migrate:status
Schema migrations table does not exist yet.
あーなるほどテーブルがないのか
rails db:migrate:reset
これでどうだ
rails s
Completed 200 OK
来たー
寝よ!おアプデ来てるじゃんMACのOSがかわったのか〜
アプデ後
Mysql2::Error::ConnectionError (Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)):
嘘だ信じたくない!!
sudo mysql.server restart
Completed 200 OK
ヤッター寝よ
次の日
昨日SQL色々触ったけどどうなったんだろう?
嘘だろ次回に続く