New mysqli connection is not working in My Cpanel but works in my computer

Question

php code which is functioning very well in my computer but whenever i am uploading my files to my Cpanel not working receiving this error message:

Warning: mysqli::mysqli() [mysqli.mysqli]: (42000/1044): Access denied for user '*****'@'localhost' to database '*****' in /home/*****/public_html/Admin Panel/db.php on line 3 Unable to connect to database [Access denied for user '*****'@'localhost' to database '*****']

My username and password both are 100% correct but i don't know why i am receiving this.

<?php
    $connection=new mysqli('localhost', 'CpanelName_username', 'test.123', 'CpanelName_DB');
    if($connection->connect_errno > 0){
        die('Unable to connect to database [' . $connection->connect_error . ']');
    }
?>

The error message clearly says that you have provided wrong credential for connecting to your mysql server. — Yogesh Suthar, May 13 '13 at 05:01
You have to provide your cpanel hostname,username,password,database and also check whether the user has privilege to connect to that database or not. — Yogesh Suthar, May 13 '13 at 05:06
Array ( [0] => INSERT command denied to user '*****'@'localhost' for table 'students' ) "Sorry Qurery Failed" i got this error massgae even i checked all of them. — Shah Jeee, May 13 '13 at 05:23

score 1 · Answer 1 · answered May 13 '13 at 09:13

1

Check if localhost should be used.

Many shared hosting providers may not have database on the same machine. So check the database hostname and change accordingly.

answered May 13 '13 at 09:13

Pruthvi Raj Nadimpalli

1,335
1
15
30

New mysqli connection is not working in My Cpanel but works in my computer

1 Answers1