Answers for "how to know password of mysql root in linux terminal"

how to enable mysql 5.7 root user password on linux

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'SOME_NEW_ROOT_PASSWORD';

Posted by: Guest on May-09-2020

how to know password of mysql root in linux terminal

mysql> use mysql;
mysql> update user set authentication_string=password('NEWPASSWORD') where user='root';
mysql> flush privileges;
mysql> quit

Posted by: Guest on October-16-2021

Code answers related to "how to know password of mysql root in linux terminal"