pconnect error with Adobe Dreamweaver cs6

[bkjames]

I am creating a website in Adobe Dreamweaver CS6. I am trying to add a page with a membership form that inputs fields to a database.

I have set up a local test server(using xampp) that has worked. Ie the form accepts the data and passes it through to the database.

However, when I put the form and files to the Remote Server and try to access the membership entry form page (www.friendsofchopin.org.au/mem_form.php) I get the following error:

 

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

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

 

code is:

 

<?php

# FileName="Connection_php_mysql.htm"

# Type="MYSQL"

# HTTP="true"

$hostname_memconn = "localhost";

$database_memconn = "chopinau_membership";

$username_memconn = "chopinau_admin";

$password_memconn = "xxxxxxxxxxx";

$memconn = mysql_pconnect($hostname_memconn, $username_memconn, $password_memconn) or trigger_error(mysql_error(),E_USER_ERROR); 

 

?>

 

Any help would be greatly appreciated

[mac_gyver]

are you using the correct database credentials for your live server? did you create a database and the database username/password and assign them permissions to the database? your web host may have a FAQ section that provides specific information for doing this on his servers.

[requinix]

Separate from that, don't use persistent connections (ie, mysql_pconnect()) unless you know exactly what you're getting into. The "persistent" may seem cool and all but it has drawbacks that can kill your site if you aren't aware of them.

[jazzman1]

A lot of web php sites were down 6-7 years ago of a result using persistent connections. I'm agree with requinix.

[vinny42]

Also note thast 'localhost' and '127.0.0.1' point to the same thing, but MySQL's accessrights treat them differently.

 

Is the MySQL server running on the same server (very possible, but most hosting companies have dedicated database servers  for that)