Connect with remote mySql from localhost with codeigniter

Asked Apr 24 '15 at 10:56

Active Apr 24 '15 at 11:10

Viewed 2,099 times

I have a remote mysql server. Now I am developing a software in Codeigniter integrated with that mysql server. I gave the GRANT ALL to 'user'@'myid' in mysql user. But codeigniter shows the following error:

A Database Error Occurred
Unable to connect to your database server using the provided settings.

How can i use remote mysql in my local development environment?

BTW: I use WAMP in windown 7.

Thanks in advance.

EDIT:

Database Configuration:

$db['default']['hostname'] = '198.xxx.xx.66';
$db['default']['username'] = 'root';
$db['default']['password'] = 'xxxxxx';
$db['default']['database'] = 'm000db';
$db['default']['dbdriver'] = 'mysql';
$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;

edited Apr 24 '15 at 11:10

asked Apr 24 '15 at 10:56

Ariful Islam

7,639
7
36
54

1

Please post your db setting code. – Arkar Aung Apr 24 '15 at 11:03
http://stackoverflow.com/a/8808509/545138 – dude Apr 24 '15 at 11:20
on which port number your remote database is running on? @Arif – Ronak Joshi Apr 24 '15 at 11:57
@RonakJoshi Its the default port 3306 – Ariful Islam Apr 24 '15 at 12:18
can you connect to it with desktop tools like MySql workbench or HeidiSql? – charlietfl Apr 25 '15 at 00:59
Yes, agree with @charlietfl. Because some times MySQL could not connect with default port number. So,try to change port number on remote side and then add this line to config, `$db['default']['port'] = '3307';` – Ronak Joshi Apr 25 '15 at 05:55
@RonakJoshi is there any way with changing default port? – Ariful Islam Apr 25 '15 at 10:34

Connect with remote mySql from localhost with codeigniter

0 Answers0