Thursday, 12 December 2013

Update or reset root login details 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