Paul, let me try to state the problem i had.
i developed a database in mysql, and handed it to the client. The client sent me a request for changes, and left town (i could not reach him by email) i had previously created a user with admin privileges, lets say username: admin password admin: email address: (clients email address) i tried to login, and either the password had been changed or i had forgotten it. The easiest way to recover it, was to use forgot my email address. but this would send it to the clients email address not mine. I did not want to wait for the client, to return to base. 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. the simple solution would be to change the email address, since most DBAs dont encrypt this field. However if the field is encrypted, then the other option is to select the table users, type any password and change function to md5. this is a noble attempt to explain the dilema which kept me behind schedule for two weeks. regards Cavin Message: 2 Date: Fri, 20 Nov 2009 16:16:55 +0300 From: Paul Bagyenda <[email protected]> Subject: Re: [LUG] re: mysql hack To: Linux Users Group Uganda <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain; charset="iso-8859-1" Lets try again: Please explain clearly what the MySQL problem was and how you solved it. Got a little confusing half-way through your original email.
_______________________________________________ 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. ---------------------------------------
