Could Not Connect To Mysql

[Juan]

Hi there,

In Chapter 8, Using PHP with MySQL, I get this answer:

Could not connect to MySQL: Access denied for user 'username'@'localhost' (using password: YES)

after clicking on the 'View Users' tab. Can anyone help me?

[HartleySan]

Most likely your mysqli_connect function call code is incorrect.

If you don't mind, please post the relevant code (and remove/mask your real login info within the function call so we don't see it).

Thanks.

[Juan]

Hi,

Here's the mysqli_connect.php file code:

 

<?php # Script 8.2 - mysqli_connect.php
DEFINE ('DB_USER', 'username');
DEFINE ('DB_PASSWORD', 'password');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'sitename');
$dbc = @mysqli_connect (DB_HOST, DB_USER, DB_PASSWORD, DB_NAME) OR die ('Could not connect to MySQL: ' . mysqli_connect_error() );
?>

 

I get the same answer after trying to register a user via the register form. Maybe it is something wrong with MySQL connection...

[Larry]

Have you created a "username" user with a "password" password in MySQL?

[HartleySan]

Is your user name actually "username"?

Is your password actually "password"?

If not, then you need to fill in the actual values.

Note that those values are meant to serve as placeholders, not be the actual values.

[Juan]

There is the sitename database with 12 user examples from chapter 5.

[Juan]

Yeah, I've got it.

I didn't create a user with a 'password' in MySQL, so that was it.

Thank you so much!