Codeigniter Multiple Database Connection

Question

I am using CodeIgniter and I am trying to access a database that is placed remotely on another server. I can access that server remotely but I can't connect via my MySQL Connection settings. Here are my MySQL settings:

$db['default']['hostname'] = 'myhostname';

$db['default']['username'] = 'root';
$db['default']['password'] = '';
$db['default']['database'] = 'MyDb';
$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;

I am not sure where I am making a mistake so if someone can point out the mistake it will be really helpful.

apparently there is something wrong on server side, check your access log or try log in there manually first — aambrozkiewicz
– aambrozkiewicz, Commented Aug 16, 2012 at 8:58
how do you access server? have you tried connecting to mysql without using CI? do you have a cpanel on remote server? — Velja Matic
– Velja Matic, Commented Aug 18, 2012 at 23:03

sonupondhak · Accepted Answer · 2012-12-17 16:47:02Z

1

First, check username and password for mysql (obviously username cannot be root and password cannot be blank for security reasons) and for hostname, you might have to supply IP address of your server where mysql is hosted. Rest configurations appear to be fine. You can ask for these information from your hosting company.

answered Dec 17, 2012 at 16:47

sonupondhak

112 bronze badges

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

1 Comment

noobie-php Over a year ago

on local envoirment password can be blank

Collectives™ on Stack Overflow

Codeigniter Multiple Database Connection

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