> I changed the password to mysql by typing in another command but it didnt affect phpmyadmin.
Can you log in using a password to mysql from the commandline, for eg.
mysql -u phpmyadminuser -p <PASSWORD>
If you can, it probably means that there's something wrong with the phpmyadmin setup. You should check through your config.inc.php file
around line 70-80 reads something like:
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'phpmyadminuser'; // MySQL user
$cfg['Servers'][$i]['password'] = 'the_password';
> What exact steps do i need to type in dos to recover the password for PHPMYADMIN.
The old password should be set in the file above, so it's really just a case of :
+ locate config.inc.php
+ edit it using edit or notepad or jedit or whatever.
+ the old password should be set up as above.
If it isn't there, then you should first set a new password for the appropriate user in mysql like:
C:> mysql -u mysqladmin -p
UPDATE user SET password=PASSWORD('yournewpass') WHERE user='phpmyadminuser' ;
FLUSH privileges ;
Then alter the above lines of config.inc.php so that username and password reflect the new password.
If you really need to recover the password, rather than set a new one, and its not in config.inc.php, you'll have to copy the encrypted one out of the appropriate row in the user table, and run a password cracker like john the ripper on it. I'll leave this for another post :-)
Don't Stand on your head - you'll get footprints in your hair. http://charlieharvey.com