MySQL root password unset
Posted by: Thirumalesh Gorantala
Date: June 07, 2019 11:29PM

Hi,

I have installed MySQL 5.1.73 version on CentOS 7. And after that reset root password using below commands

service mysql stop;mysqld_safe --skip-grant-tables &
mysql>
UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
FLUSH PRIVILEGES;
exit;

mysqladmin -u root -p shutdown;service mysql start

But after every couple of hours this root pwd is getting unset and i can access DB using simple "mysql" command without using password

Does anyone faced this?

Thiru

Options: ReplyQuote


Subject
Written By
Posted
MySQL root password unset
June 07, 2019 11:29PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.