DHpanel creates databases not in UTF8 format

[torbengb]

CREATE DATABASE `foo` DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

CREATE TABLE `bar` (
  `baz` int NOT NULL AUTO_INCREMENT
  PRIMARY KEY (`id`)
) DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

DH won't let me run the first statement.

[torbengb]

• Need to change the database according to the following.
• Need to document this (wiki and possibly /docs).

You are correct, databases can be created in the DreamHost panel only.
Databases cannot be created via SSH or phpMyAdmin. View the following
article for further details:
https://help.dreamhost.com/hc/en-us/articles/221621388-Managing-existing-MySQL-databases

You can change the database collations using phpMyadmin. You will need to
select the database name and then you can set you MySQL connection
collation via a "pull down" menu in the left most column of the right
frame of the default page that is displayed. You can connect using
phpMyadmin by following these steps:
https://help.dreamhost.com/hc/en-us/articles/214395638

This article can also be useful:
https://dev.mysql.com/doc/refman/8.0/en/charset-connection.html