CodeIgniter Unable to connect to your database server using the provided settings Error Message

Question

 I have been using CI just fine using the MySQL driver. I want to use the MySQL driver instead, but as soon as I change it, I get the following error message

A Database Error Occurred

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

Filename: core/Loader.php

Line Number: 232

my setting look like this:

$db['default']['hostname'] = $hostname; 
$db['default']['username'] = $username; 
$db['default']['password'] = $password; $db['default']['database'] = $database; 
$db['default']['dbdriver'] = 'mysqli'; 
$db['default']['port'] = "3306"; 
$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';
$db['default']['swap_pre'] = ''; $db['default']['autoinit'] = TRUE; $db['default']['stricton'] = FALSE; 

where 

$hostname = 'localhost'; 
$username = 'myusernamegoeshere'; 
$password = 'mypasswordgoeshere'; 
$database = 'mydatabasenamegoeshere';

I'm Using:

CI 2.0.2 php 5.3.4 Apache/2.2.17 (Unix) mysql 5.5.13 mysql.default_port 3306

Am I doing anything wrong? If so, please let me know?

Thank you.

Answer 1

 I'm assuming there is something wrong with PHP configuration.

First, debug your database connection using this script at the end of ./config/database.php :

 

... 
    ... 
    ... 
  echo '<pre>'; 
  print_r($db['default']); 
    echo '</pre>'; 

  echo 'Connecting to database: '.$db['default']['database']; 
  $dbh=mysql_connect ( 

  $db['default']['hostname'], 
    $db['default']['username'], 
    $db['default']['password']) 
    or die('Cannot connect to the database because: ' . 
    mysql_error()); mysql_select_db ($db['default']['database']); 

    echo '<br /> Connected OK:' ; 
    die( 'file: ' .__FILE__ . ' Line: ' .__LINE__);

Then see what the problem is.