Please keep in mind that I am new to KNIME but do have a development background specifically around databases so I should be able to muddle through.
Before anyone asks I have registered the mySQL JDBC driver. :)
I am trying to connect an instance of KNIME on a client PC to a server instance of mySQL with the following error:
ERROR Database Reader Execute failed: java.sql.SQLException: Access denied for user 'Root'@'<pcname>.<domain>.com' (using password: YES)
My database URL is:
jdbc:mysql://<servername>:3306/<databasename>
I changed over to using root to remove any potential permissions conflicts.
It appears that the credentials it is supplying are local to the pc, and not to the server or something similar.
Any ideas from someone who has done this successfully?