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 :-) --- //[[wiki:user:alienbob|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.\\ --- //[[wiki:user:alienbob|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. --- //[[wiki:user:rworkman|Robby Workman]]//