WAMP: How to allow access of local phpmyadmin database to other local system in same network

Sometimes we are working in team on same project. That time we are installing the Database on every system. One single change on any one of system and we have to apply it on the multiple system manually. This is time consuming and tedious work.

So we are giving the solution to install Database on only one system and access this Database by all the users in selected network.

But how it is possible?

Let’s Start.

1) Open the phpmyadmin.conf file on the Path wamp\alias

Find and change these portions:

To this portion,

And this to,

The portion below.

2) Add the rule for port 3306 in firewall

[Click here to learn how] https://msdn.microsoft.com/en-us/library/hh168549(v=nav.90).aspx

3) Restart the System

Now, you can access the database from another PC.
In PHPMyAdmin of that particular pc, you will have grant access to particular systems (using static IP is recommended.).
If you don’t know how, don’t worry, our next article is about that.

If you like this article, please share and comment. I would love to hear what you guys are thinking.