Setup Database in Windows Server
🛠️ Tools & Technologies Used:
MySQL Server (Windows Server 2016)
MySQL Workbench (for testing)
XAMPP (Apache + PHP on Client PC)
MySQL_WebApp_Simple_CRUD (GitHub Web App)
Windows Firewall Configuration
Local Network (IP-based connectivity)
🔗 Setup Process Summary:
Installed and configured MySQL Server on Windows Server 2016.
Created the testdb database and a remote-access user account.
Opened port 3306 on the server firewall to allow incoming connections.
Installed XAMPP on the client machine and deployed the PHP CRUD app.
Configured dbConnection.php to point to the server IP, username, password, and database name.
Tested CRUD operations from the client and verified successful database connectivity.
✅ Outcome:
The web application is now fully connected to the remote MySQL database server. CRUD operations (Create, Read, Update, Delete) work as expected across the network.