How-to Grant User Remote Access to a MySQL Database on Shell

December 5th, 2014 by thelinuxevangelist

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 Indispensable if You Need to Enable a Remote Connection to the MySQL Database.

How-to Enable Remote Access to a MySQL Database - Featured
  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 ‘%’…



Share on Tumblr

Tags: , , , , , , , , , , , ,


Comments are disabled