To enable remote access for mysql, 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;