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'@'%';

Leave a Reply

Your email address will not be published. Required fields are marked *