frustrated
|
| Posted: 10/10/2005, 9:04 AM |
|
LOVE Code Charge! this is my first attempt at a PHP/MYSQL project and I have it working like a CHAMP locally (well, I am acessing a DB that is on my internet server - not local). When I launch the puppy to my web server I am getting a:
Warning: mysql_pconnect(): Access denied for user: 'user@website.com' (Using password: YES) in /usr/local/www/vhosts/website.com/htdocs/test/db_mysql.php on line 99
Database error: pconnect(IP, user, $DBPassword) failed.
MySQL Error: 0 ()
Session halted.
It was working last week just fine. I had a co-woker inputting data left and right. It was wonderful! THEN, I created a new user for mysql, in effort to limit access (I was just using root). NOW I have no luck with ANY user (not even root). It must be something simple. I have restarted mysql, deleted users, made new users and flushed privileges a million times, with NO avail. every thing still works great locally. BUT, once I upload, it's all downhill.
Any help would be so great!
|
|
|
 |
Walter Kempees
|
| Posted: 10/10/2005, 1:29 PM |
|
From your text and without any guarantee I deduct the following:
You webservers MySQL DB is configures in such a way that it can be connected
to from a location other than the MySQL server itself (localhost).
That I gather from the fact that it did work earlier.
Now remember not all hosting comapnies allow remote access to the DB.
From the rest of your text I would suggest that remote acces is indeed
allowed but ONLY for user ROOT.
You have yourself created the user USER, it might not have (indeed I think
it doesn't) have remote access rights.
Path to follow is change back to user ROOT and make the application safe OR
change the access right for user USER.
your error message indicates an IP problem.
Good hunting.
Walter
"frustrated" <frustrated@forum.codecharge> schreef in bericht
news:5434a910c6109a@news.codecharge.com...
> LOVE Code Charge! this is my first attempt at a PHP/MYSQL project and I
> have it
> working like a CHAMP locally (well, I am acessing a DB that is on my
> internet
> server - not local). When I launch the puppy to my web server I am getting
> a:
>
> Warning: mysql_pconnect(): Access denied for user: 'user@website.com'
> (Using
> password: YES) in
> /usr/local/www/vhosts/website.com/htdocs/test/db_mysql.php on
> line 99
> Database error: pconnect(IP, user, $DBPassword) failed.
> MySQL Error: 0 ()
> Session halted.
>
> It was working last week just fine. I had a co-woker inputting data left
> and
> right. It was wonderful! THEN, I created a new user for mysql, in effort
> to
> limit access (I was just using root). NOW I have no luck with ANY user
> (not
> even root). It must be something simple. I have restarted mysql, deleted
> users,
> made new users and flushed privileges a million times, with NO avail.
> every
> thing still works great locally. BUT, once I upload, it's all downhill.
>
> Any help would be so great!
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
gerrit
Posts: 131
|
| Posted: 10/11/2005, 12:42 PM |
|
My suggestion is to change this parameter:
$this->Persistent = true;
to
$this->Persistent = false;
You can do this way:
1. Right Click at your Database connection and select Edit
2. Select server
3. Uncheck Persistent Connection
After doing this everything will be ok
Quote frustrated:
LOVE Code Charge! this is my first attempt at a PHP/MYSQL project and I have it working like a CHAMP locally (well, I am acessing a DB that is on my internet server - not local). When I launch the puppy to my web server I am getting a:
Warning: mysql_pconnect(): Access denied for user: 'user@website.com' (Using password: YES) in /usr/local/www/vhosts/website.com/htdocs/test/db_mysql.php on line 99
Database error: pconnect(IP, user, $DBPassword) failed.
MySQL Error: 0 ()
Session halted.
It was working last week just fine. I had a co-woker inputting data left and right. It was wonderful! THEN, I created a new user for mysql, in effort to limit access (I was just using root). NOW I have no luck with ANY user (not even root). It must be something simple. I have restarted mysql, deleted users, made new users and flushed privileges a million times, with NO avail. every thing still works great locally. BUT, once I upload, it's all downhill.
Any help would be so great!
_________________
| http://www.vision.to | |
 |
|
frustrated
|
| Posted: 10/11/2005, 1:59 PM |
|
Thanks for all your input! In playing with every type of permissions configuration, I found that if I gave the user permissions using only the specific IP as the host it worked. Since this is the first time I got it up and running for days, I decided not to mess with it again for a bit. I will try unchecking the persistant connection box once all my little tweeks are complete. Thanks again. Cheers!
|
|
|
|
|
