MySQL Connection Issues - Dreamhost

[eluser]Crazy88s[/eluser]
I'm trying to get my site working correctly on my host Dreamhost but I seem to be having an issue with MySQL. I get the following error when trying to view my site:

Unable to connect to your database server using the provided settings.

I have verified that my database settings are correct and I can access the MySQL database using Phpmyadmin just fine.

My config is as follows:

Code:

$active_group = "default";
$active_record = TRUE;

$db['default']['hostname'] = "sql.mydomain.com";
$db['default']['username'] = "user";
$db['default']['password'] = "password";
$db['default']['database'] = "databasename";
$db['default']['dbdriver'] = "mysql";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";

Changing pconnect to FALSE didn't help.

Any advice is grealty appreciated.

[eluser]James Gifford[/eluser]
It sounds like there is still an error in your database settings. Try triple-checking all the values. Maybe your username should be something like user_mysql? Maybe theres a typo in your databasename?

Only you know your server settings, so only you can be sure the values are all correct, but based on the error message there's a typo or incorrect value somewhere.

[eluser]Crazy88s[/eluser]
I've tripled check the settings and they are correct. In addition to phypmyadmin, I logged in via SSH and using the mysql command line and I was able to connect.

I really don't know what the problem could be.

[eluser]gtech[/eluser]
I don't really know what your problem is

the only difference in my config is that for mysql I am using the mysqli driver.
$db['default']['dbdriver'] = "mysqli";
$active_record = TRUE; instead I have $db['default']['active_r'] = TRUE;

could be a red herring though.

What version of php are you using as I have read in some forums they have had issues with php4 on dreamhost.

[eluser]gtech[/eluser]
if you are trying to connect to the database from a different machine then the below link may also be useful

[url="http://blog.dreamhosters.com/kbase/index.cgi?area=2991"]http://blog.dreamhosters.com/kbase/index.cgi?area=2991[/url]

Note that if you're connecting from an IP that's not hosted with us (like say, your home or office) you'll need to add it through our web panel as an allowable IP to access your database!

[eluser]Crazy88s[/eluser]
[quote author="gtech" date="1211504023"]if you are trying to connect to the database from a different machine then the below link may also be useful

[url="http://blog.dreamhosters.com/kbase/index.cgi?area=2991"]http://blog.dreamhosters.com/kbase/index.cgi?area=2991[/url]

Note that if you're connecting from an IP that's not hosted with us (like say, your home or office) you'll need to add it through our web panel as an allowable IP to access your database!

[/quote]

This worked. I've never had to do it before though. Very strange. Thanks for the help.

[eluser]gtech[/eluser]
lol, that was a bit of a lucky guess.. cool glad you got it working