Codeigniter MySql Database Connection Issue

Question

The settings in \config\database.php for remote database connectivity are the following:

// Remote Server settings
$db['default']['hostname'] = 'abc.com';
$db['default']['username'] = 'admin';
$db['default']['password'] = 'password';
$db['default']['database'] = 'mydatabase';

But accessing the webpage via browser it gives the following error.

A Database Error Occurred

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

Is there any issue with hostname? Other credentials are correct but I am not sure about hostname! I provided the IP address of my website also but both give the same error. The hostname of mysql database will be different than the website? although I hosted the database on the same server using CPANEL.

In my experience, when I have had this problem it's a firewall issue on the remote machine. — Craig
– Craig, Commented Feb 4, 2015 at 15:40
If the database is hosted on the same server as the website, then you can just use "localhost" — Craig
– Craig, Commented Feb 4, 2015 at 15:41

Bitwise Creative · Accepted Answer · 2015-02-04 15:42:12Z

0

If the database is on the same server, use localhost for the hostname.

answered Feb 4, 2015 at 15:42

Bitwise Creative

4,0805 gold badges31 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

Codeigniter MySql Database Connection Issue

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related