Connecting MariaDB on MySQL Workbench

By default MariaDB only allows localhost connection,To allow remote access to MariaDB…

sudo nano /etc/mysql/my.cnf

comment out bind-address

sudo service mysql restart

login mariaDB as root user

~$ mysql -uroot -pYourMariaDBrootPassword

grant privileges

MariaDB [(none)]>GRANT ALL PRIVILEGES ON . TO ‘root’@‘%’ IDENTIFIED BY ‘YourMariaDBrootPassword’ WITH GRANT OPTION;

in mysqlbench login as root