[digiKam-users] What are correct permissions for /var/lib/mysql?

[Steven Gaffagan]

Greetings,

Installed digikam in Arch Linux. Set up mariadb and got it running. I am 
trying to use the internal server option for mariadb. However, when I 
launched digikam I received:

An error occurred during the internal server start.
Details: Cannot create directory /var/lib/mysql/.mysql.digikam/db_data

I went back and created that: sudo /usr/bin/mysqld_safe 
--datadir='/var/lib/mysql/.mysql.digikam/db_data'

Still received same error message.

The owner and group of the file were mysql. Changing permissions: sudo 
chmod 777 -R mysql/ allowed digikam to launch without error.

I searched the last 4 months of the mailing list and didn't see a post 
on permissions. Also, do I need to set up a user in mariadb that matches 
the user name accessing digikam? Apologies if this has been asked a 
bunch of times already.

Please advise & thank you.