database cannot connect

[scylla]

Keep getting an error when trying to connect.

Database error in vBulletin :

Cannot use database -----_vb

MySQL Error   : Access denied for user '-------_-------'@'lotus.x10hosting.com' to database 'scylla28_vb'
Error Number  : 1044
Request Date  : Monday, December 7th 2009 @ 07:00:17 PM
Error Date    : Monday, December 7th 2009 @ 07:00:17 PM
Script        : http://vgc.x10hosting.com/forum/
Referrer      :
IP Address    : --.---.----.---
Username      :
Classname     : vB_Database
MySQL Version :

Sometimes it even gives this error

mysql_pconnect() [<a href='function.mysql-pconnect'>function.mysql-pconnect</a>]: Access denied for user 'account_name'@'lotus.x10hosting.com' (using password: YES)
/home/scylla28/public_html/forum/includes/class_core.php on line 311

I've checked the config and all the passwords seem to be correct.

mysql_pconnect() [<a href='function.mysql-pconnect'>function.mysql-pconnect</a>]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111
/home/scylla28/public_html/forum/includes/class_core.php on line 311

Also recently I changed the server to localhost in the config.php file. Still giving errors.

 

[descalzo]

Try:

<?

DEFINE ('DB_HOST', 'localhost' );
DEFINE ('DB_USER', 'username_dbusername');
DEFINE ('DB_PASSWORD' , "yourpassword" );


$link = mysql_pconnect(  DB_HOST , DB_USER , DB_PASSWORD   );

if (!$link)
  { 
   echo "Bad connect" ;
  } else {
    echo "Success" ;
}

?>

Create a .php file and run it from the web to see if your password is correct.
Alternatively, go to mySQLDatabases on cPanel, drop the username and recreate the user with the password you are using. Don't forget to add the user back onto the database.

 

[scylla]

alright, I forgot one important step, I had the user and database made. I forgot to insert the user into the database lol. Now you can check it out at vgc.10hosting.com and when the domain propagates to the x10 nameservers you can check it out at it's vbulletin licensed address of http://vgchat.info (which still is using the old hostgator nameservers at the moment until they propagate...)