Connectivity with mySQL

PHP
1

I am using the following code for connectivity with the mySQL:

<?php

$servername = "localhost";
$username = "username";
$password = "password";

// Create connection
$conn = new mysqli($servername, $username, $password);
 
// Check connection
if ($conn->connect_error) {
    die("Custom message - Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>

But, in return, I receive the following Error message:

Connection failed: Access denied for user ‘username’@‘localhost’ (using password: YES)

Would anybody help to a novice!

Thanks in anticipation and regards.

1 Like
2

Just checking - are ‘username’ and ‘password’ really your username and password for your database?

3

Thanks for the response. In my mind, I am creating a NEW database with the provided credentials. If I am wrong, please suggest.
Thanks.

4

Where were the credentials provided?

Are you using phpmyadmin on your local computer? If so, check out the users that are set up there.

5

Yes, you are wrong.

new mysqli means “to create a new PHP class instance” that have to be connected to database using existing account credentials.

6

Yes, I M running the code on my local PC and I have installed Webmatrix + PHP + sqlServer on the same machine. I am providing just the fictitious username & password to test my skill :-)smiley:

7

Sorry, Mr. colshrapnel. It means, I just misunderstood. Would U kindly suggest me the correct statement for creating a new database!

Raabi

8

You need to create the database in phpMyAdmin.

9

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.