TheMySQL database engine is one of the most commonly-used database backends for MediaWiki.Since MySQL used to be the relational database management system used by theWikimedia Foundation websites, it is well-supported in MediaWiki.Much of the advice for MySQL and forMariaDB apply to each other.

SeeCompatibility#Database for a list of supported versions.

 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

Basically, if MySQL is installed, theinstallation script can create a database for you.Just supply the script with your MySQL 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:Importing XML dumps

For further information, seeManual:Backing up a wiki

• Manual:MysqlUpdater.php
• Manual:Security#General MySQL recommendations
• Tool to convert SQLite MediaWiki database into MySQL

• MySQL Reference Manual

• Database