GitHub

Access denied for user 'root'@'%' to database 'xxxx'

mysql> update mysql.user set Insert_priv='Y',Update_priv='Y',Delete_priv='Y',Create_priv='Y',Drop_priv='Y' where user = 'root' and host = '%'; Query OK, 1 row ...
CCM

PHPmyadmin access denied: for user 'root'@'localhost'

Access can be denied when access to MySQL is attempted through the root user. Root requires insertion of a password and once that is wrongly entered or is not provided, this issue arises.
GitHub

error white running new-site 1045, "Access denied for user 'root'@'localhost' (using password: YES)

on creating site iti ask for MYSQL root password, during installation of MariaDb no password was set, so entering without password raising this error MySQL root ...