Error connecting mysql database with php Codeigniter

Question

I'm using Codeigniter and I can't connect my database, give me an error:

I just add the library in autoload.php :

`$autoload['libraries'] = array('database');`

and this are my settings in database.php

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

$db['default'] = array(
    'dsn'   => '',
    'hostname' => 'localhost',
    'username' => 'root',
    'password' => 'root',
    'database' => 'heroes',
    '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
);

:S any help?

What library did you add? What are your settings inside application/config/database.php? Please give some more details. — cssBlaster21895
– cssBlaster21895, Commented Sep 2, 2015 at 20:01
Did you make any modifications to index.php , maybe wrong system path? Does the application work without database lib? — cssBlaster21895
– cssBlaster21895, Commented Sep 2, 2015 at 20:14
try to change hostname 127.0.0.1 instead localhost and check wheter port 3306 is blocked (default mysql port) — cssBlaster21895
– cssBlaster21895, Commented Sep 2, 2015 at 20:40

Ali ATriple · Accepted Answer · 2015-09-02 21:24:09Z

1

Just I changed localhost by 127.0.0.1:3306

answered Sep 2, 2015 at 21:24

Ali ATriple

17915 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ali ATriple Over a year ago

But this is the answer ... :S

Collectives™ on Stack Overflow

Error connecting mysql database with php Codeigniter

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related