Managed RDS MySQL 8.0 not compatible with current docker-compose

Hi @regis or any of the maintainers for tutor.

I’m trying a managed DB (RDS MySQL 8.0) for Tutor and came across this error
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY "<password>"' at line 1. Specifically this line:

mysql -u root --password="vjD1rVVf" --host "<hostName>" --port 3306 -e 'GRANT ALL ON openedx.* TO "openedx"@"%" IDENTIFIED BY "<password>";'

I was checking the documentation for MySQL 5.7 vs 8.0 and noticed 8.0 doesn’t support the IDENTIFIED BY command anymore. Would it be better to mention this in the MySQL section at Configuration and customisation — Tutor documentation this only works when using < v8.0 of MySQL?

Grant Command Info:
https://dev.mysql.com/doc/refman/5.7/en/grant.html
https://dev.mysql.com/doc/refman/8.0/en/grant.html

1 Like

Yes, we should specify this information in this section. Would you like to open a PR @c3ho?

Sure! I’ll submit a pr to update the documentation.

1 Like