Wednesday, July 18, 2012

Mysql Root Passwd Reset

root#mysqld_safe --skip-grant-tables&
Above command started mysqld daemon without grant tables, so no password will be asked if i need to go to mysql prompt
root#mysql
        mysql>use mysql
        mysql>update user set password=PASSWORD('abcd') where User='root'
        mysql>flush privileges
        mysql>quit

No comments:

Post a Comment