RSS

Grant access Mysql DB to any other computer in your LAN

31 Aug

This is very useful post because when you are going to run the application with Centralized DB you have to give the privileges to the other computers to access Single database hosted in your LAN.

So what you need to do is just run the single database in one computer then go to MySQL console and type the following commands


mysql> grant all privileges on *.* to 'root'@'%' identified by 'root_password';

mysql> flush privileges;

By replacing the ‘%’ to any IP address you can grant for the given IP

Advertisements
 
1 Comment

Posted by on August 31, 2012 in mysql

 

Tags: , ,

One response to “Grant access Mysql DB to any other computer in your LAN

  1. Sandip

    March 17, 2015 at 8:26 am

    THanks….Its worked for me…

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: