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
```