Answers for "how to know the password of mysql command line"

mysql see users and passwords

SELECT User, Host, Password, password_expired FROM mysql.user;

Posted by: Guest on February-04-2021

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 the password of mysql command line"