mysqli_real_connect(): (HY000/1045): Access denied for code example

Example 1: mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'

ALTER USER 'root'@'localhost' IDENTIFIED BY 'mysql';

Example 2: mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)

// Connect to mysqli database

$connection = mysqli_connect('localhost', 'root', '', 'test'); 

// OR with a P@$$w0rd

$connection = mysqli_connect('localhost', 'root', 'P@$$w0rd', 'test');

Example 3: php catch mysqli_connect(): (HY000/1045): Access denied

$conn = mysqli_connect( '<server>', '<username>', '<password>',  '<database-name>');
if (!$conn) {
  // whatever processing you want to do upon error in connection
  // like log error or send an email to admin
  // I am just printing the error at the moment.
  echo mysqli_connect_errno() . ":" . mysqli_connect_error();
  exit;
}

Tags:

Php Example