MySQL 5.7.7 - Centos 7 el7 - Access denied
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
GOLD STAR FOR YOU! I've been fighting this all morning, only to find out that a default password had been set!
Thanks a bunch!
WOW. You know what? I found it necessary to create an account just to be able to comment to thank you for an awesome solution. Been wandering around and I finally found this. Thank you very much!
Yeah, thank you, sameershah29. You shared awesome resolution, I truly appreciate it.
Thank you very much for this. :)
@sameershah29 Thanks a lot for this solution. This is an old post but it helped me even today!