Connection to mariaDB on Synology Server

[dgoebel]

I can’t establish a connection to mariaDB on Synology Server using Database Connector.
Database URL is jdbc:mysql:192.168.179.12:3307/knime
Database Driver: com.mysql.jdbc.Driver
Message is:
message from server: “Host ‘192.168.179.19’ is not allowed to connect to this MariaDB server”

Port 3307 is open for mariaDB10; same result for 3306 (mariaDB5).
I’ve also added mariadb-java-client-2.4.2.jar to settings/Databases but this didn’t help.

The mariaDB on my Synology works fine because it runs amongst other things two websites.

Thanks for help
Dieter

[dgoebel]

I was able to solve the problem, by:
SSH login an Synology Server.

1st Step
add file: my.cnf
/var/packages/MariaDB/etc/my.cnf
[mysqld]
skip-networking=0
skip-bind-address
see: https://www.synology.com/en-us/knowledgebase/DSM/tutorial/Service_Application/Can_MariaDB_settings_be_customized_on_Synology_NAS

2nd Step
Enter mariaDB by: dieterg$ mysql --host=IP-Address -u root -p
Grant localhost access to Server:
GRANT ALL PRIVILEGES ON . TO ‘root’@‘Localhost-IP’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;
Check user by: SELECT User, Host FROM mysql.user WHERE Host <> ‘localhost’;

3rd Step
Then I added the database reader node and added SQL statement to check:
SELECT User, Host FROM mysql.user WHERE Host <> ‘localhost’
and got the user list

knime database connector:
Driver: com.mysql.jdbc.Driver
URL: jdbc:mysql://Server-IP:PORT/database-name