MySQL : "Unable to connect to your database server using the provided settings." But I can connect manually.

[eluser]veddermatic[/eluser]
I have a new CI 1.6.1 install. In my application/config/database.php file I have the host, username, pass, and db names set. The MySQL is version 5.0.2. I have other CI based sites running, and have gotten database connectivity no problems. When I call

Code:

$this->load->database()

From a controller or model, I get: "Unable to connect to your database server using the provided settings."

However, if I just use the raw PHP:

Code:

mysql_connect('mysql.myhost.com','myuser','mypass') or die("uh oh: ".mysql_error());
mysql_select_db('mydb') or die("no db: ".mysql_error());

It connects fine, and I can run queries and all is well. I have copy / pasted the working values from the raw PHP into the database.php file, so it's not a typo or anything of that nature.

That file looks like:

Code:

$db['default']['hostname'] = "mysql.myhost.com";
$db['default']['username'] = "myuser";
$db['default']['password'] = "mypass";
$db['default']['database'] = "mydb";
$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";

php.ini confirms that persistant connections are enabled, charset and collation match.

This is my first 1.6.X site (all my other CI sites are 1.5.x) so is there some "duuuh" setting somewhere I need to set, or?

[eluser]Michael Wales[/eluser]
Have you tried turning off pconnect (even though php.ini says persistent connections are enabled)?

[eluser]veddermatic[/eluser]
[quote author="Michael Wales" date="1204775194"]Have you tried turning off pconnect (even though php.ini says persistent connections are enabled)?[/quote]

Yup, same issue.

[eluser]veddermatic[/eluser]
OK.. in a very odd and confounding twist, it now works. What did change? I replaced the double quotes around the hostname in the config file with single quotes.

Code:

$db['default']['hostname'] =  "mysql.myhost.com";

Causes the error while:

Code:

$db['default']['hostname'] =  'mysql.myhost.com';

Works just fine. No other setting changed or anything.

Now to go bandage my head where I have been smashing it against my desk.

[eluser]ixxalnxxi[/eluser]
This very strange phenomenon happened with me also, I replaced the double quotes with single quotes and that error no longer showed up.

[eluser]Unknown[/eluser]
I had the same problem too. (I'm using CI 1.7.0)

I think it might have something to do with the server set-up as well. Things worked well on with my old host - then I transfered everything to a new host and received this error.

I changed the double quotes to single ones in the database config file(as suggested earlier) and all seems to work well so far.

[eluser]Unknown[/eluser]
[quote author="Michael Wales" date="1204775194"]Have you tried turning off pconnect (even though php.ini says persistent connections are enabled)?[/quote]
Had the same problem but w/o persistent connections.
I didn't even know to look for it.
Turning pconnect off solved it for me.
Thanks Michael

[eluser]Unknown[/eluser]
Just spent some time having a similar issue...
Thanks to suggestions here, i finally figured that port was missing!

...and that because of default php.ini of osx > "mysql.default_port = "

thanks

[eluser]Unknown[/eluser]
set $db['default']['pconnect'] = FALSE;

oK~~~~

[eluser]Unknown[/eluser]
I changed

$db['default']['db_debug'] = TRUE;

to

$db['default']['db_debug'] = FALSE;

and its working now