how to add new MySQL user for remote access?

December 16, 2019 in Database



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;

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.