snippets:mysql:reset_root

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

snippets/mysql/reset_root.txt · Zuletzt geändert: 2013/12/20 18:25 von 127.0.0.1