How to use remote db with local codeigniter?

Question

I have xampp server running Codeiginiter 2.1.0 and a webserver with MySQL. I already have remote access with SQL-Front but when i put the same config in CI I recive this error:

A Database Error Occurred

Unable to connect to your database server using the provided settings.
Filename: C:\xampp\htdocs\mysite\trunk\system\database\DB_driver.php
Line Number: 124

database.php:

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

$db['default']['hostname'] = 'myserver.com';
$db['default']['username'] = 'user_name';
$db['default']['password'] = 'pass';
$db['default']['database'] = 'database_name';
$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;

Someone know how to connect to remote database? Thanks for help!

The solution I found was downgrade the xampp to version 1.7.3 on windows. On Linux the problem was the same... Thanks for help! — Calzzetta
– Calzzetta, Commented Jan 19, 2012 at 12:23

jamesTheProgrammer · Accepted Answer · 2012-01-10 17:26:52Z

1

I have used a mysql connect script like this. Connect script requires hostname, username and password. I am the administrator for the db, so could create or set the parameter values.

<?php

 // echo output below when called
 $con = mysql_connect($CFG->dbhost ,$CFG->dbuser, $CFG->dbpass);

 if (!$con){
    die('Could not connect: ' . mysql_error());
 }else{
    mysql_select_db($CFG->dbname, $con);
 }

?>

answered Jan 10, 2012 at 17:26

jamesTheProgrammer

1,7734 gold badges22 silver badges34 bronze badges

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

Comments

Brett DeWoody · Accepted Answer · 2012-01-10 02:42:45Z

0

In your /application/config/database.php file you can define an external database in the $db['default']['hostname'] setting.

You'll need to lookup what your external database address is through your web host most likely. Some hosts also restrict external access by IP address, so you might need to set that up also.

answered Jan 10, 2012 at 2:42

Brett DeWoody

63.3k31 gold badges145 silver badges192 bronze badges

2 Comments

Calzzetta Over a year ago

I have access to remote db.I have made a php script to connect with the same config and worked... The problem is with CI.

Brett DeWoody Over a year ago

Have you tried turning on db_debug? If that doesn't show anything the next thing I would try is setting the $db['default']['port'] value.

user2164884 · Accepted Answer · 2016-10-07 05:32:55Z

0

Once you have the IP address that you wish to connect remotely from, follow these steps.

Log into cPanel.
Click the Remote MySQL button in the Databases section.
Enter the remote IP address in the Add Access Host section.
Click the Add Host button.

answered Oct 7, 2016 at 5:32

user2164884

Collectives™ on Stack Overflow

How to use remote db with local codeigniter?

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related