Update root password of mysql server

service mysqld stop
mysqld_safe --skip-grant-tables &
use mysql
UPDATE mysql.user SET password=PASSWORD('newpass') WHERE user='root';
FLUSH PRIVILEGES;
quit
/sbin/service mysqld start
mysql -uroot -p

No comments:

Post a Comment