Codeigniter Remote Database Connection Issue

Question

A Codeigniter project(in windows) is required to connect with a Remote Mysql Database(in linux server). here is my database.php configuration.

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

$db['default']['hostname'] = 'xxx.xxx.x.xxx';
$db['default']['username'] = 'username';
$db['default']['password'] = 'password';
$db['default']['database'] = 'database';
$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;

and it gives an error

A Database Error Occurred

Unable to connect to your database server using the provided settings.

Filename: *:\****\***\htdocs\project\system\database\DB_driver.php

Line Number: 124

but i can access the remote mysql database via Phpmyadmin and Heidisql using the same username and password. (all privilages granted)

Here is Remote Database configuration

Server version: 5.0.95
Protocol version: 10
Server: Localhost via UNIX socket
MySQL charset: UTF-8 Unicode (utf8)
MySQL client version: 5.0.95
Used PHP extensions: mysql

Any help would be greatly appreciated

Take a look at this, link. It may be due to the port configuration. — ArrowHead
– ArrowHead, Commented Feb 5, 2016 at 13:30
If you are using codeigniter 3, the mysql driver has been removed. Try with pdo or mysqli instead. See : codeigniter.com/user_guide/database/… — AdrienXL
– AdrienXL, Commented Feb 5, 2016 at 14:40
@AdrienXL Deprecated, not removed - that's deffinately not the problem here. But otherwise, yeah - go with mysqli. — Narf
– Narf, Commented Feb 5, 2016 at 22:54
Also, judging by the line number shown in that error message - the OP is using 2.x. — Narf
– Narf, Commented Feb 5, 2016 at 22:56
changed the $db['default']['dbdriver'] = 'mysql'; to $db['default']['dbdriver'] = 'mysqli'; but no improvements. when tried with pdo it returns Fatal error: Uncaught exception 'PDOException' with message 'invalid data source name' — Shifana Mubi
– Shifana Mubi, Commented Feb 6, 2016 at 4:30

Community · Accepted Answer · 2017-05-23 11:52:44Z

1

I faced the same issue before a couple of months ago when connecting to the remote mysql server in linux.

I tried this in mysql via PHPMYADMIN

SHOW VARIABLES LIKE 'old_passwords' and it says me ON

it means that old_passwords=1 in my.cnf file in the server mysql configuration.

Solution for this problem is by updating the password for the corresponding user

Reference : Error: mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication

edited May 23, 2017 at 11:52

CommunityBot

11 silver badge

answered Feb 6, 2016 at 9:36

Akhil P M

1821 gold badge2 silver badges13 bronze badges

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

2 Comments

Shifana Mubi Over a year ago

Just tried this, no effect in codeigniter. it still return the same error that i mentioned on the question. but when i tried with a normal php programs it returns Warning: mysql_connect(): mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication...

Akhil P M Over a year ago

Update the database password again with nothing. and then try to connect with no password.

duduwe · Accepted Answer · 2016-02-06 09:01:14Z

0

Not sure if this would help, but I did encounter similar issue before.

$db['default']['dbdriver'] = 'mysqli';

instead of

$db['default']['dbdriver'] = 'mysql';

answered Feb 6, 2016 at 9:01

duduwe

1,32214 silver badges22 bronze badges

1 Comment

duduwe Over a year ago

@ShifanaMubi, that is unfortunate. I checked your settings based on my working projects just to make sure and they should work. So, you probably are left to consider 1.) firewall? 2.) correct credentials (host, user, pwd).

Kavinda Jayakody · Accepted Answer · 2017-11-10 13:46:59Z

0

See if this works

Create a user with all privilages, Remember to set host to %

Edit mysqld.cnf and set "bind-address = 0.0.0.0" (may be /etc/mysql/mysql.conf.d/mysqld.cnf)

Restart mysql

answered Nov 10, 2017 at 13:46

Kavinda Jayakody

7862 gold badges16 silver badges29 bronze badges

Collectives™ on Stack Overflow

Codeigniter Remote Database Connection Issue

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related