| ↑ Manual:Contents | MediaWiki database layout | MySQL |
The MySQL database engine is the most commonly-used database backends for MediaWiki. Since MySQL used to be the relational database management system used by the Wikimedia Foundation websites, it is well-supported in MediaWiki. Much of the advice for MySQL and for MariaDB apply to each other.
See Compatibility#Database for a list of supported versions.
mysql -u wikiuser -p my_wiki
Change wikiuser and my_wiki to the username and database name for your wiki ($wgDBuser and $wgDBname ).
When prompted, enter your password.
$ mysql -u root -p my_wiki
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 150
Server version: 5.6.24-0ubuntu2 (Ubuntu)
...
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>.
Basically, if MySQL is installed, the installation 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. |
Multiple maintenance 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.
|
| |||||
|---|---|---|---|---|---|
| Engines |
| ||||
| Technical documentation |
| ||||
| Configuration |
| ||||
| Development |
| ||||
| Core tables |
| ||||
