Accessing XAMPP PhpMyAdmin From Other Computers in LAN

0
42
Accessing XAMPP PhpMyAdmin From Other Computers in LAN

Hello friends how are you? So today in this tutorial we will be talking about Accessing XAMPP PhpMyAdmin From Other Computers in LAN (Same Network). So for those who are not familiar with what is XAMPP, I will be explaining that. Also why or in which case, you want to give it access to other computers on the Network.

What is XAMPP?

If you are a student of Computer Science subject and web application, then you would have a good idea of server and client setup. So XAMPP is a server for setup for web application development and running websites on your local server. It comes pre-installed basic web server requirements Apache, MySQL, FileZilla, Tomcat, and Mercury. Apache is responsible is the main part of a web server that helps host websites and allows out site visitors to be able to interact with the web application.

XAMPP

MySQL is the database provided in XAMPP for storing data from your application. Now just to mention we can use MySQL for the desktop application it’s not only made for web applications.

Filezilla is the FTP client that you can set up for sharing of files and other resources from the server. Same with Tomcat and Mercury.

So, Now you would have a pretty good idea about that is XAMPP and why it’s used. Now we will discuss why we need to let its access to other computers.

You can download it from here.

 

Also Consider reading this if you are into setting up servers:-

How to Setup Node.js Server on your Local Windows or Linux Machine

What is PhpMyAdmin?

PhpMyAdmin is a web interface that helps you communicate with the database server using a web browser. It’s so in short it is a GUI interface that can be used to perform database actions.

Why Do this?

After that you must b thinking what is the use of this and why should I do it? Let’s talk about that then. Consider you are developing a web application or a desktop application and you have a team, all working on different parts of that application and all require the database access to modify and create new tables if required.

Now in this case, if the database can only be accessed on the computer running the XAMPP server, it makes it hard for other team members to do there work effectively. So its good to give limited access to each user, and let it be accessible on the network so that does not disrupt the workflow.

And after the work is done simply change it back if you are concerned, about security which is a best security practice if you are thinking of launching it over the internet.

Now, let’s get started.

Accessing XAMPP PhpMyAdmin From Other Computers in LAN:-

So now I will go ahead and get to it.

First, try to open PhpMyAdmin on other computers on the network you will get an error like this:-

http://<ip-of-xampp-server>/phpmyadmin/

And you will see that the error says to change httpd-xampp.conf file to get it working on other computers on the network.

Change the following code:-

Alias /phpmyadmin "C:/xampp/phpMyAdmin/"
<Directory "C:/xampp/phpMyAdmin">
AllowOverride AuthConfig
Require local
ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var
</Directory>

With this code:-

Alias /phpmyadmin "C:/xampp/phpMyAdmin/"
<Directory "C:/xampp/phpMyAdmin">
AllowOverride AuthConfig
Require granted
ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var
</Directory>

Now again try to open http://<ip-of-xampp-server>/phpmyadmin/ and it will work like a charm.

Here is the video if you still get any problem.

I hope that it was helpful for you and you have learned something from this if you have any question be do let us know in the comments and if you want to see something that you like also tell us that too we will try to cover as much as possible.

Do like share and subscribe to our youtube channel that really helps us.

LEAVE A REPLY

Please enter your comment!
Please enter your name here