使用本地IP地址连接到mysql数据库 - Codeigniter

Question

I want to connect to database with ip address instead of local host, but when I write IP Address (another PC in LAN), it shows me error of permission denied.My connection array is as follows:

$db['default']['hostname'] = '192.168.1.122';
$db['default']['username'] = 'root';
$db['default']['password'] = '123456';
$db['default']['database'] = 'test_db';
$db['default']['dbdriver'] = 'mysqli';

result is:

Message: mysqli::real_connect(): (HY000/2002): Permission denied Filename: mysqli/mysqli_driver.php

I am using CentOS 7 and tried connection with telnet and it is working fine there.

Answer 1

Probably you haven't the permission to log as root from a host different from localhost. You can find info here.

You can grant permissions to root this way:

GRANT ALL ON *.* to root@'%' IDENTIFIED BY 'mysql root password';