Re: mysql reinstall??

Addressed to: r.j.michell@anglia.ac.uk php-db@lists.php.net ** Reply to note from Russell John Michell <r.j.michell@anglia.ac.uk> Wed, 22 Nov 2000 09:41:08 +0000 (GMT Standard Time) > > > Hi all: > > I've trawled mysql.com and php.net etc, but havn't found what I'm after: > > > I had my mysql server run automatically in the background when I > connected to my http server remotely (simply typing mysql -p (password)) > at the shell prompt. But I messed up trying to change the password and > consequently I don't know what I changed it to! (must've been typing too > fast and made a typo) > > I would like to know firstly is there any way of recovering myself and > mysql after such a boo boo, or if I need to reinstall mysql, will it > affect my current installation of php4 (which was installed using > --with-mysql=/xxxx) even if I re-install an identical mysql? Try this: hit http://www.mysql.com enter "Lost Root Password" on the search box. Hit enter Pick one of the pages returned. Look for: How to reset a forgotten password. Follow the instructions you find there. You will have to be root, or the user MySQL runs as to do this... Rick Widmer Internet Marketing Specialists www.developersdesk.com