Changing Databse to MYSQL

[inuonly]

Steps to reproduce

1. I tired to change Database from sqlite to mysql but it is not working.
2. Then I manually edited the appsettings.json file and changed "DBProvider" to sqlite and it started working again. So figured out that the SQL settings somehow need to be changed in order to use dbprovider.
3. So now I changed my connection string "SQLServer" value to "Server=mariadb;Database=remotely;Trusted_Connection=True;MultipleActiveResultSets=true"
   Reference : mariadb is hostname of container which is accessible to other containers being on same network which I made sure to assign to as tht works with sqlite (default).
4. Now again if I change provider SQLServer then it does not work, also there is no option to give username or password for databse, i created already for remotely.

Help Needed: I need a sample or example to coorect way of changing SQL string in the settings which I could not find anywhere in the readme section nor in the links provided.

I assuem I am doing something wrong here so not adding this as issue but in discussion so that someone can hlep BUT
It will be really great to see dbprovider settings in docker compose options or at least a sample file as an example included in rteadme section so that we refer tht to setup mysql db for remotely.

Thank you in advance and sorry for any mistakes or bothering.

Have a good one ahead.