Posted by:
ZenProfit
(---.cmdnnj.fios.verizon.net)
My problem is slightly different.
After 4 years my WAMP 1.5 install became corrupted. So I did an upgrade to WAMP 2.0.
All appeared to have gone well, I could access PHPMyadmin,and see my databases.
However, my website was throwing errors at every link back to the MySQL database:
access denied to "username@ABC123", where ABC123 is the actual name of the server box at my ISP. Before the upgrade, the access was via:
username@123.456.78.90 where 123.456.78.90 was the actual DNS of the server (I am the sole user of this server, it is not shared.)
When I went into the MySQL | Users table thru phpMyadmin I manually changed the LocalHost to 123.456.78.90.
Now I cannot access phpMyAdmin at all and the website still cannot access the MySQL database.
What is the process thru the MySQL Console to change the 123.456.78.90 back to ABC123 so I can get back into phpMyAdmin. And then how do I correctly change the username@ setting so my website links will get through to the MySQL database?
Thanks.