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 ‘%’…