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

December 5, 2014 | By the+gnu+linux+evangelist | Filed in: Tutorial.

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.

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

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

QuickChic Theme • Powered by WordPress