Issue connecting to MySQL from PHP

[Mudloop]

Hi,

I created a database and a user.
Database name is admin_wp (entered wp), username is the same.
Password is xyz (not really :) )

Then I do this :
$db = new mysqli('localhost', 'admin_wp', 'admin_wp', 'xyz');

And I get this error :
Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'admin_wp'@'localhost' (using password: YES) in ...

Am I supposed to use a different user? I can access phpymyadmin with this user, so I don't know what I'm doing wrong.

Thanks!

[Mudloop]

Also, I tried this :
mysql -u admin_wp -p

And that worked. So no idea why it's not working from my simple PHP script.

[Mudloop]

Tried making a new user :

Code: Select all

grant all on admin_wp.* to 'web'@'%' identified by 'c3cg5yTqXNsJzcq9';

(don't worry, it's a temp password)

Code: Select all

+---------------+-----------+
| user          | host      |
+---------------+-----------+
| admin_default | %         |
| admin_wp      | %         |
| web           | %         |
| web           | 127.0.0.1 |
| admin_default | localhost |
| admin_wp      | localhost |
| phpmyadmin    | localhost |
| root          | localhost |
| roundcube     | localhost |
| web           | localhost |
+---------------+-----------+

(note, made it a couple of times with different host but same password)

Code: Select all

$db = new mysqli('127.0.0.1', 'web', 'admin_wp', 'c3cg5yTqXNsJzcq9');

Result :
Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'web'@'localhost' (using password: YES)

[grayfolk]

Result :
Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'web'@'localhost' (using password: YES)

Due to official documentation looks like youre wrong with arguments order.

[nbaever3]

i got same problem

[grayfolk]

i got same problem

Check your database credentials, check arguments order.

[clementishutin]

Did the issue resolved after looking into database?