Locked out of phpmyadmin +REP

[iLogan]

Hey,

I'm running phpmyadmin on WAMP, and I've forgotten the password and locked my self out, how do I reset the password manually?

+REP

[Chippiewill]

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

[iLogan]

Done, but it's still not working

[Vinnie:Safety]

1) Go to admin user
2) stop the server (might need to use task manager)
3) create a text file:

UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;

change the password to what you want. write the update & flush statements.

4) save the file to local disk so this is the root: "C:\mysql-init.txt."

5) from start menu, go to run program type in "cmd" as the command to run.

6) Start the MySQL server with the special --init-file option

7)After the server has started delete C:\mysql-init.txt.

Should fix your problem, good luck.

[iLogan]

I did it and now it's saying:

#2054 - Connecting to 3.22, 3.23 & 4.0 servers is not supported

[iLogan]

Sorry for double posting but it won't let me edit.

Right, I've somehow got the databases to start working again (before they were producing errors) but I can't access phpmyadmin, so MySQL is back up, but phpmyadmin is still messing around it's giving me this error now: #1045 - Access denied for user 'root'@'localhost' (using password: YES)

[Chippiewill]

Sorry for double posting but it won't let me edit.

Right, I've somehow got the databases to start working again (before they were producing errors) but I can't access phpmyadmin, so MySQL is back up, but phpmyadmin is still messing around it's giving me this error now: #1045 - Access denied for user 'root'@'localhost' (using password: YES)
Are you using the right password when logging into phpmyadmin and have you updated the phpmyadmin config to agree with the new password (I can't remember if that's a config option or not)?

[iLogan]

Are you using the right password when logging into phpmyadmin and have you updated the phpmyadmin config to agree with the new password (I can't remember if that's a config option or not)?

Well the set up is weird, I've allowed external access (through dyndns) but you can't access phpmyadmin through an outside connection, only through localhost/phpmyadmin

and yes, I've updated the password in the config file