I used phpMyAdmin to build a sample MySQL database and was able to access it on my local computer (localhost) but I can’t get it on the server hosting our website. All I did to move it from localhost to our site was change the hostname from localhost to www. vcsi.org in the php script and the sql database file and then upload both files to the server via ftp. I get the following error message when trying to access the page that pulls info from the database.
Failed to connect to MySQL Server. Error: Access denied for user 'root'@'(ip address was here)' (using password: YES)
I should say that I am not in charge of the server hosting our site, but was told php w/ safe mode is enabled and that the only databases that wouldn't work on the server are Asp.net and Vb.net. I have looked hard to find an answer but no luck so far so either I am just a complete moron or this is super complicated. I hope its the first one. Any help is appreciated, thanks!