The MySQL user does not have the proper PRIVILEGES to act as a MySQL superuser

Symptoms

When setting up a remote MySQL profile with a manually specified MySQL user, you might see the following error message when validating the connection:

The MySQL user “username” does not have the proper PRIVILEGES to act as a MySQL superuser.
For more information, read our documentation.

Description 

This error is caused when the user (and hostname or IP address) doesn't have all privileges with the grant option.

Workaround

You'll want to review the link to the troubleshooting steps article which is linked to in How to use MySQL Profiles