How do i recover the password and username for phpmyadmin if I forgot it. Thanks.

If you have CLI access to the mysql server, you could restart mysql with -Sg (skip grant tables). When you've done that, do FLUSH PRIVILEGES; straight away, to avoid anyone else being able to connect, then use the usual grant syntax to sort out a new password/and or username.

If you don't have CLI access to the server, your isp should be able to help out.



--
Don't Stand on your head - you'll get footprints in your hair. http://charlieharvey.com

What exact commands in dos do i need to type. I do have command line access to mysql server.

I changed the password to mysql by typing in another command but it didnt affect phpmyadmin.

What exact steps do i need to type in dos to recover the password for PHPMYADMIN.

Thanks alot for your previous response

> 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
USE mysql;
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