MSQL password is working when login from MySQL console but same password is not working when trying to connect DB from PHP code

Question

Here is my code which I am using to connect my database. My credentials are perfectly working when directly login with MySQL console but the same is not working when trying to connect DB from my PHP code.

Error ;PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user

    /* Attempt MySQL server connection. Assuming you are running MySQL
    server with default setting (user 'root' with no password) */
    $servername = 'localhost';
    $db_name = 'HappaningsDb';
    $username = 'SIDSAHU3';
    $password = 'sid';
    $conn =null;

    //$link = new PDO("mysql:host=$servername;dbname=$db_name", $username, $password);
    //  $link->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $link = mysqli_connect($servername, $username, $password, $db_name);

   // Check connection
   if($link == false){
   die("ERROR: Could not connect. " . mysqli_connect_error());
   }

   // Attempt insert query execution
   $sql = "insert into Question_data(QUESTION_ENG,OP_ENG, TOPIC_ID, CAT_ID, IS_PREMIUM, IS_HIN, 
   QUESTION_HIN ,OP_HIN, ANSWER, CREATE_USER,CREATE_DT,UPDATE_USER, UPDATE_DT)values('hsdvhbsvsvk', 
   'dhvjd','1','1','N','N','','','2','sid',curdate(),'','');";
   if(mysqli_query($link, $sql)){
   echo "Records added successfully.";
   } else{
   echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
   }

  // Close connection
   mysqli_close($link);

Please find attached screenshot:

PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user.. This is the error which i am getting also i have attached the screenshot — Siddharth Sahu, May 16 '20 at 14:18
It is a very bad idea to use `mysqli_error($conn);` in your code, because it could potentially leak sensitive information. See this post for more explanation: [mysqli or die, does it have to die?](https://stackoverflow.com/a/15320411/1839439) — Dharman, May 16 '20 at 15:00
You may have created a user in one database and connecting to another — Your Common Sense, May 16 '20 at 15:10
thank you for the info , but this is my dummy code where i am trying to connect DB but getting Access denied error. — Siddharth Sahu, May 16 '20 at 15:11
I have created the user with in PHP mysql and not in external Mysql :( — Siddharth Sahu, May 16 '20 at 15:12

score -1 · Answer 1 · answered May 16 '20 at 14:40

-1

User SIDSAHU3 could be restricted to Local host

From your CLI, try creating user with %

CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';
GRANT ALL ON *.* TO 'myuser'@'%';

answered May 16 '20 at 14:40

Ganesh Chandrasekaran

1,578
12
17

As suggested, i have created the new user with % host .. now i a getting below error mysqli_connect(): php_network_getaddresses: getaddrinfo failed: No such host is known. in – Siddharth Sahu May 16 '20 at 14:59
$servername = '%'; $db_name = 'HappaningsDb'; $username = 'SIDSAHU7'; $password = 'sid12345'; $conn =null; //$link = new PDO("mysql:host=$servername;dbname=$db_name", $username, $password); // $link->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $link = mysqli_connect($servername, $username, $password, $db_name); – Siddharth Sahu May 16 '20 at 15:00
Server Name = localhost or name of the server. – Ganesh Chandrasekaran May 16 '20 at 15:04
i have tried that as well but still getting the same error. :( – Siddharth Sahu May 16 '20 at 15:09
To isolate its nothing to do with PDO can you try with MySQLi connect_error) { die("Connection failed: " . $conn->connect_error); } echo "Connected successfully"; ?> https://www.w3schools.com/php/php_mysql_connect.asp – Ganesh Chandrasekaran May 16 '20 at 15:18
@siddharthsahu did the solution mentioned on top of the page worked ? – Ganesh Chandrasekaran May 16 '20 at 16:48
no it is not working – Siddharth Sahu May 16 '20 at 17:04

MSQL password is working when login from MySQL console but same password is not working when trying to connect DB from PHP code

1 Answers1