CREATE USER with Specified Subnet

Post your questions about Web Server usage and Apache + PHP + MySQL/SQLite web applications.
Post Reply
themos2311
Starting out
Posts: 21
Joined: Mon Jun 06, 2022 4:48 am

CREATE USER with Specified Subnet

Post by themos2311 »

I have two Kodi devices, TV and PC, connecting with a user account in MariaDB10 with the hostname being %. Works great.

I read that giving such blanket access is not best and it would be good to limit it to one's local LAN. Sounds good.

I have created this same username in phpMyAdmin with my local subnet of 192.168.100.% and via command line which also displayed the hostname in phpMyAdmin as 192.168.100.%.

But Kodi is not being allowed in apparently. It no longer can read the database hence I think it is not connecting.

I tried even being more specific by changing the last octet to the PC's IP address. Same problem.

As soon as I change the hostname back to %, Kodi on my PC pulls up the data properly from the MariaDB10 database.

Does setting a subnet or specific IP with a user not work in a home environment?
Post Reply

Return to “Web Server & Applications (Apache + PHP + MySQL / SQLite)”