[tiaderosa]

Hi,
As far as I have understood with the use of profile, among all kind of settings, you can have separate video source and database. So profile 1 has is own video and libraries and profile 2 as well.
In fact the database folders are stored in different  userdata folders.
I'm sorry if the following appears as a dummy question, but I 'm new on kodi and mysql.

What happen if I want to use a mysql common database setup for several istance of kodi ? 
Do I have to implemend two different users in mysql database (ie kodi1 and kodi2) and address the specific user with the related advancedsettings.xml ?

I mean I create user kodi1 and user kodi2 in mysql.
In the advance "videodatabase" settings of profile 1 I put:
  <videodatabase>
    <type>mysql</type>
    <host>HpstIP</host>
    <port>3306</port>
    <user>kodi1</user>
    <pass>kodi</pass>
  </videodatabase> 
In the advance "videodatabase" settings of profile 2 I put:
  <videodatabase>
    <type>mysql</type>
    <host>HpstIP</host>
    <port>3306</port>
    <user>kodi2</user>
    <pass>kodi</pass>
  </videodatabase> 

Is that right ?

Do I need to have kodi1 and kodi2 instead of just kodi as user of mysql database to keep the video separate ?

Many thanks

[beeswax]

If you only change the user in your AdvancedSettings.xml then you'll still be connecting to the same database with the same movie/tv data.

If you want to maintain 2 separate libraries for these users/profiles you'll need to look at the <name> tag on the AdvancedSettings.xml wiki page.  I've never tried that but by simply specifying a different name for the db, kodi will create a separate MySQL database for that user.  Of course, this will double your admin/scraping overhead so you might want to consider just using a skin that supports Smart Playlists (e.g. Aeon Knox Silvo) and customising the skin for each user.  That's the method I went with and now I have profiles for adults/kids which show specific content in Movies/TV but still use a single shared mysql db.

[Klojum]

I'm sorry if the following appears as a dummy question, but I 'm new on kodi and mysql.

Dumb/dummy questions are those questions not asked.
Yes, you can use separate databases for those people(s) who want their own watched statuses. It will however also mean that per profile/database, the video/music source(s) will have to be scraped separately. All profiles can have the same video/music sources, but not necessarily.

In fact the database folders are stored in different  userdata folders.

Each profile has its own "root" folder, which includes a 'userdata/Database' folder, but that is for local SQLite databases.
A profile will have its own advancedsettings.xml file, which will point to the database server with its own user settings.

Do I need to have kodi1 and kodi2 instead of just kodi as user of mysql database to keep the video separate ?

Technically no, you don't need separate logins per database, but security-wise it is recommended (which also goes for their passwords).

[tiaderosa]

Thank you Both for your hints!
I'll try and come back should I have hard times