1

I have my home computer that I am using to learn MySQL that also houses the MySQL database and XAMPP server. I would also like be able to access it using my school computer when I am at school?

my home computer is windows my school computer is a mac and I would like to have full access to change alter and delete everything and anything on my home database, without anyone else able to do the same.

How would I do that?

1 Answers1

0

First go through the steps given here, Access XAMPP Localhost from Internet, to enable remote access of your xampp server.

Then protect your server/application from unwanted users, with any of the following method,

  1. allow only particular IP address to access it with apache access control.
  2. use apache basic authentication.
  3. Write PHP code for user authentication

So, only the authenticated users will be able to enter the area where they can run the database scripts.

Community
  • 1
  • 1
Nikhil Supekar
  • 655
  • 6
  • 18