mariadb mysqli::real_connect(): (HY000/1698): Access denied for user 'root'@'localhost' code example

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

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