Enabling MySQL Remote Access
The MySQL Tip Shows You Step-by-Step How to Grant Remote Access/Connection to a User on a MySQL Database by Unix/Linux Command Line.
The Process is Essential if You Need to Enable a Remote Connection to the MySQL Database.
Connect to MySQL
mysql -u root -p
Grant Remote Access to the MySQL User
GRANT ALL ON *.* TO 'yourMySQLUser'@'%' IDENTIFIED BY 'Pass';
To Limit the Access for only one IP change the ‘%’…