LAN access to MariaDB 10 on Synology

GreenwoJ
Posts: 1
Joined: Mon Nov 08, 2021 3:29 am

LAN access to MariaDB 10 on Synology

Post by GreenwoJ »

Hi folks,

I've installed MariaDB 10 on DSM7, along with phpMyAdmin - and it seems to be working fine.

I'm trying to add a login account to access the local database on the NAS from a couple of Windows PCs using ODBC. Google and phpMyAdmin suggest that using a hostname of "%" (wildcard) should allow access from any device - however, it doesn't work!

Screenshot 2021-11-08 080958.png

If I duplicate the wildcard account, and enter a specific IP address, then it works - so permissions and passwords are all correct!

Ideally I'd like to set the hostname as "192.168.1.%' but I'd be happy with "%" if it worked ;)

Anyone got any suggestions?
You do not have the required permissions to view the files attached to this post.
Steve
Posts: 131
Joined: Sun Oct 01, 2017 3:08 pm

Re: LAN access to MariaDB 10 on Synology

Post by Steve »

Sorry for the delayed reply, been a bit busy and traveling. I don't use ODBC to connect to my Synology server's database(s). I do not think Synology offers the MariaDB connector module for ODBC. It's a bit more complicated to install, but you might check this link https://mariadb.com/docs/clients/mariad ... c/install/

As far as host connections, I have about 15 databases in MariaDB and use localhost to connect to all of them. I do not enter an IP address. However I'm using PHP and not ODBC. Since I'm not sure how you're using the database, here is another link on remote client configurations: https://mariadb.com/kb/en/configuring-m ... nt-access/