mysql_pconnect()

[wezner]

Hi everyone,
I was wondering if anyone here could help me with a php problem I have.
When I run a php script locally that communicates with a mysql db, everything works great, but when I run the php on the web server with the same exact table I get this error Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user: 'xxx.xxxxxx.xx@55.55.555.555' (Using password: YES)
I'm 100% the php is fine and im using the right host, login, password... does anyone know what else it could be?

(Thanks for the help)

[samudasu]

It could be that mysql.allow_persistent is set to 0, disallowing you to us mysql_pconnect. Try using mysql_connect. Do you get the same message?

[searain]

web server: webserver.yourcomany.com
database server: mysqlserver.yourcompany.com
mysql user: mysql_uer.

Check out the mysql_user, you may not give mysql_uer@* access permission to the database. maybe only [e-mail] has the access to the database, but [e-mail] doesn't have the acccess to the database. you can grant the access to [e-mail] and then try again.

by the way. use mysql_connect() instead of mysql_pconnect() in most cases.

[wezner]

I figured it out... it was something stupid (again) ../ instead of / in my include paths. Sorry for the waste of time, but I appreciate the help a lot! Thank you!