change root password for mysql 5.7 fresh installed

In order to find out actual password you need to grep log file

grep password /var/log/mysqld.log

This will provide you with root password .

After login on your mysql server with

mysql -u root -p

Then you must change root password with

ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘newpassword’;


Rate this post

Leave a Reply

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