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

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 '<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.

Related Posts:

  1. Should I use mysqli_real_escape string() or mysql_real_escape_string() for form data?
  2. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in
  3. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  4. MySqli Commands out of sync; you can’t run this command now
  5. Commands out of sync; you can’t run this command now
  6. mysqli::query(): Couldn’t fetch mysqli
  7. Deprecated: mysql_query() [duplicate]
  8. Having a problem getting mysqli_query to execute
  9. How to prevent the “Confirm Form Resubmission” dialog?
  10. How to use mysqli_query() in PHP?
  11. What is a slug?
  12. How to log in to phpMyAdmin with WAMP, what is the username and password?
  13. Fatal error: Call to undefined function mysql_connect()
  14. PDOException SQLSTATE[HY000] [2002] No such file or directory
  15. http://localhost:80 is not working on running Apache server through UniServer ZeroXIII
  16. PDOException SQLSTATE[HY000] [2002] No such file or directory
  17. Mysql query- How to use contains?
  18. Invalid column count in CSV input on line 1 Error
  19. Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, object given in
  20. Invalid column count in CSV input on line 1 Error
  21. mysqli_real_connect(): (HY000/2002): No such file or directory
  22. Fatal error: Call to undefined function mysqli_connect()
  23. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  24. $wpdb->update or $wpdb->insert results in slashes being added in front of quotes
  25. PDO with INSERT INTO through prepared statements
  26. phpMyAdmin: secret passphrase?
  27. PDO bindParam() with prepared statement isn’t working
  28. Forbidden :You don’t have permission to access /phpmyadmin on this server
  29. mysqli_real_connect(): (HY000/2002): No such file or directory
  30. Fatal error: Call to undefined function mysqli_connect()
  31. What does __FILE__ mean?
  32. Creating a search form in PHP to search a database?
  33. How can I do ‘insert if not exists’ in MySQL?
  34. Trying to get property of non-object in
  35. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  36. Getting connection failed: php_network_getaddresses: getaddrinfo failed: Name or service not known
  37. Call to undefined method mysqli_stmt::get_result
  38. Call to undefined method mysqli_stmt::get_result
  39. Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
  40. PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client
  41. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  42. How can I do ‘insert if not exists’ in MySQL?
  43. Fatal error: Cannot use object of type mysqli_result
  44. How to solve “Fatal error: Class ‘MySQLi’ not found”?
  45. mysql_field_name to the new mysqli
  46. Object of class DateTime could not be converted to string
  47. What does it mean to escape a string?
  48. Convert from MySQL datetime to another format with PHP
  49. MAMP “Apache couldn’t be started because port is in use.” AND “Can’t connect to local MySQL server through /tmp/mysql.sock
  50. mysqli_select_db() expects parameter 1 to be mysqli, string given
  51. Unexpected Exception: SQLSTATE[HY000] [1045] Access denied for user ****@’localhost’ (using password: YES)
  52. Uncaught Error: Call to undefined function mysql_escape_string()
  53. phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied for user ‘pma’@’localhost’ (using password: NO)
  54. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in
  55. Call to a member function on null?
  56. Warning: mysqli_query() expects at least 2 parameters, 1 given. What? [duplicate]
  57. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102
  58. Only variable references should be returned by reference – Codeigniter
  59. Warning: mysqli_query() expects parameter 1 to be mysqli, resource given
  60. MySQL query to get column names?
  61. What does MYSQLI_NUM mean and do?
  62. Fatal Error: Allowed Memory Size of 134217728 Bytes Exhausted (CodeIgniter + XML-RPC)
  63. Mysql where id is in array
  64. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  65. What is the advantage of using try {} catch {} versus if {} else {}
  66. select * from table where column = value ^ column2= value
  67. Object of class mysqli_result could not be converted to string
  68. No query results for model [App\Products] Laravel
  69. Fatal error: Call to a member function fetch_assoc() on a non-object
  70. Fatal error: Call to a member function query() on null
  71. mysqlworkbench giving version error on exporting database
  72. How to make DROP INDEX IF EXISTS for mysql?
  73. What is the meaning of sprintf(): Too few arguments
  74. Can I store images in MySQL 
  75. MySQL Daemon Failed to Start – centos 6
  76. Warning: mysqli_real_escape_string() expects exactly 2 parameters, 1 given… what I do wrong? 
  77. How to insert TIMESTAMP into my MySQL table?
  78. How to remove index.php from WordPress site URL
  79. PHP Like thing similar to MySQL Like, for if statement?
  80. How get value from URL
  81. Object of class stdClass could not be converted to string
  82. Call to a member function fetch_assoc() on boolean in [duplicate]
  83. How to use Memcached with PHP7?
  84. select count(*) from table of mysql in php
  85. PHP variables don’t evaluate in the query [duplicate]
  86. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ””)’ at line 2
  87. Get user role by ID WordPress
  88. How to fix syntax error, unexpected T_IF error in php?
  89. Unzip a file with php
  90. Difference between require, include, require_once and include_once?
  91. Php – Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  92. cannot change admin password, wordpress on godaddy
  93. How can I call a row of user specific data from a custom table added to the WP Database
  94. Create a quick start wordpress installation [closed]
  95. Ordering users by custom user meta
  96. Multiple meta_key in one global $wpdb;
  97. Most commented posts by time period (last 12h, last 24h and etc)
  98. Modify WooCommerce used to get all orders in dashboard
  99. cant insert data in a custom table in phpmyadmin
  100. How to pass username into form that sends data to database

Leave a Comment