Codeigniter error when trying to connect to database using mysqli

Question

I am getting Following error in my CodeIgniter application which is live on server.

Here is the output of the error:

A PHP Error was encountered

Severity: Warning

Message: mysqli::real_connect(): (HY000/1044): Access denied for user 'xxx'@'localhost' to database 'xxx'

Filename: mysqli/mysqli_driver.php

Line Number: 161

Backtrace:

File: /home/arya123/public_html/application/controllers/Home.php Line: 7 Function: __construct

File: /home/arya123/public_html/index.php Line: 292 Function: require_once

In database file which extension r u using? $config['dbdriver'] = "mysqli"; — devpro
– devpro, Commented Mar 7, 2016 at 20:19
Seems like you don't have persmission to approach to that DB. Is it external DB or localhost (server's) one? — Tpojka
– Tpojka, Commented Mar 7, 2016 at 21:42
Have you checked that the application/config/database.php settings are correct? — jtheman
– jtheman, Commented Mar 7, 2016 at 22:51
if you are using shared hosting su as godaddy, I suggest you check the user which you created, because I had same problem, but It was the problem of user's permission in mysql — Marmik Bhatt
– Marmik Bhatt, Commented Mar 8, 2016 at 2:30
if you using OSX, this is the correct answer for you CodeIgniter: Unable to connect to your database server using the provided settings Error Message — Rohman HM
– Rohman HM, Commented Nov 26, 2016 at 17:05

Anurag Biradar · Accepted Answer · 2017-06-18 16:55:27Z

7

you have to set mysql port number which is by default 3306 check this in database.php

use either

'dbport' => '3306',

or

 'hostname' => 'mysql.hostingprovider.com:3306',

answered Jun 18, 2017 at 16:55

Anurag Biradar

941 silver badge7 bronze badges

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

Comments

Naveen Kumar M · Accepted Answer · 2019-10-25 06:25:38Z

4

Connect localhost with port solves the problem for me.

$db['default'] = array(
    'dsn' => '',
    'hostname' => 'localhost:3308', //Added port here
    'username' => 'root',
    'password' => '1234',
    'database' => 'my_database',
    'dbdriver' => 'mysqli',
    'dbprefix' => '',
    'pconnect' => FALSE,
    'db_debug' => (ENVIRONMENT !== 'production'),
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '',
    'encrypt' => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array(),
    'save_queries' => TRUE
);

answered Oct 25, 2019 at 6:25

Naveen Kumar M

7,5577 gold badges64 silver badges76 bronze badges

Comments

pra5hant · Accepted Answer · 2016-03-08 05:23:47Z

1

The same error I was getting when I upload my codeigniter project from localhost to Live server.

What solution I find is to make some changes into the application => config => database.php

Following is the database setting for the

localhost

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

Following database setting for

live server (Just demo, setting differ as per hosting provider)

1) First you have to create database.

2) find MySql Databases(or anything related database) on dashboard,

3) create new database and put database name, username, password.

4) export database from localhost

5) open phpmyadmin on live server and import it.

6) change the setting of application=>config=>database.php by using FTP client or dashboard.

$db['default'] = array(
    'dsn'   => '',
    'hostname' => 'mysql.hostingprovider.com',    
    'username' => 'abc.username',
    'password' => 'abc.password',
    'database' => 'abc.databasename',
    'dbdriver' => 'mysqli',
    'dbprefix' => '',
    'pconnect' => FALSE,
    'db_debug' => (ENVIRONMENT !== 'production'),
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '',
    'encrypt' => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array(),
    'save_queries' => TRUE
);

answered Mar 8, 2016 at 5:23

pra5hant

931 silver badge8 bronze badges

2 Comments

pra5hant Over a year ago

Have you find any difficulty to following this steps? or you miss something? have you change hostname, username, password, dbname? please recheck it!

Code Craving Over a year ago

Yes Everything as you mentioned

Reyhaneh Torab · Accepted Answer · 2019-09-05 10:25:50Z

1

u can add new user and pass and give it all privileges, like below:

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost';
FLUSH PRIVILEGES;

then, u should update your config.php file, with new user and pass.

answered Sep 5, 2019 at 10:25

Reyhaneh Torab

3675 silver badges9 bronze badges

Comments

Wouter Vanherck · Accepted Answer · 2018-09-14 13:49:32Z

0

Do the following:

In applications/config/database.php, add dbport => '3306', to the default array $db['default'] = array();
In system/database/DB_driver.php, change public $port = ''; to public $port = '3306';

edited Sep 14, 2018 at 13:49

Wouter Vanherck

2,3873 gold badges34 silver badges48 bronze badges

answered Jul 14, 2018 at 4:58

พูลทรัพย์ บุญวัง

172 bronze badges

Comments

Shento · Accepted Answer · 2018-11-14 08:34:42Z

0

Try to use the plain password with no special characters, below is the example:

$db['default'] = array(
    'dsn'   => '',
    'hostname' => 'localhost',
    'username' => 'password',
    'password' => 'Mynewpass@756',
    'database' => 'database_name',
);

answered Nov 14, 2018 at 8:34

Shento

114 bronze badges

Comments

ButchMonkey · Accepted Answer · 2020-02-27 01:31:08Z

0

You can edit your server's php.ini file to define the port that CodeIgniter will use by default.

C:\wamp64\bin\apache\apache2.4.41\bin\php.ini

Default port number for mysqli_connect().

mysqli.default_port = 3308

edited Feb 27, 2020 at 1:31

ButchMonkey

1,90721 silver badges30 bronze badges

answered Feb 26, 2020 at 20:18

jinx

12 bronze badges

Comments

0Zef0 · Accepted Answer · 2020-09-26 08:21:49Z

0

Try to set config/database.php 'username' => 'xxx' to 'username' => 'root' without any password.

$db['default'] = array( 
'dsn' => '',
'hostname' => 'localhost',
'username' => 'root',
'password' => '',

answered Sep 26, 2020 at 8:21

0Zef0

772 silver badges11 bronze badges

Comments

jeyglo · Accepted Answer · 2022-01-28 17:30:05Z

0

verify is user has the rights privilege declare on database

answered Jan 28, 2022 at 17:30

jeyglo

1501 silver badge6 bronze badges

Comments

Sher Salafi · Accepted Answer · 2022-12-04 05:46:44Z

0

i was having the same issue in CodeIgniter code. database and everything was correct but i fixed it by changing these lines

Before


    'dsn' => 'mysql:host=localhost;dbname=kiuurduapp',
    'hostname' => 'localhost',
    'username' => 'kiuurdu',

After


    'dsn' => 'mysql:host=127.0.0.1;dbname=kiuurduapp',
    'hostname' => '',
    'username' => 'kiuurdu',

and it works for me

answered Dec 4, 2022 at 5:46

Sher Salafi

212 bronze badges

Comments

Martin · Accepted Answer · 2018-07-13 13:37:43Z

-1

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

edited Jul 13, 2018 at 13:37

Martin

2,43711 gold badges30 silver badges32 bronze badges

answered Jul 13, 2018 at 10:38

Ragu S Mech

611 silver badge1 bronze badge

Comments

Juan David · Accepted Answer · 2018-08-12 20:48:33Z

-1

I had the same trouble. Since I use xampp and I was running my codeigniter app locally, the problem at the end I solved it by remplacing: 'hostname' => 'localhost ' by 'hostname' => '127.0.0.1:33065' the :33065 is the port assigned by default by xampp for phpmyadmin. If you are running your proyect in the xampp default options, changing this, should be enough (hopefully). But if you don´t, I guess, you can search which port you are using for the database conection, and add it to your hostname with ":" (if you are not sure which port you are using, you always can see in your D.B. administration tool -phpmyadmin or the one you are using- on the options, which port is taking).

answered Aug 12, 2018 at 20:48

Juan David

315 bronze badges

Collectives™ on Stack Overflow

Codeigniter error when trying to connect to database using mysqli

12 Answers 12

Comments

Comments

2 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

12 Answers 12

Comments

Comments

2 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Linked

Related