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

0 votes

 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.

Feb 16 in Others by Aditya
• 7,280 points
697 views

1 answer to this question.

0 votes

 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.

answered Feb 16 by Soham
• 8,730 points

Related Questions In Others

0 votes
1 answer

HTTP Error 403.14 - Forbidden - The Web server is configured to not list the contents of this directory

Try keeping this into your web config ...READ MORE

answered Feb 11 in Others by Rahul
• 8,980 points
1,178 views
0 votes
1 answer

Using unserialize in PHP throws the same error repeatedly

I googled 'Node no longer exists', and ...READ MORE

answered Nov 14, 2018 in Others by DataKing99
• 8,240 points
779 views
0 votes
0 answers

unable to connect to internet in edureka VM

i am unable to connect to internet ...READ MORE

Jun 7, 2019 in Others by Ashok
• 120 points
231 views
0 votes
0 answers
0 votes
2 answers

Define a SQL query? What is the difference between SELECT and UPDATE Query? How do you use SQL in SAS?

HI.. SQL is Structured Query Language, which is ...READ MORE

answered Aug 8, 2020 in PHP by anonymous
4,266 views
0 votes
1 answer

Why is not preferable to use mysql_* functions in PHP?

The reasons are as follows: The MySQL extension: Does ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,240 points
312 views
0 votes
2 answers
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP