Grant all privileges nightmare on MariaDB street

MySQL

Getting the error below?

> GRANT ALL PRIVILEGES ON whmcs.* TO 'whmcs'@'localhost';
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'whmcs'

Log in as root then run this sequence to see why you're having a hard time:

MariaDB [(none)]> select current_user();
+----------------+
| current_user() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.000 sec)

MariaDB [(none)]> SHOW GRANTS FOR 'root'@'localhost';
+---------------------------------------------------+
| Grants for root@localhost                         |
+---------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO `root`@`localhost` |
+---------------------------------------------------+
1 row in set (0.000 sec)

MariaDB [(none)]> SELECT Host, User, Grant_priv, Super_priv FROM mysql.user WHERE User = 'root';
+-----------+------+------------+------------+
| Host      | User | Grant_priv | Super_priv |
+-----------+------+------------+------------+
| localhost | root | N          | Y          |
+-----------+------+------------+------------+
1 row in set (0.002 sec)