Hi @RIchardC , also, from MySQL workbench, once you are connected, can you run this: select user();
And also run this: select User, Host from mysql.user where User = 'remote';
The first query will show what your current user and host are, and the second query will show what users you have as ‘remote’ and for what hosts you have them.
Just want to see if you are actually connecting as 'remote'@'Richard.localdomain' when connecting via MySQL Workbench.
Hi @RIchardC , MySQL (therefore MariaDB also) restrict users by IP/Host, so the commands I gave you were to verify if you were connecting from the same IP/Host from Knime and Workbench, which from the results you provided, seems to be the case, and regardless, the “remote” user is created with Host “%”, which is a wildcard, meaning this user can connect from any Host.
So, the user access to your MySQL system does not seem to be the problem.
While I understand that you are switching to another DB system, you should still try to figure out why this is not working in case you need to connect to MySQL in the future.
If you are still interested, the only thing that I can think of is the access to the database “rss” that could be an issue (In Knime you specify the db name “rss” while you do not connect to any specific db).
Connecting again via Workbench, can you run these commands? use rss; show tables;
And also this command to show the permissions of the user “remote”: show grants for 'remote'@'%';