hi, something very wrong happened while i was following the book “build your own database driven websites using php and mysql”. i was up to chapter 4, CONNECTING TO MYSQL WITH PHP
i used phpMYAdmin to create a user name and password that was more personal. i was successful in the operation, but i still had 2 “users”: root and my ip address with no passwords. phpMyAdmin advised (printed at the bottom of the page) to create password. so, i figured that the new settings were enough, and the other 2 were redundant, so, i deleted them in phpMyAdmin. that was my mistake.
i can still access index.php by clicking “localhost” through the wamp menu, but i get the following if click on the phpMyAdmin icon under “tools”
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
i cannot re-enter the 2 users i deleted if i cannot open phpMyAdmin.
can i update a config file somewhere to reflect my new user name and password? or do i have to reinstall wamp completely?
ps: if i use the MySQL console, the first prompt reads “password:”. i typed the password that i assigned in phpMyAdmin earlier, and the system beeps at me, and closes. a very brief error message flashes. it is too fast to read, but i am sure that it says that i cannot access the server, reflecting the same problem that is explained above in red.
pps: i did a system restore, but it didn’t revert the delete operation. i need to get ‘root’ back, and maybe the ip address back in the list of users. dumb, i know. very mad at myself.
thanks in advance,