Tailscale, Mariadb, Synology NAS and mysql clients they don't like each other. Help

Synology
1

Well I have a MariaDB database set up on a recently purchased D923+. I’ve set up Tailscale and it’s working fine except when trying to connect to my database using various client software (MySQL Workbench and an iOS app called MySQL Mobile Client). I just keep getting the error: “Access denied for user ‘username’@‘localhost’ (using password: YES)”

Can’t figure this thing out for anything. I believe I have my users setup correctly. Tailscale is working as I can get to the NAS remotely with no problems. Just can’t get this connection to the database working. FYI I don’t have SSL/TSL running. Don’t know if that would make a difference.

I scoured the internet and found nothing.

Any help would be appreciated. Thanks.

2

I see this is a tough one, even for the pros. lol. If I get this working I’ll post here what the solution is.

3

Solved the problem. Had nothing to do with the above mentioned. Was totally user error on my part. Matter of user tables and databases. Everything working like a charm.

4

Thank you for reporting back.