mysqlよくつまるところ

mysqlをbrewでインストールする時のログ

以下に記述もあるように、mysql_secure_installationで最初にパスワードの初期設定などが必要みたい

We've installed your MySQL database without a root password. To secure it run:
    mysql_secure_installation

MySQL is configured to only allow connections from localhost by default

To connect run:
    mysql -uroot

mysql@5.7 is keg-only, which means it was not symlinked into /usr/local,
because this is an alternate version of another formula.

If you need to have mysql@5.7 first in your PATH, run:
  echo 'export PATH="/usr/local/opt/mysql@5.7/bin:$PATH"' >> ~/.zshrc

For compilers to find mysql@5.7 you may need to set:
  export LDFLAGS="-L/usr/local/opt/mysql@5.7/lib"
  export CPPFLAGS="-I/usr/local/opt/mysql@5.7/include"

For pkg-config to find mysql@5.7 you may need to set:
  export PKG_CONFIG_PATH="/usr/local/opt/mysql@5.7/lib/pkgconfig"


To restart mysql@5.7 after an upgrade:
  brew services restart mysql@5.7
Or, if you don't want/need a background service you can just run:
  /usr/local/opt/mysql@5.7/bin/mysqld_safe --datadir=/usr/local/var/mysql
==> Summary
🍺  /usr/local/Cellar/mysql@5.7/5.7.40: 320 files, 233.5MB
==> Running `brew cleanup mysql@5.7`...
Disable this behaviour by setting HOMEBREW_NO_INSTALL_CLEANUP.
Hide these hints with HOMEBREW_NO_ENV_HINTS (see `man brew`).

エラーログ

↑をやって、mysqlを起動してないと以下のようなログが出る
・Mysql2::Error::ConnectionError: Can't connect to MySQL server on '127.0.0.1'
・ERROR! The server quit without updating PID file (/usr/local/var/mysql/端末名.local.pid).
・ Can't connect to local MySQL server through socket '/tmp/mysql.sock'

mysqlとbrewとバージョン

brewでmysqlでインストールすると関連コマンドがmysql@5.7みたいになったりするので注意