TheMariaDB database engine is one of the most commonly-used database backends for MediaWiki.Since MariaDB is the relational database management system used by theWikimedia Foundation websites, it is well-supported in MediaWiki.

SeeCompatibility#Database for a list of supported versions.

$ mariadb -u root -p my_wiki

If using a MariaDB 10.3 or earlier:

 mysql -uwikiuser -pmy_wiki

Changewikiuser andmy_wiki to the username and database name for your wiki ($wgDBuser and$wgDBname).When prompted, enter your password.

$ mysql -u root -p my_wikiEnter password: Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -AWelcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 150Server version: 5.6.24-0ubuntu2 (Ubuntu)...Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>.

For further information, seeManual:Installing MediaWiki#Create a database

If MariaDB is installed, theinstallation script can create a database for you.Just supply the script with your RDBMS root password (by default, blank).

Warning:

Leaving the root password blank can seriously compromise the security of the MediaWiki installation. You should modify the password if you haven't already.

Multiplemaintenance scripts are included in the/maintenance/ directory of your MediaWiki installation.Some of these scripts are provided to refresh parts of the database as one-time operations.

For further information, seeManual:Restoring a wiki from backup

For further information, seeManual:Backing up a wiki

• Manual:MysqlUpdater.php
• Manual:Security#General MySQL recommendations

• MariaDB Knowledge Base

• Database