Current time: 10-22-2020, 09:31 PM Hello There, Guest! (LoginRegister)


Post Reply 
Warning: mysql_pconnect() [function.mysql-pconnect]:
Author Message
Nomis Offline
Junior Member
*

Posts: 36
Joined: May 2007
Reputation: 0
Post: #1
Warning: mysql_pconnect() [function.mysql-pconnect]:
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
06-04-2009 03:02 PM
Find all posts by this user Quote this message in a reply
kilburn Offline
Development Team
*****
Dev Team

Posts: 2,182
Joined: Feb 2007
Reputation: 34
Post: #2
RE: Warning: mysql_pconnect() [function.mysql-pconnect]:
Can you connect using the terminal mysql client:
Code:
mysql --user=<username> --host=<host> -p <database>
(You will be prompted for your password)
06-05-2009 10:57 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Nomis Offline
Junior Member
*

Posts: 36
Joined: May 2007
Reputation: 0
Post: #3
RE: Warning: mysql_pconnect() [function.mysql-pconnect]:
(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)
06-10-2009 10:17 PM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #4
RE: Warning: mysql_pconnect() [function.mysql-pconnect]:
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
06-10-2009 10:35 PM
Visit this user's website Find all posts by this user Quote this message in a reply
welllyn07 Offline


Posts: 1
Joined: Oct 2009
Reputation: 0
Post: #5
RE: Warning: mysql_pconnect() [function.mysql-pconnect]:
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
(This post was last modified: 11-30-2009 03:16 AM by welllyn07.)
10-10-2009 03:27 PM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)