Access denied for user 'root'@'localhost' (using password: YES) using MAMP server

Question

I have a HTML form and I'm using PHP to send the results to an sql database on phpMyAdmin but after submitting I get "Access denied for user 'root'@'localhost' (using password: YES)" error.

This is all hosted locally using MAMP, root@localhost is the only user and I'm sure I've got the right password.

I've looked through similar questions, flushed privileges, created new users, tried logging on through the command line (to which I get the same error) but nothing seems to work.

Here's my code:

$hostname = "localhost";
$username = "root";
$password = "root";
$dbname = "quotetool";

$conn = new mysqli($hostname, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO customerdetails (workstations, servers, firewalls, name, email, phone, support)
VALUES ('$workstations', '$servers', '$firewalls', '$name', '$email', '$phone', '$support')";

if ($conn->query($sql) === TRUE) {
    echo "New record created";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error; 
}
$conn->close();

and here is my user if this helps

Screenshot of my error

You said $password ="root"; but if your database says its YES then why not change your variable to $password="YES"; — Tomm, Oct 03 '17 at 09:45
This error comes when your username or password for connecting with database was wrong. I think your password root doesn't match. — sonam gupta, Oct 03 '17 at 09:46
Password form mamp is generally root by still try blank password. — shashi, Oct 03 '17 at 09:47
@Tomm Just tried that, I get this: Access denied for user 'root'@'localhost' (using password: NO) — Calle, Oct 03 '17 at 09:47
Make sure that you have given **correct username and password** — B. Desai, Oct 03 '17 at 09:51
Please check mysql server is start or not. When mysql server does not start then also we get same error. so please confirm mysql service is start or not. — Abhijit, Oct 03 '17 at 09:52
Try this `$hostname = "127.0.0.1";` instead of this `$hostname = "localhost";` — Rajendran Nadar, Oct 03 '17 at 09:54
@B.Desai I'm sure I have, and I've tried it with different users and passwords but still get the same error. — Calle, Oct 03 '17 at 09:54
Possible duplicate of [MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES)](https://stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw) — Tomm, Oct 03 '17 at 09:54
*I've tried it with different users and passwords* but do you know you have given correct username password? — B. Desai, Oct 03 '17 at 09:56
@RajendranNadar That gives me this: Connection failed: Access denied for user 'root'@'localhost' (using password: YES) — Calle, Oct 03 '17 at 09:56
@B.Desai Yes, whatever changes I make to users I match in PHP with the same results. — Calle, Oct 03 '17 at 09:58
@Calle also make sure that you are changing and testing output of correct file. May be you are changing in other file and then test output — B. Desai, Oct 03 '17 at 10:00
Go to this file to check you credentials `/Applications/MAMP/bin/phpMyAdmin/config.inc.php` just to make sure your values are correct. Somewhere near line no. 84 — Rajendran Nadar, Oct 03 '17 at 10:01
@RajendranNadar Yep, I have this: // MySQL port $cfg['Servers'][$i]['user'] = 'root'; // MySQL user $cfg['Servers'][$i]['password'] = 'root'; — Calle, Oct 03 '17 at 10:03
@RajendranNadar Restarted the server but got the same result — Calle, Oct 03 '17 at 10:07
can you login to the phpmyadmin from a web browser? If you are logged in logout and login again. — Rajendran Nadar, Oct 03 '17 at 10:08
Hi,What is your php version to check php version. Please go to Preferences > PHP and check php version. What is your php version? — Abhijit, Oct 03 '17 at 10:17
you able access to phpmyadmin? please share your error screen short — Abhijit, Oct 03 '17 at 10:27
@Abhijit I can access phpmyadmin but I don't get an error there, only when I run PHP (I've updated my question with a screenshot of that error) — Calle, Oct 03 '17 at 10:36

Rajendran Nadar · Accepted Answer · 2017-10-03T10:57:01.867

Try this code possibly it is because MySql expects Mamp to use port 3306.

$hostname = "localhost";
$username = "root";
$password = "root";
$dbname = "quotetool";
$port = "8889";

$conn = new mysqli($hostname, $username, $password, $dbname, $port);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO customerdetails (workstations, servers, firewalls, name, email, phone, support)
VALUES ('$workstations', '$servers', '$firewalls', '$name', '$email', '$phone', '$support')";

if ($conn->query($sql) === TRUE) {
    echo "New record created";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error; 
}
$conn->close();

Correct syntax

mysqli_connect(host,username,password,dbname,port,socket);

If any issue let me know I will try fixing it.

Amazing, thanks so much. I actually changed $port = "3306"; to $port="8889" as this was the one sql was using but now it works great. Cheers! — Calle, Oct 03 '17 at 10:55

Access denied for user 'root'@'localhost' (using password: YES) using MAMP server

1 Answers1