mysql server root password recovery

From thelinuxwiki

Revision as of 22:11, 24 May 2016 by Nighthawk (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to: navigation, search

Stop MySQL

# sudo /etc/init.d/mysqld stop

start mysql in Safe mode

# mysqld_safe --skip-grant-tables &

Login as root

# mysql -uroot

Reset Password

# use mysql;
mysql> update user set password=PASSWORD("mynewpassword") where User='root';
mysql> flush privileges;
mysql> quit

Restart

# killall mysqld
# /etc/init.d/mysqld start

Retrieved from "http://www.thelinuxwiki.com/index.php?title=mysql_server_root_password_recovery&oldid=999"

mysql