Execute command denied to user ‘user’@’%’ for routine ‘sys.list_drop’

We see this error when mysql user doesn’t have permission to execute the list_drop Function inside sys schema of mysql. To fix this error we need to grant the privilege for the same.

1. Login as the root user.
2. Run the below command.

GRANT EXECUTE ON FUNCTION sys.list_drop TO 'user'@'%';

In above command, change the ‘user’ with your mysql user whom you want to grant privilege.

Happy Coding!!