Adobe Dreamweaver CS5 Classroom in A Book

[Aravsion]

Hi! I'm having trouble with the last lesson (17) when uploading to the web server. My issue is that when I uploaded the .php files (dynamic pages) they do not work on the web host at all. In other words, how to do I configure the php pages with the databases?

When I try to open the .php files I get an error message:

Warning:  mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'root'@'localhost' (using password: YES) in /home/a3414097/public_html/Connections/LocalPHP.php on line 9

Fatal error:  Access denied for user 'root'@'localhost' (using password: YES) in /home/a3414097/public_html/Connections/LocalPHP.php on line 9

Can I even have the LocalPHP.php file since I'm uploading to a host on the internet?

[Ben M]

There is a very good chance that you will not be able to use the root for your account unless you are paying for a dedicated server.  Have you set up a database and user account on your remote web server?  If not, you will first need to discuss this with your host about how to set it up on their system.  Then it's a matter of changing the php Connections document that connects to the mySQL so that it will work on your remote page.

[aarma]

SnakEyez02,

Well, I tried setting a database on 00webhost but I don't know how to tie everything together? In other words, I have a connections folder with LocalPHP.php but thats a localhost (virtual) PHP database file... how do i convert/change it to remote server on 00webhost? I have to contact the actual 00webhost representatives and ask them for help? Is there a way to resolve the issue with PHP by myself? Could you help me configure the database on the remote (00webhost) server and write a procedure on how to alter my LocalPHP.php file or additional code to be appropriate for remote server trasfers?

Thanks in advance!