• View
• Edit
• History
• Print

HowToResetTheRootPassword

How to Reset the Root Password

• 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;