Warning: mysql_pconnect() [function.mysql-pconnect]:

[Nomis]

Hi

I keep getting this error when I try and connect to a database i have created.

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'all'@'whereever.co.za' (using password: YES) in /var/www/virtual/all.co.za/htdocs/Connections/allseasons.php on line 9

Fatal error: Access denied for user 'all'@'whereever.co.za' (using password: YES) in /var/www/virtual/all.co.za/htdocs/Connections/all.php on line 9


Here is my connection file.

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_localhost = "192.168.1.45";
$database_localhost = "all";
$username_localhost = "all";
$password_localhost = "scca_key";
$allseasons = mysql_pconnect($hostname_localhost, $username_localhost, $password_localhost) or trigger_error(mysql_error(),E_USER_ERROR);
?>

I am running MySQL version 5.0.32, PostgreSQL version 8.1.15, Apache version 2.2.3, PHP 5, PHPMyAdmin 2.10.1,Perl version 5.8.8, Debian Linux 4.0, ispCP 1.0rc2 OMEGA ,build: 2007-04-18

[kilburn]

Can you connect using the terminal mysql client:

Code:

mysql --user=<username> --host=<host> -p <database>

(You will be prompted for your password)

[Nomis]

(06-05-2009 10:57 PM)kilburn Wrote:  Can you connect using the terminal mysql client:

Code:

mysql --user=<username> --host=<host> -p <database>

(You will be prompted for your password)

No i cant i get the following error:

ERROR 1045 (28000): Access denied for user 'root'@"all.co.za' (using password: YES)

[joximu]

do you need to use an external IP Address (e.g. whereever.co.za, 192.168.1.45) for connecting - try localhost or 127.0.0.1.

Otherwise maybe you need to enable the db users to connect from other than localhost...

/J

[welllyn07]

I don't see anything wrong about the codes. Maybe the only reason why you are encountering errors is because of some wrong script. I suggest you double check your codes and I am confident you can do it successfully!


___________________________________
Multivariate Testing