mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'197.62.68.163' (using password: YES) 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');