MySQL default Password
Recently, I was setting up MySQL Galera cluster on redhat 7.4. I installed MySQL 5.7 and Galera cluster on the system according to the instructions provided in galera support page ( Galera Cluster setup ). I have made a blog post for installation and setup here . But when I started the mysql, I was not able to login as I did not setup any password for mysql root account. When I tried logging in without password, I got access denied. After looking for the answers on internet, I found out that MySQL creates a temporary password and write it in log files. It is clrearly mentioned in mysql documentation here . All I needed to do to find this password is to run the following command. grep 'temporary password' /var/log/mysqld.log Problem solved !