Hello Everyone

I’m planning to migrate to mysql managed database once it is available in my current datacenter.

For the people whom already tried it, can you share your experience so far (I know it’s less than a week but let me know what do you think, did you move your production mysql or still waiting? did you noticed any limitation or issues?)

Did anyone try to use it with Laravel 5.7?

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
2 answers

The major problem is Mysql version.

DO Managed database uses Mysql 8.0. So, you have to install Mysql 8 in your droplet and (after create database) change the auth plugin to mysql_native_password (mysql 8 has, by default, caching_sha2_password plugin and PHP does not support it yet).

If you use Sequel Pro, i said so sorry.. Sequel Pro does not support Mysql 8 login and i think it will never support :(

I posted a “mini-tutorial” in this topic: https://www.digitalocean.com/community/questions/how-do-i-migrate-a-mysql-database-from-a-droplet-to-a-managed-database

Just migrated my Wordpress database from MySQL 5.7 to managed Mysql 8 :)

Looking forward to migrating my main application

Wish me good luck

Submit an Answer