msql pc_connect error

pjpeters

I get this error on my website.

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'pfgdb'@'localhost' (using password: YES) in /home/pfgins/public_html/admin/lib/DB.php on line 23
Could not establish connection

this is the database I am not sure where it is any help would be great.

<?php

/************************************
class to control MySQL functions
written by Tony Burnham, 06/18/2001
************************************/

Class DB {

var $login;
var $host;
var $password;

/* initializes connection vars */
function init($host,$login,$password) {
	$this->host=$host;
	$this->login=$login;
	$this->password=$password;
}

/* establishes MySQL persistent connection */
function get_con() {
	$conn=mysql_pconnect($this->host,$this->login,$this->password)
		or die('Could not establish connection');
	return $conn;
}

}
?>

Thanks,
Patrick

NogDog

To help debug for now, you might want to add a call to [man]mysql_error/man within your die() statement, in order to see if MySQL had anything interesting to say about the connection attempt.

Also - though not necessarily related to your problem - unless you have a specific reason for using mysql_pconnect(), I would recommend using mysql_connect(), instead, as it is less likely to cause problems if your code should be causing unused connections to persist and possibly take up all of your available connections.

pjpeters

I am migrating a website to a different host. I am not to versed in databases. How do I ad the msql_error I tried mysql_error($link) . "\n"; at the end of my statement and it did nothing.

pjpeters

Here is the error I am getting,

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<?php

Class DB {

var $login' at line 1

NogDog

Try this:

$conn = mysql_connect($this->host, $this->login, $this->password) or 
    die('Could not establish connection: ' . mysql_error());

pjpeters

here is the error on my webpage now.