I'm trying to use a managed database but without success.

January 15, 2020 94 views
DigitalOcean Managed MySQL Database

I created a managed database to use with my droplet, imported all fine but when trying to connect via php I get this error
“Server sent charset unknown to the client.”
I understand this is caused by the utfmb4 charset that is configured in the MySql from the managed instance.
How can I change this (to the database level and not schema or table level) so I can work with it?

1 Answer

Can you recreate a db with utf8, re import and try again?

Other fixes usually have to do with mysql config, but you don’t have access to it with a managed instance

Have another answer? Share your knowledge.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!