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.
sorry, i forgot it to mention the server is a UBUNTU x64
Take a look at the database nodes. There is a specific one for connecting to MySQL
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
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...
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.
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.