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