Category: Apple TV4

Connection MrMC (ATV4) with MySQL database

First export your local database

  • Export your library as a single file to a network location

Setup MySQL Database

  • First SSH into your Synology
ssh root@ipsynology
  • Connect to the database.
mysql -u root -p

Specify MySQL user with -u option. If the user has a password add the -p option. Enter the password used during MySQL configuration when prompted.

  • Create a new database user.
CREATE USER 'mrmc' IDENTIFIED BY '*****';

Username is defined with CREATE USER statement while the password is specified with IDENTIFIED BY statement.

  • Grant permissions on video and music databases to the new user.
GRANT ALL ON `MyVideos%`.* TO 'mrmc';
GRANT ALL ON `MyMusic%`.* TO 'mrmc';

All possible permissions are granted with GRANT ALL ON statement to both Kodi video and music databases. User that is being granted permissions is specified with the TOstatement.

  • Exit the database command line tool.
quit
  • Enable the MySQL and your library will be empty
  • Import your previously exported database in the MySQL database
  • Now connect your other MrMc installations with the MySQL database and everything will be synced