How to create MySQL user and grant permissions in AWS RDS

Originally published at: https://www.cyberciti.biz/faq/how-to-create-mysql-user-and-grant-permissions-in-aws-rds/

How do I create a new MySQL user and grant permissions in AWS RDS cloud service from the Linux command line?