<yambe:breadcrumb self="Resetting MySQL root password">Mariadb configuration | Mariadb configuration</yambe:breadcrumb>

Resetting mysql root password

In case we have root privileges on server and want to reset mysql root password then we can use following steps:

Stop mysql service if it is running.
```
service mysqld stop
```
Use below command to run mysql without any priviledge information
```
mysqld_safe --skip-grant-tables &
```
Connect to mysql by without any options or authentication
```
mysql
```
Use database mysql using:
```
use mysql
```

Change root password using:

update user set password=password('secret') where user='root'

or disable it using:

update user set password='' where user='root'

Stop mysql using command:
```
service mysqld stop
```
This did not work in stopping mysql. Had to kill mysqld_safe and later mysql process to stop mysql.
Start mysql again without any password or with the new password set.

Refer:

<yambe:breadcrumb self="Resetting MySQL root password">Mariadb configuration | Mariadb configuration</yambe:breadcrumb>

Anonymous