Right so, I have created a set user to access this database - but this user was not able to. I then tested with root, and this too was not able to access the database.
I get the following message when trying to connect:
Could not conenct to MYSQL: Access denied for user ‘root’@‘localhost’ (using password: YES)
Here is my script:<?php # script 8.2 - mysqli_connect.php //This file contains the database access information. //This file also establishes a connection to MYSQL // and selects the database. //Set the database access information as constants: DEFINE ('DB_USER', 'root'); DEFINE ('DB_PASSWORD', '******'); DEFINE ('DB_HOST', 'localhost'); DEFINE ('DB_NAME', 'sitename'); // Make the connection: $dbc = @mysqli_connect (DB_HOST, DB_USER, DB_Password, DB_NAME) OR die('Could not conenct to MYSQL: ' . mysqli_connect_error() ); ?>
Any ideas? please help!.. Thanks!