Knime and MySQL - VPS

KNIME Analytics Platform
1

Hi guys...

 

I have a VPS (Digital Ocean) who i got a MySQL server running...

How i connect my Knime in this database? 

 

Tks...

 

Best regards.

 

2

sorry, i forgot it to mention the server is a UBUNTU x64

3

Take a look at the database nodes. There is a specific one for connecting to MySQL

4

Hi,

to use the MySQL connector you have to install the KNIME Connectors for Common Databases extension which you can find in the KNIME & Extensions categroy of the install dialog. To open the install dialog open KNIME and go to File->Install KNIME Extension.

Bye,

Tobias

5

ERROR MySQL Connector Execute failed: Could not create connection to database: Connection to database 'jdbc:mysql://xxx:xxx/?useOldAliasMetadataBehavior=true' timed out

 

I hide my server port and ip, but i get this error when i tried to connect...

 

How i can fix this...

6

It looks like your database is not reachable under the address. Check if it is running, the hostname and port are correct and whether there is a firewall or proxy involved.

7

the "database reader" node and following configures works for me:

Database Driver: "com.mysql.jdbc.Driver"
Database URL: "jdbc:mysql://***.com:3360/<databasename>
then I put my username and password in the box thereafter.

 

 

 

8