Difference between revisions of "Resetting MySQL root password"
From Notes_Wiki
m |
m |
||
| Line 1: | Line 1: | ||
<yambe:breadcrumb> | <yambe:breadcrumb self="Resetting MySQL root password">Mariadb configuration | Mariadb configuration</yambe:breadcrumb> | ||
=Resetting mysql root password= | =Resetting mysql root password= | ||
Revision as of 10:56, 17 August 2018
<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.
- Use command 'mysqld_safe --skip-grant-tables' to run mysql without any priviledge information
- Connect to mysql by simply typing 'mysql' without any options
- Use database mysql using 'use mysql'
- Change root password or disable it using "update user set password=password('secret') where user='root'" or "update user set password= where user='root'"
- Stop mysql using command "service mysqld stop"
- Start mysql again without any password or with the new password set.
