Add new MySQL user for remote access

How to add new MySQL user for remote access?

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;

Related Articles

Share on facebook
Share on twitter
Share on linkedin
Share on pinterest
Share on print
Share on email