More than 3 years have passed since last update.

Access denied for user 'root'@'localhost' (using password: NO) エラーの対処

Last updated at 2021-03-13Posted at 2021-03-13

対象

CentOS 7
Mysql Ver 8.0.23 for Linux on x86_64

確認方法

# OS確認
$ cat /etc/redhat-release
CentOS Linux release 7.9.2009 (Core)

# MySQL確認
$ mysql --version
mysql  Ver 8.0.23 for Linux on x86_64 (MySQL Community Server - GPL)

エラー内容

$ mysql -u root -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

'root'@'localhost'のパスを確認してみる

cat /var/log/mysqld.log | grep root
2021-03-13T10:37:21.641762Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: kjdgxz#G89

最後に表示された文字列がパスワードです。

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up