New User with Global Privileges Cannot Create a Kodi Database

Kodi connects to a MariaDB currently in my environment with root. When Kodi first launches, it creates a new MyVideos database in MariaDB based on the information in my advancedsettings.xml.

Best practice says I should create a different user with global privileges and not use root. I have tried this numerous times, with the new user displayed under User Manager in HeidiSQL. It has both localhost and % (two accounts respectively). I used User Manager in Heidisql to create the new user.

In every case, Kodi with this new user account cannot connect to the MariaDB. As soon as I switch it back to root, it works. What am I missing?

When Kodi cannot connect with that new user, you should find the error message returned by MariaDB. The error is mostly very helpful for solving the issue. If it's "access denied" for example this is apparently a password problem, or a typo. But there are others, for instance "host xyz is not allowed" or similar.

Thank you for your response. It is working now; not sure what I did differently except not using the new user account I created yesterday, today. After your response, I changed the advancedsettings.xml with the account I created yesterday and a Christmas miracle, it worked! LOL right.