02.20.06

Change MySQL root password

Posted in howto, security, software at 11:51 pm by brainstorm

So you forgot your MySQL database password ? Don’t worry, I’ll go straight to the point:

• Stop your running mysqld instances (/etc/init.d/mysql-server stop or killall mysqld)
• # mysqld –skip-grant-tables
• # mysql -uroot and you’re in, easy, isn’t it ?

For god sake, don’t do this on a production server leaving mysqld running like this X”D

Permalink