Asking for help with my MySQL settings.

[jasoncorn]

Hello. I'm trying to install the Vb lite, I've got everything uploaded and my PHP works fine. But I get this error when trying to connect to my database:

Warning: MySQL Connection Failed: Unknown MySQL Server Host (http) (0) in db_mysql.php3 on line 31

Warning: 0 is not a MySQL link index in db_mysql.php3 on line 37
-------
For my config I'm not sure what to put in my hostname, I've tried both my IP and server url in this format: http://mysite.com. But for the actual MySQL database, I'm not sure what to do. Do I use a MySQL user as the $dbusername or do I put my db name? and for the dbname what do I use there?

Thanks for your time.

[MilkMan]

try localhost instead of your domain or ip addy

[JimF]

Originally posted by jasoncorn
For my config I'm not sure what to put in my hostname, I've tried both my IP and server url in this format: http://mysite.com.

First, make sure that your hosting company has given you MySQL access privelages. When your hosting enabled those privelages, they told you (or should have told you) what your MySQL hostname was. If they didn't, you'll need that for anything you want to do in MySQL.

Originally posted by jasoncorn
But for the actual MySQL database, I'm not sure what to do. Do I use a MySQL user as the $dbusername or do I put my db name?

If you are on a shared server, chances are your host has allocated a certain amount of databases for you to use. Chances are they have already pre-specified the names of those databases - you just have to choose which one you'd like to install in, and change your config file based on what the database is named.

If you are on a dedicated server, just create a database called anything you want, and specify the name in your config file.

Originally posted by jasoncorn
and for the dbname what do I use there? Same as above.

Here is a rundown of what everything is:

MySQL Host Name: The server name or IP Address of the machine that MySQL is physically located on
MySQL User Name: User name used to access MySQL
MySQL Password: Password used to access MySQL
DatabaseName: The name of the database in MySQL that you are going to store your data.

All of that info has to be correct in order for vB (or any MySQL application) to work. Your host should have given you that information when they granted you MySQL access. If they didn't, I would recommend getting that info or you're paying for something that you can't use.

Hope this helps :)

-jim

[jasoncorn]

Thanks a lot of your great help, I really value support like this. :)