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!
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?
LAN access to MariaDB 10 on Synology
-
- Posts: 1
- Joined: Mon Nov 08, 2021 3:29 am
LAN access to MariaDB 10 on Synology
You do not have the required permissions to view the files attached to this post.
-
- Posts: 133
- Joined: Sun Oct 01, 2017 3:08 pm
Re: LAN access to MariaDB 10 on Synology
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/
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/