Setting up the MySQL database for Studio Server

This article explains how to set up a MySQL 8.0 database for Studio Server.

Clean installation

When performing a clean installation, follow the instructions as outlined on dev.mysql.com:

• Installing and Upgrading MySQL

Upgrade

When performing an upgrade, follow these steps:

Step 1. Upgrade the version of MySQL.

See https://dev.mysql.com/doc/refman/8.0/en/upgrading.html.

Step 2. Migrate the data.

See https://dev.mysql.com/doc/refman/8.0/en/faqs-migration.html.

Creating the database

Step 1. Connect to the MySQL server.

Step 2. Create a new database schema, for example named 'Studio'.

Make sure that:

• The character set is either ‘utf8’ or ‘utf8mb3’.
• The collation is set to ‘utf8_general_ci’.