On 11/21/09 3:19 AM, Mugarura Cavin wrote:-
> I however had admin privileges via remote access, for all databases on
> the server (root). Mysql encryption does not allow me to change the
> password field (well u can change it, but it has no effect), so i had
> access to the specific database and the table users which had the
> encrypted password.
sorry but I am not clear why this would have "no effect" (assuming the
password is stored in an MD-5 hash) if you had root privileges to the
db. Let's say the table is called "users".
UPDATE users SET password=MD5('new password') WHERE user = "Super
Administrator";
--
Hari
_______________________________________________
LUG mailing list
[email protected]
http://kym.net/mailman/listinfo/lug
%LUG is generously hosted by INFOCOM http://www.infocom.co.ug/
The above comments and data are owned by whoever posted them (including
attachments if any). The List's Host is not responsible for them in any way.
---------------------------------------
