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;
