This documentation has moved to Configure MySQL and the pages below it.

Compatibility Considerations

See MySQL Storage Engine and Character Set.

MyISAM storage engine

See MySQL Storage Engine and Character Set and Convert MyISAM Tables to InnoDB.

JDBC Driver Version

See Configure MySQL.

Installation Steps

See Configure MySQL. If saving a large document or attachment fails once XWiki runs, see "Packet for query is too large" MySQL Error.

Indexes

See Optional MySQL Indexes.

Tips

MySQL 8

See "The server timezone value is unrecognized" MySQL Error.

Convert a database to utf8mb4/utf8mb4_bin

See Convert a MySQL Database to utf8mb4.

Convert from MyISAM to InnoDB

See Convert MyISAM Tables to InnoDB.

Troubleshooting

"Incorrect string value" error with MySQL connector between 8.0.29 and 8.0.32

See MySQL Storage Engine and Character Set.

Unable to login to MySQL Console

See Configure MySQL.

HTTP 500 Error

See XWiki Cannot Connect to MySQL.

Unknown database 'xwiki'

See "Unknown database" MySQL Error.

MySQLSyntaxErrorException: Row size too large (> 8126)

See "Row size too large" MySQL Error.