====== MySQL - reset root password ====== - root@server# service mysql stop - root@server# mysqld_safe --skip-grant-tables & - root@server# mysql -u root - mysql> use mysql; - mysql> update user set password=PASSWORD("mynewsecretpassword") where User='root'; - mysql> flush privileges; - root@server# service mysql stop - root@server# service mysql start - root@server# mysql -u root -p