Recent Changes - Search:

Softwares

.

HowToResetTheRootPassword

Main.HowToResetTheRootPassword History

Hide minor edits - Show changes to output

June 10, 2008, at 01:02 PM by 15.211.153.70 -
Changed lines 7-26 from:
https://help.ubuntu.com/community/MysqlPasswordReset
to:
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;
June 10, 2008, at 12:22 PM by 15.211.153.70 -
Changed lines 3-7 from:
*%newwin%[[http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html|Root Password]]
to:
*%newwin%[[http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html|Root Password]]

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

https://help.ubuntu.com/community/MysqlPasswordReset
April 14, 2007, at 03:40 PM by 61.17.224.18 -
Added lines 1-3:
%red%How to Reset the Root Password

*%newwin%[[http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html|Root Password]]
Edit - History - Print - Recent Changes - Search
Page last modified on June 10, 2008, at 01:02 PM