Unable to connect to MariaDB using DBeaver
As it turns out, this is expected behaviour for MariaDB and MySQL. To overcome the issue, it is advisable to create a separate user and grant access to all databases created. Here is a step by step guide on how to create databases using the command line and grant permissions to the user of your choice.
Log in to MariaDB/MySQL
$ sudo mysql -u root -pCreate a database
mysql> CREATE DATABASE `database_name`;Create a user
mysql> CREATE USER 'user_name' IDENTIFIED BY 'a_secure_password';Grant user permissions
mysql> GRANT ALL PRIVILEGES ON database_name.* TO 'user_name'@'%' WITH GRANT OPTION;Apply changes
mysql> FLUSH PRIVILEGES;