Speaktech.in

mysql 8 new installation get root password

Mysql 9 new installation get root password


Start the mysql with following command

#service mysqld start


Fetch the password from log files
#grep -oP 'temporary password(.*): \K(\S+)' /var/log/mysqld.log


Try login with new password , with below command password prompt will come for login
#mysql -u root -p