Difference between revisions of "Resetting MySQL root password"
From Notes_Wiki
(Created page with "=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...") |
(No difference)
|
Revision as of 04:08, 7 November 2012
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.