Unable to connect to your database server using the provided settings in Codeigniter

Question

Actually I'm trying to configure my codeigniter live file to localhost.

I have,

created a database called test_bs
then imported the tables
Then change the base_url like $config['base_url']=http://localhost/gu_ci/'; and $config['index_page']='index.php'; in config.php

And then did a change on database.php,Which contains

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

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = ' ';
$db['default']['database'] = 'test_bs';
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = TRUE;
$db['default']['cachedir'] = 'application/cache/';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

My .htacess file having:

  RewriteEngine On
  RewriteBase /new_admin/

  RewriteCond %{REQUEST_URI} PIE.htc
  AddType text/x-component .htc
  RewriteRule (.*) static/PIE.htc [L]

  RewriteCond %{REQUEST_URI} !^/new_admin/static/

  RewriteRule (.*)$ index.php [L]

I'm getting the following error:

     A Database Error Occurred

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

     Filename: C:\xampp\htdocs\gunify_ci\system\database\DB_driver.php

     Line Number: 124

I have referred Refer1, Refer2,Refer3,Refer4,Refer5 and so on... The last link just display the welcome message like: enter image description here But none of the solution helped me!!

Guide me to solve this!!

your database credentials seem to be wrong. Check the password that you have given is correct or not. — Harigovind R
– Harigovind R, Commented Jun 23, 2015 at 8:52
@HarigovindR actually where we can check our password? Because i have use a password field as empty for all other projects in php — PHP Learner
– PHP Learner, Commented Jun 23, 2015 at 8:54

suslov.nikita · Accepted Answer · 2015-07-21 05:00:53Z

4

$db['default']['password'] = ''; there is an space, remove it

use below settings

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = '';
$db['default']['database'] = 'test_bs';
$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;

Edit 01

Use this .htaccess

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php/$1 [L] 
</IfModule>

Edit 02

your folder structurer should be

Application
assets
- css
  1. boostrap.css
  2. style.css
- js
- images
system
.htacess
index.php

so code will be:

<link href="<?php echo base_url(); ?>assets/css/bootstrap.css" rel="stylesheet" />

edited Jul 21, 2015 at 5:00

suslov.nikita

44.7k11 gold badges92 silver badges113 bronze badges

answered Jun 23, 2015 at 8:59

Abdulla Nilam

39.7k18 gold badges85 silver badges115 bronze badges

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

1 Comment

Martijn Pieters Over a year ago

Comments are not for extended discussion; this conversation has been moved to chat.

Collectives™ on Stack Overflow

Unable to connect to your database server using the provided settings in Codeigniter

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related