Cant connect to to DB using CI4

Try testing it with MySQLi Test

PHP Code:

<?php

/**
 * Fill our vars and run on cli - $ php -f mysqli_test.php
 * or
 * Use php editor save file as mysqli_test.php
 */

$dbname = 'database_name'; // The database name
$dbuser = 'user_name';     // The users name
$dbpass = 'user_password'; // The database users password
$dbhost = 'database_host'; // usally localhost else use 27.0.0.1

// Try to connect
$connect = mysqli_connect($dbhost, $dbuser, $dbpass) or die("Unable to Connect to '$dbhost'");

// Select the database
mysqli_select_db($connect, $dbname) or die("Could not open the db '$dbname'");

// Test query to get database tables
$test_query = "SHOW TABLES FROM $dbname";

// The query result
$result = mysqli_query($connect, $test_query);

$tblCnt = 0;

while($tbl = mysqli_fetch_array($result))
{
    $tblCnt++;
    echo $tbl[0]."<br>\n";
}

if ( ! $tblCnt)
{
    echo "There are no tables<br>\n";
}
else
{
    echo "There are $tblCnt tables<br>\n";
} 


See if that works if not you have a problem in user password or host.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )