MySQL Woes
Posted: 03 Jun 2017, 07:50
MrMC for iOS 3.05
MySQL Server hosted on a Mac Mini
I've been using a shared library via MySQL for many years. When I installed MrMC on my three ATV4s all I did was complete the MySQL client section with:
Server: 192.168.0.75
Port: 3306
Username: XBMC
Password: XBMC
And, it worked like a charm every time.
Today I installed MrMC on my iPad and made the same exact entries, but I get lots of this sort of error in the log:
No idea where the 'mpad' came from. The iPad's name is MGNpad
Here's what the grants for user xbmc look like in MySQL:
I've read the two references in the "[How-to] MySQL database" post, but I don't understand them well enough to know what to do.
Why did this work fine on all the ATV4s, but not the iPad?
MySQL Server hosted on a Mac Mini
I've been using a shared library via MySQL for many years. When I installed MrMC on my three ATV4s all I did was complete the MySQL client section with:
Server: 192.168.0.75
Port: 3306
Username: XBMC
Password: XBMC
And, it worked like a charm every time.
Today I installed MrMC on my iPad and made the same exact entries, but I get lots of this sort of error in the log:
Code: Select all
14:40:12 T:6141079552 ERROR: Unable to open database: MyVideos76 [1045](Access denied for user 'XBMC'@'mpad' (using password: YES))
14:40:12 T:6141079552 ERROR: Unable to open database: MyVideos75 [1045](Access denied for user 'XBMC'@'mpad' (using password: YES))
14:40:12 T:6141079552 ERROR: Unable to open database: MyVideos107 [1045](Access denied for user 'XBMC'@'mpad' (using password: YES))
Here's what the grants for user xbmc look like in MySQL:
Code: Select all
mysql> show grants for 'xbmc';
+--------------------------------------------------------------------------------------------------------------+
| Grants for xbmc@% |
+--------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@'%' IDENTIFIED BY PASSWORD '*EC4F5173DE994BFEAB7040A4A32B4ED6DE26F6F0' |
+--------------------------------------------------------------------------------------------------------------+
Why did this work fine on all the ATV4s, but not the iPad?