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 5 years have passed since last update.

mysqlエラー備忘録

Last updated at Posted at 2019-09-14

macのmysqlをmysql5.5から8へバージョンアップする際に下記のエラーがでた。

Mysql2::Error (Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/Cellar/mysql@5.5/5.5.60/lib/plugin/caching_sha2_password.so, 2): image not found):

下記のリンクを参考にエラー解消

update mysql.user set plugin = "mysql_native_password";
FLUSH PRIVILEGES;

webpackとforemanを使っているとエラーは解消されない。
下記のエラー。

Mysql2::Error::ConnectionError: Access denied for user 'root'@'localhost' (using password: YES)

再度、元に戻す。

update mysql.user set plugin = "caching_sha2_password";
FLUSH PRIVILEGES;

もう一度、起動させてら何故か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?