Hi all, I already posted this in the "official" Synology Community but would also like to post it here because this forum seems more active than the "official" one.
I would like to connect do MariaDB using a SSH tunnel. In DSM I have an account "frank" with full administrator rights. For security reasons I have disabled the accounts admin and guest as a standard practice.
The database client I use is called Navicat for MySQL but the problem seems to be universal to all clients.
For security reasons I would not like to use the user admin but the user frank. Is this possible or should I compromise security and use the user admin and hope for the best? Best solution I think would be to use the user frank and keep the user admin disabled.
What do people think of this topic?
Please excuse me if I started a discussion that was already on this forum. I used the search function extensively and was not able to find anything.
I would like to connect do MariaDB using a SSH tunnel. In DSM I have an account "frank" with full administrator rights. For security reasons I have disabled the accounts admin and guest as a standard practice.
The database client I use is called Navicat for MySQL but the problem seems to be universal to all clients.
- Create SSH Tunnel using user frank.
- SSH Tunnel is working!
- Connect to 127.0.0.1 port 3306 to connect to MariaDB running on the Synology NAS.
- Not getting any response from the database.
- Create SSH Tunnel using User admin.
- SSH Tunnel is working!
- Connect to 127.0.0.1 port 3306 to connect to MariaDB running on the Synology NAS.
- Able to connect to the database.
For security reasons I would not like to use the user admin but the user frank. Is this possible or should I compromise security and use the user admin and hope for the best? Best solution I think would be to use the user frank and keep the user admin disabled.
What do people think of this topic?
Please excuse me if I started a discussion that was already on this forum. I used the search function extensively and was not able to find anything.