Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045): Access denied for user 'root'@'localhost' (using password: YES)

Question

I get this message if i run my register.

<?php
$connection = mysqli_connect('localhost', 'root', 'user'); 
if (!$connection){
    die("Database Connection Failed" . mysqli_error($connection));
}
$select_db = mysqli_select_db($connection, 'test');
if (!$select_db){
    die("Database Selection Failed" . mysqli_error($connection)); 
}
?>

Possible duplicate of ["Connect failed: Access denied for user 'root'@'localhost' (using password: YES)" from php function](https://stackoverflow.com/questions/6445917/connect-failed-access-denied-for-user-rootlocalhost-using-password-yes) — Epodax, Sep 28 '17 at 09:17
@VincentJoeyFermalan the database name is the last parameter, the third is the password, if you don't have it, you pass an empty string! — teeyo, Sep 28 '17 at 09:32
@VincentJoeyFermalan So your database name is "user" and then afterwards you try and select a database...? What — JustCarty, Sep 28 '17 at 09:39

score 1 · Accepted Answer · edited Sep 28 '17 at 09:38

1

Try this if you don't have a password :

$connection = mysqli_connect('localhost', 'root', '', 'test'); 

// OR with a P@$$w0rd

$connection = mysqli_connect('localhost', 'root', 'P@$$w0rd', 'test');

mysqli_connect takes four parameters:

Database host (if this is a local machine that will be "127.0.0.1" or "localhost"
Database username (local machine will be "root")
Database password (local machine will be "")
Database name (this is to save having to call mysqli_select_db)

edited Sep 28 '17 at 09:38

JustCarty

3,839
5
31
51

answered Sep 28 '17 at 09:33

teeyo

3,665
3
22
37

1

Thanks a lot, i already edit the configs in mysql and set the password to ' ' (no password). – Vincent Joey Fermalan Sep 28 '17 at 09:50

Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045): Access denied for user 'root'@'localhost' (using password: YES)

1 Answers1