Having trouble installing and connecting to database

[Fratal]

I've created my database, added a database user (and connected the user to the database), and edited around my config.php, but it doesn't seem to connect to the database.

What am I doing wrong?

And yes, I've made sure I edited all these spots:

$config['Database']['dbname']
$config['Database']['technicalemail']
$config['MasterServer']['servername']
$config['MasterServer']['username']
$config['MasterServer']['password']

[borbole]

I've created my database, added a database user (and connected the user to the database), and edited around my config.php, but it doesn't seem to connect to the database.

What am I doing wrong?

And yes, I've made sure I edited all these spots:

$config['Database']['dbname']
$config['Database']['technicalemail']
$config['MasterServer']['servername']
$config['MasterServer']['username']
$config['MasterServer']['password']

What errors are you getting? Obviously you are not entering the right info somewhere in there otherwise you wouldn''t have had a connection problem.

[Fratal]

Well, I've tried inputting my info multiple different ways.

For the db name, I'd put: name_myDBname
For the tech email, I'd put my own email.
For the servername, I'd put localhost (it's there automatically).
For the username, I'd put: name_myDBuser
For the password, I'd put the database password.

And some errors:

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'boardfps_rdfuser'@'localhost' (using password: YES)
/home/boardfps/public_html/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Monday, April 26th 2010 @ 04:05:08 PM
Error Date : Monday, April 26th 2010 @ 04:05:08 PM
Script : ********
Referrer :
IP Address : ********
Username :
Classname : vB_Database
MySQL Version :

Database error in vBulletin :

Invalid SQL:

SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','la nguagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','user stats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue');

MySQL Error : Table 'boardfps_rdfdb.datastore' doesn't exist
Error Number : 1146
Request Date : Monday, April 26th 2010 @ 03:58:49 PM
Error Date : Monday, April 26th 2010 @ 03:58:49 PM
Script : **********
Referrer :
IP Address : *******
Username :
Classname : vB_Database
MySQL Version :

[borbole]

The first error points to a permission problem. Did you gave the db user full permissions/access to the db where he is assigned to? Also, go to phpmyadmin and check if the servername is really localhost. Some hosts use their name.

The second error points to a db table that it doesn''t exists (datastore).

Ask your host to double check your info as well.

[Fratal]

What does this one mean?

Database error in vBulletin :

Invalid SQL:

SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','la nguagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','user stats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue');

MySQL Error : Table 'boardfps_rdfdb.datastore' doesn't exist
Error Number : 1146
Request Date : Monday, April 26th 2010 @ 04:18:41 PM
Error Date : Monday, April 26th 2010 @ 04:18:41 PM
Script : *********
Referrer :
IP Address : ********
Username :
Classname : vB_Database
MySQL Version :

[borbole]

As I said above, the second error points to a db table that it doesn''t exists (datastore). Which is strange because if you are having trouble to connect to the db when running the installer, you shouldn''t have any tables in the db.

[Fratal]

Yes, it certainly is weird. I really don't know what I'm doing wrong. All my info is correct?

[borbole]

Yes, it certainly is weird. I really don't know what I'm doing wrong. All my info is correct?

When you created the db, did you gave the db user full permissions/access to the db where he is assigned to? Also, go to phpmyadmin and check if the servername is really localhost. Some hosts use their name.

Ask your host to double check your info as well. because some settings somewhere is not correct.

Who is your host btw?

[Fratal]

Yes, when I connected the db user to the db, I made sure I checked the "All Priviledges" box. As for the server name, I did go into phpMyAdmin, and it clearly shows that Server: localhost.

[Fratal]

Got it fixed. I just went through with the install/install.php and it worked.

[borbole]

Glad to hear that.