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?
CREATE USER with Specified Subnet
Post your questions about Web Server usage and Apache + PHP + MySQL/SQLite web applications.
-
- Starting out
- Posts: 21
- Joined: Mon Jun 06, 2022 4:48 am
Return to “Web Server & Applications (Apache + PHP + MySQL / SQLite)”
Jump to
- QNAP General
- ↳ Announcements
- ↳ Features Wanted
- ↳ Users' Corner
- ↳ Official Apps
- ↳ Prestashop
- ↳ Webalizer
- ↳ Virtualization Station
- ↳ Notes Station
- ↳ SocialLink Station
- ↳ McAfee Antivirus
- ↳ IT Management Station
- ↳ Container Station
- ↳ Qsirch & Qfiling
- ↳ Community Apps
- ↳ Apps Wanted
- ↳ Partner Apps
- ↳ BitTorrent Sync
- ↳ EZPhone
- ↳ Plex Media Server
- ↳ Ragic
- ↳ Tonido
- Getting Started
- ↳ Frequently Asked Questions
- ↳ Presales
- ↳ Turbo Station Installation & Setup
- General
- ↳ Hardware & Software Compatibility
- ↳ HDD Spin Down (HDD Standby)
- ↳ Seagate Drive Discussion
- ↳ Western Digital Drive Discussion
- ↳ File Sharing
- ↳ Mac OS
- ↳ Linux & Unix (NFS)
- ↳ Windows
- ↳ Backup & Restore
- ↳ Symform
- ↳ Microsoft Azure
- ↳ OpenStack Swift
- ↳ Amazon Glacier
- ↳ Amazon S3
- ↳ WebDAV-based Backup
- ↳ Google Cloud Storage
- ↳ Object Storage Server
- ↳ ElephantDrive
- ↳ Xopero
- ↳ System & Disk Volume Management
- ↳ Web Server & Applications (Apache + PHP + MySQL / SQLite)
- ↳ Download Station and QGet
- ↳ myQNAPcloud service
- ↳ Surveillance Solution
- ↳ Miscellaneous
- ↳ QIoT
- ↳ QuAI
- ↳ QVR Face
- Business
- ↳ Windows Domain & Active Directory
- ↳ iSCSI – Target & Virtual Disk
- ↳ Remote Replication/ Disaster Recovery
- ↳ Server Virtualization & Clustering
- ↳ NAS Management
- ↳ QES Operating System (QNAP Enterprise Storage OS)
- Multimedia
- ↳ Photo Station, Music Station, Video Station
- ↳ Media Streaming
- ↳ Mobile Devices