mysqllinuxpasswordspassword-recoverymysql-5.7

What is the default root pasword for MySQL 5.7

Cannot login to MySQL database after fresh install with root ID and empty/no password like other older MySQL versions do.

Solution

  • After you installed MySQL-community-server 5.7 from fresh on linux, you will need to find the temporary password from /var/log/mysqld.log to login as root.

    1. grep 'temporary password' /var/log/mysqld.log
    2. Run mysql_secure_installation to change new password

    ref: http://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html