Category Archives: Technology

Things that have to do with computers and technical things in general.

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 [...]

Also posted in Software Development | Tagged MySql, Tutorial | Leave a comment

Helpful Unix and Mac commands

By Torleif | Published: December 27, 2008

I am for the most part a Windows user. I was kind of moving towards Linux, Ubuntu in particular, but that ship pretty much sailed when I got my hands on Windows 7. Awesome, awesome operating system. But, I still have to use some Unix and Mac systems once in a while. And then there [...]