Wamp, PHP MySQL - Connecting error

Question

I've installed a WAMP server. Now I want to connect to a MySQL database using php. I have one problem you need to get the username. This is the code I use. Its from php.net http://php.net/manual/en/mysqli.quickstart.connections.php

<?php
$db_host = "localhost";
$db_username = "root";
$db_password = "password";
$db_name = "test";

$mysqli = new mysqli($db_host, $db_username, $db_password, $db_name);
if ($mysqli->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
echo $mysqli->host_info . "\n";
?>

I get the following error:

Warning: mysqli::mysqli(): in C:\wamp\www\Atletieker\dbconnect.php on line 7 Failed to connect to MySQL: (1045) Accès refusé pour l'utilisateur: 'root'@'@localhost' (mot de passe: OUI)

Warning: main(): Couldn't fetch mysqli in C:\wamp\www\Atletieker\dbconnect.php on line 11

How do I get the username of my database?

Do you have a MySQL server running on where the PHP code is running? — rink.attendant.6
– rink.attendant.6, Commented May 28, 2015 at 14:02
Using WAMP, your hostname should be 'localhost'. (you are connecting to your own machine). This is the case, since you are not getting any connection errors. This error is telling you that you are entering a wrong password. EDIT: I believe the default WAMP MySQL password is 'root', and not 'password'. — Niek van der Steen
– Niek van der Steen, Commented May 28, 2015 at 14:02
@rink.attendant.6 I have a WAMP Server running on my computer. — Roy Berris
– Roy Berris, Commented May 28, 2015 at 14:03
@NiekvanderSteen I have changes the password in the my.ini file — Roy Berris
– Roy Berris, Commented May 28, 2015 at 14:04

OllyBarca · Accepted Answer · 2015-05-28 14:03:44Z

2

Try this...

    $db_host = "127.0.0.1";
    $db_username = "root";
    $db_password = "";
    $db_name = "test";

answered May 28, 2015 at 14:03

OllyBarca

1,5391 gold badge18 silver badges36 bronze badges

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

2 Comments

Roy Berris Over a year ago

I have changed the password in the my.ini file. The problem is the $db_username is not right I think. Because I've put root there

OllyBarca Over a year ago

Make sure to restart MySQL on your server.

Jojo01 · Accepted Answer · 2015-05-28 14:04:39Z

-1

Obviously the $db_password should be empty, if you haven't changed any settings the default password should be blank.

answered May 28, 2015 at 14:04

Jojo01

1,2894 gold badges14 silver badges36 bronze badges

1 Comment

Roy Berris Over a year ago

I have changes the password in the my.ini file

Collectives™ on Stack Overflow

Wamp, PHP MySQL - Connecting error

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related