mysqli::real_connect(): (HY000/1049): Unknown database error in codeigniter

Question

I'm new to Codeigniter PHP framework. When I'm testing my application I get 'Unknown database db_name' error. I have browsed through several sites but didn't found solution for the problem as I'm trying the same to connect with wamp's mysql database. Any help would be appreciable.

Following is database.php in config folder: image describing Test database:

$active_group = 'default';
$query_builder = TRUE;

$db['default'] = array(
    'dsn'   => '',
    'hostname' => 'localhost',
    'username' => 'root',
    'password' => '',
    'database' => 'test',
    'dbdriver' => 'mysqli',
    'dbprefix' => '',
    'pconnect' => TRUE,
    'db_debug' => TRUE,
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '',
    'encrypt' => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array()
);

It should report `Unknown database 'test'` not `Unknown database 'db_name'`. — ourmandave, Jan 20 '18 at 12:44
Check this answer it may resolve your problem https://stackoverflow.com/a/58553255/2599596 — Naveen Kumar M, Oct 25 '19 at 06:26

score 6 · Answer 1 · answered Jan 17 '20 at 13:04

I was getting same error when i installed new wampserver 3.2.0, it is an evil it installs MariaDB by default and port 3306 is assigned to it , you cannot even change it. I think codeigniter/php tries to connect to this port by default. I used following , it worked for me i.e. hostname => 'localhost:3308'

 $db['default'] = array(
        'dsn'   => '',
        'hostname' => 'localhost:3308',
        'username' => 'root',
        'password' => '',
        'database' => 'soft',
        'dbdriver' => 'mysqli',
        'dbprefix' => '',
        'pconnect' => FALSE,
        'db_debug' => (ENVIRONMENT !== 'production'),
        'cache_on' => FALSE,
        'cachedir' => '',
        'char_set' => 'utf8',
        'dbcollat' => 'utf8_general_ci',
        'swap_pre' => '',
        'encrypt' => FALSE,
        'compress' => FALSE,
        'stricton' => FALSE,
        'failover' => array(),
        'save_queries' => TRUE
    );

You were correct, in new wamp version we have to connect db through port as well. — Jitendra Solanki, Feb 02 '20 at 12:16

Vipertecpro · Answer 2 · 2018-02-14T17:41:29.460

That's what i did to handle whether db exists or not :

First Change this in application/config/database.php

'db_debug' => (ENVIRONMENT !== 'production')

to

'db_debug' => FALSE;

Then add these two in your controller

    $this->load->dbforge();
    $this->load->dbutil();

Then check it in your method

    if( $this->dbutil->database_exists($this->db->database))
    {
        echo 'Database Already Exists';
    }
    else
    {
        if($this->dbforge->create_database($this->db->database))
        {
            echo 'Database created successfully !';
        }else
        {
            print_r($this->db->error());
            /*
               Array ( 
                     [code] => 1007 
                     [message] => Can't create database 'my_db'; database exists 
                    )
           */
        }
    }

score 1 · Answer 3 · answered Aug 17 '19 at 14:37

I was too getting this error. There are 2 fields in application/config/database.php file that should match up with your actual database:

'char_set' => 'utf8',
'dbcollat' => 'utf8_general_ci',

Make sure, the actual DB is of the same type & char_set as mentioned in the above file.

mysqli::real_connect(): (HY000/1049): Unknown database error in codeigniter

3 Answers3

Linked

Related