Secure MySQL 5.7 installation

With the release of MySQL 5.7, I was pleasantly surprised to see the install generated a random, secure password. This prevented me from going through the normal step of running mysql_secure_installation after starting and enabling services. To find the generated password, issue one of the commands below:

On RHEL/CentOS/Fedora

grep 'temporary password' /var/log/mysqld.log

On SLES

grep 'temporary password' /var/log/mysql/mysqld.log

After issuing one of these commands, I was able to resume running the mysql_secure_installation.

Add to the conversation:

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.