How to Grant User Remote Access to A MySQL Database on Shell

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.

1. Connect to MySQL

   mysql -u root -p

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