Actually, if you read the script /etc/rc.d/rc.mariadb you'll notice that it contains all the information you need to get started.
You'll also notice that the command to run as root which will initialize the database, accepts a parameter which makes the “chown” command obsolete:

mysql_install_db --user=mysql

Nevertheless, many people won't expect that documentation to be part of the actual rc script so thanks for adding it to our wiki :-)Eric Hameleers 2014/11/18 13:08

Maybe it would be useful to readers if this was pointed out on the page itself. I at least didn't look at the discussion page and this would have saved me some searching the web for more info. – Beni aka navigium 2016/06/19

——–

Server listening to localhost

I found this article very useful, thank you. One thing I missed was that it didn't tell me that by default MariaDB only listens on a Unix socket. For my application, I needed it to listen to TCP connections on localhost. After searching the web, I realized that this is in fact documented in /etc/rc.d/rc.mariadb. You only need to comment out the line:

SKIP="--skip-networking"

Maybe it would help the reader if this fact was mentioned on the page. – Beni aka navigium 2016/06/19


Aaditya, the dot in “chown -R mysql.mysql” actually is not a typo. It is normal syntax, and the colon instead of the dot is just an equal alternative.
Eric Hameleers 2018/01/02 18:14 (UTC)


Indeed it is not a typo, however, it's worth noting that a dot is perfectly valid character in a valid username, so the colon is a better choice to use for chown user:group operations. — Robby Workman