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:
mysql_secure_installationError: Access denied for user ‘root’@‘localhost’ (using password: NO)
any help is appreciated.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
I know this is old and you probably figured it out by now, but this is the first link that comes up when I searched for it and I want others to find solution.
A temporary, random root password is generated and stored in the error log, which is /var/log/mysqld.log for an installation by the MySQL Yum repository. You can use this command to see the password:
shell > sudo grep 'temporary password' /var/log/mysqld.log
(Source https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html)
For me the password generated after actually starting mysql server.
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.
New accounts only. By submitting your email you agree to our Privacy Policy
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.