+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Development Area (/forum-1.html)
+--- Forum: General discussion (/forum-11.html)
+--- Thread: Warning: mysql_pconnect() [function.mysql-pconnect]: (/thread-6876.html)
Warning: mysql_pconnect() [function.mysql-pconnect]: - Nomis - 06-04-2009 03:02 PM
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
RE: Warning: mysql_pconnect() [function.mysql-pconnect]: - kilburn - 06-05-2009 10:57 PM
Can you connect using the terminal mysql client:
Code:
mysql --user=<username> --host=<host> -p <database>RE: Warning: mysql_pconnect() [function.mysql-pconnect]: - Nomis - 06-10-2009 10:17 PM
(06-05-2009 10:57 PM)kilburn Wrote: Can you connect using the terminal mysql client:
(You will be prompted for your password)Code:
mysql --user=<username> --host=<host> -p <database>
No i cant i get the following error:
ERROR 1045 (28000): Access denied for user 'root'@"all.co.za' (using password: YES)
RE: Warning: mysql_pconnect() [function.mysql-pconnect]: - joximu - 06-10-2009 10:35 PM
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
RE: Warning: mysql_pconnect() [function.mysql-pconnect]: - welllyn07 - 10-10-2009 03:27 PM
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