after reinstalling osmc, i also upgraded my synology DSM to 7.0, so Im using mariadb10 instead of 5 now. Since I wanted to begin from scratch anyway, I deleted my old database and created a new user with all priviliges on mariadb10 and included the credentials inside MY OSMC. Unfortunately, whenever I want to play a video, the system crashes with a sad face.
Did you configure the user access from all hosts? 2021-11-28 15:41:27.492 T:2934 ERROR <general>: Unable to open database: kodi_video119 (Access denied for user 'kodi'@'osmc.fritz.box' (using password: YES))
If I remember correctly, when setting up my mariadb 5 db years ago I just created the new username, granted all priviliges when doing so and entered the credentials in the advancedsettings. Im kinda lost now what you mean and where to set this up =)
password is correct, triple checked it and global privileges are set for the username, yes.
a database itself doesnt exist so far, isnt the username supposed to create it by itself with all rights granted? Thats how it worked on mariadb5. Like I said, I never configured anything except the username there