I tried all the combinations with and without "persistsecurityinfo" "characterset"server=MYNAS.local;database=MYDB;user id=root;password=MYPASSWORD;persistsecurityinfo=True;characterset=utf8
I always get the same error:
I suppose the problem is caused by the authentication method, but I have no idea how to change the authentication method on client side, neither how to add authentication methods to the NAS.Authentication to host 'MYNAS.local' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'192.168.1.23' to database 'MYDB'
Being HeidiSQL able to connect, it means that is possible to change the authentication method.
Can anybody help me?