Codeigniter Remote Database Connection Issue

php mysql linux codeigniter database-connection

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

php mysql linux codeigniter database-connection

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

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

instead of

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

php mysql linux codeigniter database-connection

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

CodeHunter