Hello!

To preserve the stability of the database cluster, users are not able to modify global variables. However, you can make this change on a database by database basis, as described here:

https://dev.mysql.com/doc/refman/8.0/en/charset-database.html

Here’s an example:
ALTER DATABASE database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Note however that this will just change the default charset for the database, all existing tables will have to be converted. You can do that with a command such as this one:

ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Hope it helps!

Is there any resolution for this. I have followed your instructions above and it fails either way.

The mysql managed DB is useless to me if we can’t connect to it with PHP.

I have only FPM version, trurlmcbyte/php-fpm:hack (PHP 5.6.40)

Are the folks at DO going to bother with a solution for this?
Seriously, 1.2k views on this page should be enough for you to realise it’s something a few users have struggled with.

After a week preparing to migrate a site to DO I’ll have to find another provider and start it all again.... fantastic

I can’t use database Mysql DO becouse error.

Any solutions ?

other than this.

[client]
default-character-set = utf8

[mysql]
default-character-set = utf8

[mysqld]
character-set-server = utf8
collation-server = utf8mb4unicodeci