Unable to grant invoke lambda in MySQL workbench (5.6.mysql_aurora.1.22.2)

Use MySQL CLI

The error message "INVOKE is not valid at this position for this server version" typically occurs when the MySQL Workbench doesn't recognize the syntax. This could be due to a version mismatch between the MySQL Workbench and the MySQL server⁴.

In your case, you're trying to use the GRANT INVOKE LAMBDA command, which is specific to AWS Aurora MySQL and may not be recognized by the MySQL Workbench.

You mentioned that you were able to run the GRANT INVOKE LAMBDA command successfully in the MySQL CLI tool. This suggests that the issue is specific to MySQL Workbench.

If you continue to face issues with MySQL Workbench, consider using the MySQL CLI tool or another SQL client that supports the AWS-specific commands.

Remember to replace user@domain-or-ip-address with the actual username and host for your MySQL user. For example, if your username is myuser and the host is localhost, the command would be GRANT INVOKE LAMBDA ON *.* TO 'myuser'@'localhost'.

I hope this helps! Let me know if you have any other questions. 😊