MariaDB : Access denied for user 'root'@'localhost'

Originally published at: MariaDB : Access denied for user 'root'@'localhost' - RDR-IT

Just after installing MariaDB on Ubuntu / Debian, this error may appear if you try to connect with phpMyadmin. To solve / work around the problem, we will create another user with the same level of rights as root. 1. Open an SSH connection on the server. 2. Enter the following commands: mysql CREATE USER…