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  just add the    i    at the end of MySQL  and added the port number  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   Thank you

User · Answer

Problem solved   I was having all my website set up first in XAMMP  then I had to transfer it to LAMP  in a SUSE installation of LAMP  where I got this error   The problem is that these parameters in the database php file should not be initialised  Just leave username and password blank  That s just it    My first and lame guess would be that s because of old version of mysql  as built-in installations come with older versions

User · Answer

Extending  Valeh Hajiyev great and clear answer for mysqli driver tests   Debug your database connection using this script at the end of   config database php      Your db config here      db  default     array              dbdriver        gt   mysqli                   Connection test      echo   lt pre gt    print r  db  default     echo   lt  pre gt     echo  Connecting to database      db  default    database      mysqli connection   new MySQLi  db  default    hostname                                     db  default    username                                     db  default    password                                      db  default    database      if   mysqli connection- gt connect error       echo  Not connected  error       mysqli connection- gt connect error    else      echo  Connected      die   file       FILE       Line       LINE

User · Answer

For me the issue was in the php ini file  The property mysql default socket was pointing to file in a non-existent directory  The property was pointing to  var mysql mysql sock but in OSX  the file was located in  tmp mysql sock   Once I updated the entry in php ini and restarted the webserver  the issue was resolved

User · Answer

In my case storage was a problem  My hard drive was full    Make some space in hardware and your site will work fine

User · Answer

I think  there is something wrong with PHP configration   First  debug your database connection using  this script at the end of   config database php                      echo   lt pre gt      print r  db  default       echo   lt  pre gt       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   lt br   gt    Connected OK          die   file       FILE       Line       LINE        Then see what the problem is

User · Answer

In your configurations  specify the port number your database is on  You can find the port number at the top left corner of phpMyAdmin  It would look something like this const DB HOST    localhost 3308

User · Answer

I solved the problem by changing    db  default    pconnect     TRUE  TO  db  default    pconnect     FALSE    in  application config database php

User · Answer

If you used this to secure your server  http   www thonky com how-to prevent-base-64-decode-hack   And then got the error  Code Igniter needs mysql pconnect   in order to run   I figured it out once I realized all the Code Igniter websites on the server were broken  so it wasn t a localized connection issue

User · Answer

CI 3  For me  what worked was changing    hostname    gt   localhost  to  hostname    gt   127 0 0 1

User · Answer

Change  db  default    dbdriver      mysql  to  db  default    dbdriver      mysqli

User · Answer

If that is all you have changed  you may not have the mysqli driver installed or enabled within your PHP configuration   Check for its presence using phpinfo    or in your php ini file  extension php mysqli

User · Answer

SET  db  default    db debug    to FALSE instead of TRUE     db  default    db debug     FALSE

User · Answer

I ve solved this  In my case I just changed my configuration   hostname  became  localhost    active group    default    active record   TRUE    db  default    hostname      localhost

User · Answer

Today I fallen this kind of problem in live server and i solved the problem changing this line   db  default    db debug     TRUE    to    db  default    db debug     FALSE

[php] CodeIgniter: Unable to connect to your database server using the provided settings Error Message

Examples related to php

Examples related to mysql

Examples related to codeigniter

Examples related to connection

Examples related to mysqli