xampp error: does not connect to database server , with codeigniter

Question

I am working on a codeigniter project. I developed it using wampserver locally, but I'd like to make some changes with xampp . It works fine on the remote site. Unfortunately when I try to run it locally I am getting:

A Database Error Occurred
Unable to connect to your database server using the provided settings.
Filename: F:\xampp-portable\htdocs\....\database\DB_driver.php
Line Number: 124

to my index.php file , I have added:

mysql_connect("localhost","root","") or die ("Could not connect to mysql server.");
mysql_select_db("contacts_db") or die ("Could not connect to database.");

This does NOT generate an error. Can anyone give me some pointers on what to check next?

Thanks in advance,

Bill

OK guys, here is the code around line 124:

function initialize()
{
    // If an existing connection resource is available
    // there is no need to connect and select the database
    if (is_resource($this->conn_id) OR is_object($this->conn_id))
    {
        return TRUE;
    }

    // ----------------------------------------------------------------

    // Connect to the database and set the connection ID
    $this->conn_id = ($this->pconnect == FALSE) ? $this->db_connect() : $this-        >db_pconnect();

    // No connection resource?  Throw an error
    if ( ! $this->conn_id)
    {
        log_message('error', 'Unable to connect to the database'); // 124

        if ($this->db_debug)
        {
            $this->display_error('db_unable_to_connect');
        }
        return FALSE;
    }

John was right, although I am now confused. I had set up the following code in my index.php to auto switch between xampp and server database config files:

define('ENVIRONMENT', isset($_SERVER['SERVER_NAME'])=='my_domain_name.com' ? 'production' : 'development');

    echo 'SERVER_NAME  '.$_SERVER['SERVER_NAME']; // getting localhost
    echo 'env '.ENVIRONMENT; // getting production.

I thought this would result in the ENVIRONMENT constant set to 'development' with $_SERVER['SERVER_NAME']=localhost. Would someone mind explaining what I'm doing wrong here?

The error is coming out of DB_Driver.php - could you provide us with the code in that line number - i think the connection is established somewhere else but not in index.php. — Alex2php
– Alex2php, Commented Nov 29, 2012 at 22:31
uhhhhh have you set your db password and username in the config file or changed it since moving it to the new server? are the passwords really the same? I dont think its going to be localhost as the username for both... — Rooster
– Rooster, Commented Nov 30, 2012 at 0:07
Sort of skimming over the last update, try user/pass as root/root rather than root/'blank'. Xampp's default has the password set to root, where as mamp, wamp, etc I believe don't have passwords. — Chords
– Chords, Commented Nov 30, 2012 at 2:44

SubRed · Accepted Answer · 2012-11-30 04:32:44Z

3

Please check your config/database.php file, as I know the config database in codeigniter is in this file. Some values you need to pay attention are:

$db['default']['hostname'] = '';
$db['default']['username'] = '';
$db['default']['password'] = '';
$db['default']['database'] = '';

answered Nov 30, 2012 at 4:32

SubRed

3,1871 gold badge21 silver badges17 bronze badges

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

2 Comments

user1592380 Over a year ago

As the only answer, I am up voting you. You are correct as my environment settings code ( listed above ) was wrong and caused the wrong database config file to be selected in my local environment. I changed it to define('ENVIRONMENT', isset($_SERVER['SERVER_NAME'])=='my_domain_name.com' ? 'production' : 'development'); regards - Bill

SubRed Over a year ago

Well I just thought that you might miss this settings since you create your own connection link to database and CI by default load its settings as well that might cause the conflict. However glad I could help you :)

Collectives™ on Stack Overflow

xampp error: does not connect to database server , with codeigniter

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related