Default database details

Databases
#1

Hi Cleaver tech,

How can I create MySQL 8 databases using different params, mainly variations of the following:

DEFAULT CHARACTER SET utf8mb4
DEFAULT COLLATE utf8mb4_unicode_ci;

Also, what is the default root password?

Thanks

#2

Hey David,
There is currently no way to set different defaults for a database. But I can see how this could be a problem. We’ll add this to our task list and will implement in future.

You should have received the default root password in your email when your first provisioned the server.

#3

Hi Ashok,

I received the sudo password when provisioning the server, but not the MySQL root password.

I installed MySQL 8 from the Cleaver control panel after provisioning - maybe this affected the root password not being provided?

Thanks