0
0

AWS EC2 でMySQLにログインできない

Posted at

EC2で

sudo apt install mysql-server mysql-client

をインストールしてもrootでログインできない。

ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
ERROR 1698 (28000): Access denied for user 'root'@'localhost'

場合の対処法。

SQL
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'password

ubuntuのログインユーザとrootの名前が違うことが原因ぽい

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