centos 7 / mysql 5 버전에서 mysql yum 설치 후 root 패스워드를 모르는 경우 확인 방법...
어렵게 찾았음.
=== 원문 ===
Centos 7 3.10.0-123.8.1.el7.x86_64
Hi i have installed MySQL 5.7.7 from MySQL Yum Repository
rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
After service mysqld start i use mysql_secure_installation then i get prompted for a password i just press enter and i get this error:
Error: Access denied for user 'root'@'localhost' (using password: NO)
I think i have tried everything to find the password or to reset it - but no go
here are my steps:
- rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
- nano /etc/yum.repos.d/mysql-community.repo
- Set MySQL 5.6 enabled=0 and set MySQL 5.7 enabled=1
- yum install mysql-community-server
- service mysqld start
mysql_secure_installation
Error: Access denied for user 'root'@'localhost' (using password: NO)
any help is appreciated.
답변
MySQL v 5.7 or higher generates a temporary random password after installation and stored that in mysql error log file, located at /var/log/mysqld.log
for an installation by the MySQL Yum repository on CentOS 7.
use below command to see the password:
shell > sudo grep 'temporary password' /var/log/mysqld.log