From IT Mission Linux Tips, Hacks, Tutorials, Howtos - Itmission.org

Main: HowToResetTheRootPassword

How to Reset the Root Password

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix

https://help.ubuntu.com/community/MysqlPasswordReset

How Can I Change MYSQL Username And Password ( Root) .NOW Username Is "Administrator" And Pass=Null

you can, as root or with proper access, run the query

"UPDATE {dbName}.users SET password=PASSWORD({pw}) WHERE user='administrator';"

replace {dbName} with the proper db, it is usually mysql, but it may be different, and replace {pw} with the password you choose.

you can, as root or with proper access, run the query

"UPDATE {dbName}.users SET password=PASSWORD({pw}) WHERE user='administrator';"

replace {dbName} with the proper db, it is usually mysql, but it may be different, and replace {pw} with the password you choose.

use mysql;

set password = password("idiot") where user = administrator;

Retrieved from http://www.itmission.org/Main/HowToResetTheRootPassword
Page last modified on June 10, 2008, at 01:02 PM