Showing Error: mysqli::real_connect(): (28000/1045): Access denied for user 'user'@'192.188.145.163' (using password: YES)

Question

This is a codeigniter project. my given database information is right.It works perfectly in localhost. But after uploading my project in hosting site, it still shows an 'access denied' error.

This is my database:

 $db['default'] = array(
    'dsn' => '',
    'hostname' => 'telihatyhighschool.edu.bd',
    'username' => 'db_username',
    'password' => 'db_password',
    'database' => 'db_name',
    'dbdriver' => 'mysqli',
    'dbprefix' => '',
    'pconnect' => FALSE,
    'db_debug' => TRUE,
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '',
    'encrypt' => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array() ,
    'save_queries' => TRUE
);

How can I solve this ?

Read the mysql documantatio how you add a user to your database https://dev.mysql.com/doc/refman/5.5/en/adding-users.html — Jens, Oct 15 '15 at 07:19
As above comment suggests your user dont have enough previliges — noobie-php, Oct 15 '15 at 07:19
But I used All previlige checkbox.So I think there is no reason to don't have enough previliges. — Mamun Sabuj, Oct 15 '15 at 07:31
It works perfectly in localhost.But after uploading in my hosting site, it shows access denied error. — Mamun Sabuj, Oct 15 '15 at 07:34
if your database is on localhost, and your php script is on remote location, then you should allow access to your mysql port on local machine. — Vali S, Oct 15 '15 at 07:34
Your host starts with blank space? Also you have sufficient one quote infront username string. — Tpojka, Oct 15 '15 at 10:54

Linus · Answer 1 · 2015-10-15T13:40:49.400

In cpannel actually username and database name has cpanel username prefix eg

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

$db['default']['hostname'] = 'localhost'; //literaly put localhost
$db['default']['username'] = 'cpanelusername_root';
$db['default']['password'] = 'password';
$db['default']['database'] = 'cpanelusername_db name';
$db['default']['dbdriver'] = 'mysqli'; ///use this extension
$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;

in more simple words

Host = localhost (literally put localhost)
Database name = (cpanelUsername_databaseName)
Database username = (cpanelUsername_databaseUsername)
Database password = (******)

NOTE: When connecting to a database, you need to ensure that:

You've created a database
You've created a database username
You've assigned that user with privileges to your database

Your MySQL connections may use 127.0.0.1 or the IP address of your server, and MySQL will reject the connection if access isn't granted for the specific IP address used.

Verify the permission tables (reloading grants if required) on the server and that you're connecting to

Regrant Preveliges by :

GRANT ALL PRIVILEGES on *.* to 'user'@'IP' IDENTIFIED BY '*UserPass*';

score 0 · Answer 2 · answered Oct 15 '15 at 07:37

0

If your hosting server is Linux,

Change hostname value to localhost

$db['default'] = array(
    'dsn' => '',
    'hostname' => 'localhost',
    'username' => 'user',
    'password' => 'XXXXXXXX',
    'database' => 'mydbname',
    'dbdriver' => 'mysqli',
    'dbprefix' => '',
    'pconnect' => FALSE,
    'db_debug' => TRUE,
    '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 15 '15 at 07:37

Abdulla Nilam

36,589
17
64
85

it works perfectly in localhost. But shows error after uploading my project in hosting site. – Mamun Sabuj Oct 15 '15 at 07:41
what is your hosting provide ?? – Abdulla Nilam Oct 15 '15 at 07:42

score 0 · Answer 3 · edited May 14 '20 at 08:34

0

Yeah, I have solved this problem changing:

$db['default'] = array('dsn' => '','hostname' => 'telihatyhighschool.edu.bd',

to:

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

edited May 14 '20 at 08:34

Nimantha

6,405
6
28
69

answered Oct 15 '15 at 18:27

Mamun Sabuj

189
1
2
6

score 0 · Answer 4 · answered Jun 17 '17 at 10:23

0

I had the same error but all the error are resolved by adding privileges to that user

answered Jun 17 '17 at 10:23

noushad mohammed

375
1
4
20

score 0 · Answer 5 · answered Nov 14 '18 at 08:40

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',
);

score 0 · Answer 6 · edited May 14 '20 at 08:24

0

I resolved this issue by adding a User under Privileges for the database. This User should have the same values as database.php:

'hostname' => 'localhost',
'username' => 'username',
'password' => 'password',

edited May 14 '20 at 08:24

Nimantha

6,405
6
28
69

answered Mar 14 '19 at 09:32

Kanak Sony

1,570
1
21
37

score 0 · Answer 7 · answered Jul 29 '19 at 04:50

SOLVED

create a new database from cpanel
create a new username
assigned that user with privileges to your database
modify file database.php with new information database

public_html/application/config/database.php

export database from your old hosting cpanel - option phpmyadmin
import database to you new hosting cpanel- option phpmyadmin
DONE

score 0 · Answer 8 · answered Apr 12 '20 at 06:34

I had same problem. I had codeigniter project live on my server.

Solution:

In File Manager in codeigniter project public_html/your_project_name/application/config/database.php

I added the password which was missing. [ Password of user when you created it in Cpanel -> MySQL Databases ]

**Make sure you have assigned the database access to this user with all privileges and your configurations in database.php are correct.

Mine are:

$active_group = 'default';
$query_builder = TRUE;

$db['default'] = array(
    'dsn'   => '',
    'hostname' => 'YOUR_DOMAIN_NAME', //Ex- abcd.com
    'username' => 'USER_NAME_HERE',// CREATED IN CPANEL->MySQL Database
    'password' => 'PASSWORD_HERE', // PASSWORD OF ABOVE USER
    'database' => 'YOUR_DB_NAME',
    '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
);

Showing Error: mysqli::real_connect(): (28000/1045): Access denied for user 'user'@'192.188.145.163' (using password: YES)

8 Answers8