How to add new MySQL user for remote access?

To add new MySQL user for remote access, we should follow these simple steps:

1. Open port 3306  to enable remote connection

2. Login to your MySQL with this command

mysql -u root -p

And then create a new user and grant access

CREATE USER 'username'@'%' IDENTIFIED BY 'userpass';
GRANT ALL ON *.* TO 'username'@'%';
FLUSH PRIVILEGES;