Can access mysql database using terminal, but I get "access denied" message when using php

Question

When logging into mysql in my terminal, everything works expected. But when I run my webpage with

$conn = new mysqli("localhost", "root", "password");
if($conn->connect_error) {
   die("connection failed: " . $conn->connect_error);
}
echo "connected successfully";

I get "connection failed: Access denied for user 'root'@'localhost' (using password: YES)". I have tried resetting the root password. I have tried granting all permissions to root. I am absolutely positive that I am entering my username and password correctly in the php file.

I'm running a LAMP server on an Ubuntu 14.04 machine. I have php 5.5.9, mysql 5.5.40, and apache 2.4.7.

Can anyone help?

what happens if you try 127.0.0.1 or the machine's local IP address ex, 192.168.1.25 instead of localhost? — Yazan
– Yazan, Commented Dec 29, 2014 at 8:45
add database name which you are trying to connect in 4th parameter $conn = new mysqli("localhost", "root", "password","DB_NAME"); — tzafar
– tzafar, Commented Dec 29, 2014 at 8:49

Koen Wesselman · Accepted Answer · 2014-12-29 10:20:04Z

2

PHP requires you to fill in the username, password and database name for the database you are trying to connect to: http://php.net/manual/en/function.mysql-connect.php

$conn = new mysqli("localhost", "root", "password", "database");

answered Dec 29, 2014 at 10:20

Koen Wesselman

1981 silver badge12 bronze badges

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

6 Comments

c0lon Over a year ago

I've tried this; it still doesn't work. I get the same results.

Koen Wesselman Over a year ago

Are you sure the database is hosted on the same server as the webserver? Try filling in the IP you use when logging in through the terminal in the PHP file, instead of localhost.. Make sure you also use the code above with the database name

c0lon Over a year ago

I'm doing all of this locally. I have everything installed and running from the same machine. I just got a mechanical keyboard and I'm just doing some web stuff for fun.

Koen Wesselman Over a year ago

Ah okay, did you restart MySQL after resetting/changing your password?

c0lon Over a year ago

Yes. I ran sudo service mysql restart

|

Qingfeng · Accepted Answer · 2014-12-29 11:55:28Z

0

Try mysqli_connect_errno()

$conn = new mysqli("localhost", "root", "password");
if(mysqli_connect_error()) {
   die("connection failed: " . mysqli_connect_error());
}
echo "connected successfully";

Checkout Manual:

connect_error

Warning The mysqli->connect_error property only works properly as of PHP versions 5.2.9 and 5.3.0. Use the mysqli_connect_error() function if compatibility with earlier PHP versions is required.

answered Dec 29, 2014 at 11:55

Qingfeng

7304 silver badges19 bronze badges

1 Comment

c0lon Over a year ago

This produces the same results as my original code.

Collectives™ on Stack Overflow

Can access mysql database using terminal, but I get "access denied" message when using php

2 Answers 2

6 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related