codeigniter 3 error connecting to db

Question

I run wamp and try to connect to db but I got

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

Few faqs / what I've done:

I autoloaded the database library in config.php
my phpMyAdmin doesn't have any username and pass set
this is the setting in database.php

$db['default'] = array(
  'dsn'   => '',
  'hostname' => 'localhost',
  'username' => '',
  'password' => '',
  'database' => 'ciintro',
  'dbdriver' => 'mysqli',
  'dbprefix' => '',
  'pconnect' => TRUE,
  'db_debug' => TRUE,
  'cache_on' => FALSE,
  'cachedir' => '',
  'char_set' => 'utf8',
  'dbcollat' => 'utf8_general_ci',
  'swap_pre' => '',
  'autoinit' => TRUE,
  'encrypt' => FALSE,
  'compress' => FALSE,
  'stricton' => FALSE,
  'failover' => array(),
  'save_queries' => TRUE
);

try a simple mysql_connect() in index.php and see if that works — Samuel Adam
– Samuel Adam, Commented Nov 21, 2014 at 3:14

Hamad · Accepted Answer · 2014-11-21 05:24:57Z

2

'username' => '',

should be

'username' => 'root',

check username.

edited Nov 21, 2014 at 5:24

Hamad

5,15013 gold badges39 silver badges65 bronze badges

answered Nov 21, 2014 at 5:08

virendra

1639 bronze badges

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

Comments

KIRANDEEPU.K · Accepted Answer · 2014-11-21 12:02:43Z

0

I think you are newer to codeigniter.

'username' => 'root' ( root or whatever you set for PHPMYADMIN.)

'password' => 'password' ( password or whatever you set for PHPMYADMIN.)

answered Nov 21, 2014 at 12:02

KIRANDEEPU.K

8110 bronze badges

Collectives™ on Stack Overflow

codeigniter 3 error connecting to db

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related