MySQL: Difference between revisions
From Leo's Notes
This page was last edited on 1 June 2013, at 15:53.
Created page with " == Reset Mysql Root Password == see http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html Basically, to reset the root password, restart mysql with the <code>-..." |
No edit summary |
||
| Line 13: | Line 13: | ||
> quit | > quit | ||
service mysql restart | service mysql restart | ||
== Binary Logs == | |||
see http://leo.steamr.com/2011/10/mysql-binary-logs/ | |||
[[Category:Linux]] | [[Category:Linux]] | ||
[[Category:Todo]] | [[Category:Todo]] | ||
Revision as of 15:53, 1 June 2013
Reset Mysql Root Password
see http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
Basically, to reset the root password, restart mysql with the --skip-grant-tables option to start mysql without user accounts, then update the root password.
service mysql stop
mysqld_safe --skip-grant-tables
mysql
> update mysql.user set password=PASSWORD('newpassword') WHERE user='root';
> quit
service mysql restart