Tag Archives: MySql

How to delete WordPress post revisions

By Torleif | Published: October 20, 2009

Having revisions on my posts is nice I suppose. But I was starting to get a bit annoyed with the increasingly long list of revisions in each post. And they really did get long. Mainly because I am in a bit of a testing and experimenting phase which means that I have done a lost [...]

Posted in Software Development | Also tagged Sql, WordPress | Leave a comment

How to reset the MySql root account

By Torleif | Published: December 27, 2008

I just managed to mess up the MySQL root account. Not a smart idea. After some MySQL manual reading and some serious Google-Fu, I figured out how to fix it. Stop the mysql server Add the following to the my.cnf file [mysqld] skip-grant-tables Start the mysql server Start a mysql client and run the following query REPLACE INTO mysql.user VALUES ('localhost','root',PASSWORD('blah'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0); Quit the [...]