Cannot connect Xampp server with PHP script

Question

I granted all privileges. This is the script:

<?php
require_once 'login.php';
$conn =  new mysqli($hn, $un, $pw, $db);
if ($conn->connect_error) die($conn->connect_error);
?>

I have this message in the browser:

Warning: mysqli::mysqli(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES) in C:\xampp\htdocs\web-datos\connect_mysql.php on line 11

Access denied for user 'username'@'localhost' (using password: YE

I've tried to connect with no success.

How can I solve this problem?

need to check the values assigned to your username $un and password $pw. Make sure your user you are trying to use is created and the appropriate password is set. — Andrew Nolan
– Andrew Nolan, Commented Jun 13, 2016 at 2:15
Well, i did a mistake with the file login.php with the username just i had to change to 'root' thank you for your advice already solve!!! — Lance Deal
– Lance Deal, Commented Jun 14, 2016 at 2:48

j.Doe · Accepted Answer · 2016-06-13 02:19:31Z

2

i believe you cannot connect to your mysql database. you need to grant access to username@localhost.

grant all privileges on yourdb.* to username@localhost identified by 'password';

if you have not created the user.you can use this command to create new user.

create user 'newuser'@'localhost' identified BY 'password';

you could also possibly type your user or password wrong.please check it

answered Jun 13, 2016 at 2:19

j.Doe

17213 bronze badges

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

1 Comment

Lance Deal Over a year ago

yes you have the righ j.Doe, it was it, and indeed that is the only hard way to learn from our own mistakes thank you.

Collectives™ on Stack Overflow

Cannot connect Xampp server with PHP script

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related