how to add new MySQL user for remote access?

    1. Open port 3306  to enable remote connection
    2. Login to your mysql with this command
mysql -u root -p
    1. Create a new user and grant access
CREATE USER 'username'@'%' IDENTIFIED BY 'userpass';
GRANT ALL ON *.* TO 'username'@'%';
FLUSH PRIVILEGES;