Mysql Problems

I have a Synology NAS. I’m running phpmyadmin with mariabd. I currently use OSMC versions of Kodi on several Raspberry Pi version 3 throughout my house. I used my main Kodi osmc to create a mysql database on the Synology by adding sources by doing the following:

In the OSMC network options, i filled out the Video and Music database information:

Name
IP adress
Port
User
Password

I then rebooted and added sources.

I logged into my NAS and ran phpmyadmin. I can see the database that was created for videos and music.

I am now trying to utilize the mysql database on my other OSMC Raspberry Pi devices, but I am running into problems. Im a novice at this stuff, so tech language will be confusing.

If someone can give me step by step instructions, it would be appreciated.

I tried adding the same info in the other Pi network menu, to no avail. I am lost as to what i need to do.

I read where i need to copy my advancedsettings.xml file, but how do you even do that.