0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 3 years have passed since last update.

Mysqlエラー:ERROR! The server quit without updating PID file

0
Posted at

環境

$ mysql --version
mysql  Ver 8.0.26 for macos11.3 on x86_64 (Homebrew)

状況

Mysql起動時に下記の権限エラー

$ mysql.server start

Starting MySQL
./usr/local/Cellar/mysql/8.0.25_1/bin/mysqld_safe: line 144: /usr/local/var/mysql/XXXXXXMacBook-Pro.local.err: Permission denied
/usr/local/Cellar/mysql/8.0.25_1/bin/mysqld_safe: line 144: /usr/local/var/mysql/XXXXXXMacBook-Pro.local.err: Permission denied
/usr/local/Cellar/mysql/8.0.25_1/bin/mysqld_safe: line 199: /usr/local/var/mysql/XXXXXXMacBook-Pro.local.err: Permission denied
/usr/local/Cellar/mysql/8.0.25_1/bin/mysqld_safe: line 144: /usr/local/var/mysql/XXXXXXMacBook-Pro.local.err: Permission denied
ERROR! The server quit without updating PID file (/usr/local/var/mysql/XXXXXXMacBook-Pro.local.pid).

様々な記事を参考に試したが解決できず…
・PC再起動
・Mysql再起動
・権限付与

解決方法

最終手段としてMysqlを再インストールすることにした
HomebrewでのMysqlの再インストールが丁寧に説明されていて分かりやすかった
→無事にMysql起動できた!

参考

エラー解消で試したこと

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?