Unable to connect to your database server using the provided settings.in Codeigniter?

Question

below is my database settings but that will give me following error

Unable to connect to your database server using the provided settings

$active_group = 'default';
$active_record = TRUE;

$db['default']['hostname'] = 'localhost:9880';
$db['default']['username'] = 'root';
$db['default']['password'] = '';
$db['default']['database'] = 'codeignitor';
$db['default']['dbdriver'] = 'mysqli';
$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;

Can anyone tell me where i am wrong. Please help

check your database name, is it really 'codeignitor'? or is it 'codeigniter' — Vickel
– Vickel, Commented Jul 2, 2014 at 16:08

gen_Eric · Accepted Answer · 2014-07-02 15:13:14Z

1

$db['default']['hostname'] = 'localhost:9880';

Your problem is there. That's not where the port number goes. It goes in $db['default']['port'].

$db['default']['hostname'] = 'localhost';
$db['default']['port'] = '9880';

Docs: http://ellislab.com/codeigniter/user-guide/database/configuration.html

answered Jul 2, 2014 at 15:13

gen_Eric

228k42 gold badges304 silver badges343 bronze badges

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

1 Comment

Sanjay Rathod Over a year ago

both have same result

Collectives™ on Stack Overflow

Unable to connect to your database server using the provided settings.in 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