I created a beautiful site(as much as a developer’s first database-driven site can be), and I purchased hosting through Bluehost, I moved all my files over to BlueHost, and then when I go to my site (www.mcquistonator.com/coffeejoint), it gives me:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘root’@‘localhost’ (using password: YES) in /home7/mcquist1/public_html/coffeejoint/includes/connection.php on line 3
Database connection failed: Access denied for user ‘root’@‘localhost’ (using password: YES)
I’m guessing that this is something that can be fixed quite easily. But I think it also points to a concept I’m still in the dark on. I figured out how to install WAMP, and set up my database through PHP MyAdmin, and then write the PHP code to talk to the DB when it was all being stored and accessed from my pc. But now that I’m going “live” on the web, when I transfer all my files, how does the data in the database get there? I don’t have any files with that data, or I guess they are not in with all the HTML, PHP, and CSS files.
I looked back thru my sitepoint book “building a database driven website” and I’m not finding any obvious section that tells me how to set up the “online” database.
What big, obvious thing am I missing?