Hi,
I'm new to web servers, php, MySQL, and all this stuff in general so please explain this to me like I'm 6 years old.
I was in the process of moving my Joomla install from localhost to a remote host and was about to make a copy of its database to put on the server, when I noticed that at the bottom of phpMyAdmin it suggested that the root user be given a password because it was a security hole. So went over to the permissions tab and proceed to add a password to the root user. However, now nothing can access the MySQL databases including phpMyAdmin, the only way I know of changing the password back. Is there and easy way to fix this? It seems like a simple problem, but being so new, I don't really know how it works and am unsure of how to proceed. Is this a serious enough problem that the database will be lost? How much would I lose?
Thanks!
-Nick