MrMC

I'm attempting to set up MySQL under the settings menu, and keep getting the error: "Couldn't Open Database: Failed to set the new configuration. Please check your settings." every time I click 'enable'.

10.0.0.18 (Apple-TV 4): MrMc Services Settings

Server: 10.0.0.10
Port: 3306
Username: mrmc
Password: mrmc
Define video database name: mrmc
Define Music database name: music

10.0.0.10: /etc/my.conf

bind-address = 0.0.0.0

10.0.0.10: MySQL commands

create database mrmc;
create database music;
GRANT ALL PRIVILEGES ON mrmc.* To 'mrmc'@'10.0.0.18' IDENTIFIED BY 'mrmc';
GRANT ALL PRIVILEGES ON music.* To 'mrmc'@'10.0.0.18' IDENTIFIED BY 'mrmc';
flush privileges;

iptables is not dropping connections.. Am I missing something obvious?

Thank you @amet & @davilla for troubleshooting with me!

The correct MySQL commands are:

drop database mrmc;
drop database music;
GRANT ALL PRIVILEGES ON `mrmc%.*` To 'mrmc'@'10.0.0.18' IDENTIFIED BY 'mrmc';
GRANT ALL PRIVILEGES ON `music%.*` To 'mrmc'@'10.0.0.18' IDENTIFIED BY 'mrmc';
flush privileges;

I needed to drop the databases that I created and grant permissions to the tables: `mrmc%.*` and `music%.*` using the backticks. @amet let me know that MrMC concatenates the version numbers to the table names. Including the wildcard character '%' did the trick. Also, once done issuing the commands on the MySQLd granting permissions, allow MrMC to create the databases for you.

Of course, don't forget that after setting up the database, you have to go back to: Videos - Files - [all of your existing added directories] and change content. Highlight the appropriate share, hold down the top button on the AT4 remote, and select 'Change content'. Adjust as necessary.

I am no database admin, so I have no Idea what I am doing wrong. Do I need to create tables and junk to make this work or does MrMC create them for me? I have tried the examples above and I keep getting the error:

The following errors were reported:
No database selected
No database selected

I am using this:

GRANT ALL PRIVILEGES ON `mrmc%.*` To 'mrmc' IDENTIFIED BY 'mrmc';
GRANT ALL PRIVILEGES ON `music%.*` To 'mrmc' IDENTIFIED BY 'mrmc';
flush privileges;

Was I supposed to make the mrmc and music databases?

I am trying to do this on my QNAP NAS with MySQL 5.5.44