BioBob Posted May 6, 2009 Share Posted May 6, 2009 In a nutshell, there are two different databases. Each DB has a different user for security. I dont want both accounts being able to write to both databases otherwise using two different logins is pointless. After I get my data from the first connection (its a PConnect, I know that means Persistent, its SELECT privies only and its going to be used very frequently), I try to connect to the other DB with different user credentials, also using PConnect. But the error it keeps kicking back is that it is trying to log in with the FIRST users credentials. I am specifying the login info for the 2nd User but it keeps trying to connect only using the 1st. Not the behavior I want. What causes this? Link to comment https://forums.phpfreaks.com/topic/157036-php-mysql-pconnect-with-two-different-mysql-users/ Share on other sites More sharing options...
BioBob Posted May 6, 2009 Author Share Posted May 6, 2009 Nevermind, got it. Stoopid typo. Never would have guessed that from the error msg. Missing a character in the 2nd password so it was trying to connect using the 1st established connection. Link to comment https://forums.phpfreaks.com/topic/157036-php-mysql-pconnect-with-two-different-mysql-users/#findComment-827236 Share on other sites More sharing options...
Mchl Posted May 6, 2009 Share Posted May 6, 2009 Are you sure you need mysql_pconnect? Take a look at the comments in the manual. Link to comment https://forums.phpfreaks.com/topic/157036-php-mysql-pconnect-with-two-different-mysql-users/#findComment-827301 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.