A2 Hosting Forums

Full Version: Database username(s)? which parameters to use for mysql_pconnect?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Looking at MySQL Databases on cpanel

some usernames have :

First8CharsOfA2UserName_DatabaseUsernameEntered ,
others do not.

with this line:

$dbh = mysql_pconnect ("localhost", $designer_name, $designer_word);

should designer_name have the first8charsofusername
in front, or not?

I'm getting error where $designer_name = First8CharsOfA2UserName_DatabaseUsernameEntered

Does this make any sense?

Cletus Wrote:
Looking at MySQL Databases on cpanel

some usernames have :

First8CharsOfA2UserName_DatabaseUsernameEntered ,
others do not.

with this line:

$dbh = mysql_pconnect ("localhost", $designer_name, $designer_word);

should designer_name have the first8charsofusername
in front, or not?

I'm getting error where $designer_name = First8CharsOfA2UserName_DatabaseUsernameEntered

Does this make any sense?


All of your A2 DB users and databases are likely prefixed with "username_"...at least mine are.  So something like this should work:

$dbh = mysql_pconnect ("localhost", 'a2acct_dbuser', 'a2acct_dbname');

Do both the DB user and DB exist?  Also, check the permissions of the DB user.

PolarLava Wrote:
...
All of your A2 DB users and databases are likely prefixed with "username_"...at least mine are.  So something like this should work:

$dbh = mysql_pconnect ("localhost", 'a2acct_dbuser', 'a2acct_dbname');

Do both the DB user and DB exist?  Also, check the permissions of the DB user.


i thought the third parameter was the password for dbuser:
http://www.php.net/mysql_pconnect ?

the database name determined in subsequent:

mysql_select_db($database_name);

Thanks again for the replies,
I had the password wrong in this case, so i'm onto the next error.

Reference URL's