MariaDB

MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. It is notable for being led by the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle.

Instalation

Alpine Linux has dummy counterparts packages for those that are not close to that change from mysql to mariadb naming packages.

Take in consideration that the user mysql was created during instalation of packages, in the initialization section two users will be created in database init: root and mysql, and in that point only if are in their respective system accounts, will be able to connect to the database service.

apk add mysql mysql-client

That will install the most used ones.. mariadb-cient and mariadb-server, rest of packages are brief described here for more information:

MySQL name package	Since Alpine:	Brief usage	Related package
mysql	v2	it's a dummy package to easy install of mariadb	mariadb
mysql-client	v2	it's a dummy package to easy install of commands tools	mariadb-client
mariadb	v2	server equivalent to mysql-server	mariadb-common
mariadb-client	v2	connection command line and tools	mariadb-common
mariadb-doc	v3.0	manpages are there!	man man-pages
mariadb-connector-c	v3.8	coding connection on C sources	mariadb-connector-c-dev
mariadb-connector-odbc	edge	coding or making OS level connections	.
mariadb-backup	v3.8	to external backup devices, not widely used, in past was inside mariadb package	.
mariadb-server-utils	v3.8	server commands not widely used, in past was inside mariadb package	.
mariadb-dev	v3.1	Need for compilations depends on source code	.
mariadb-test	v3.3	testing suite from MariaDB tools	.
mariadb-mytop	v3.9	data performance monitoring	.
mariadb-plugin-rocksdb	v3.9	plain key-value event relational for data	.
mariadb-server-utils	v3.8	to reduce main server package, not widely used commands	.
mariadb-static	v3.8	static libs for static non depends linking in builds	.
mariadb-embedded	v3.9	the libmysqld identical interface as the C client	mariadb-embedded-dev
mariadb-embedded-dev	v3.9	use the normal mysql.h and link with libmysqld instead of libmysqlclient	mariadb-dev
mariadb-openrc	v3.8	separate scripts, in past was embebed on server package	.

Initialization

The alpine package of MySQL/MariaDB are like normal tarball of MySQL one, admins must be know what they want.. there's no automatic window-like here,

1. Initialize the main mysql database, and the data dir as standardized to /var/lib/mysql by the rc script
2. Then initialize the service, root account and socket connection are enabled without password at this point
3. Setup the root account by asignes a proper password, this are purely paranoid. due next step already do that!
4. Setup and init the installation by running the mysql_secure_installation
5. Setup permissions for manage others users and databases

mysql_install_db --user=mysql --datadir=/var/lib/mysql

rc-service mariadb start

mysqladmin -u root password toor

mysql_secure_installation

See Also

• PotsgreSQL
• Production LAMP system: Lighttpd + PHP + MySQL
• Alpine newbie developer
• Alpine newbie lammers