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 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
I was able to solve the problem, by:
SSH login an Synology Server.
add file: my.cnf
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’;
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:
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.