Xampp Synology

  1. Synology Diskstation Xampp
  2. Xampp Synology Download
  3. Xampp Synology App

Thanks for considering making a donation to Brave Truth Society.
We operate as independent community content creators, every dollar you give funds freedom-restoring people campaigns and information dissemination. Regular contributions ensure we can 'hold the line' as we plan and moblize Kiwi's to stand up to tyranny and corruption.
By covering the core costs of keeping the lights on, your support makes it possible to sustain our efforts on those important freedom issues that the NZ Govt funded mainstream media and big tech silence with zero remorse or concern for Your rights.

Last updated: August 17th 2020

XAMPP is an easy to install Apache distribution containing MariaDB, PHP, and Perl. Just download and start the installer. XAMPP for Windows 7.3.27, 7.4.16 & 8.0.3. I had this very same issue while using Xampp. After using the “testconection.php” file and through some further trouble shooting, I discovered that my user account was set to connect to “Any host” and by changing it to “Localhost” the problem was solved. Nope, There is no need to install PHP because XAMPP is a free and open source cross-platform web server solution stack package developed by Apache Friends, consisting mainly of the Apache HTTP Server, MariaDB database, and interpreters for scripts. The universal messaging standard Tried and tested.

Introduction

MariaDB is a free, open-source and one of the most popular relational database system around the globe. It is a drop-in replacement for MySQL database system. However, the structure and indexes of both database systems are same, this will allow you to switch your database from MySQL to MariaDB without having to alter your applications.

By default, MariaDB is configured to listen on localhost only. So it can be accessed only from local users operating on the same server as the database. In modern web application architecture, most database backends are hosted on their own dedicated server. One of the easiest ways to achieve this is to configure the database to allow remote connections.

Another use-case is if you want to use remote-management software with your database such as MySQL Workbench, HeidiSQL, DBeaver, Sequel Pro or similar.

Xampp Synology

In this tutorial, we will show you how to configure MariaDB for remote connections using the Webdock dashboard, or manually with shell access on a Ubuntu 18.04 server.

Enabling Remote Access in the Webdock Dashboard

We have tried to make it relatively straightforward to create a database with remote access in Webdock. This approach may be considered insecure, please see note below.

The steps are as follows:

  1. Run the 'Enable Remote Mysql Access' script on your server (found in the Script Library)
  2. Create a new database and dabase user which contains the word 'remote' in the username. Such as 'myremotedatabaseuser'

Please note: When using this method you are opening up port 3306 to the world and anyone who can guess your DB username and password may gain access. If you want to restrict users or your firewall port by e.g. IP - then you need to follow the manual setup method below.

To repeat: Any database user created in the Webdock dashboard with the word 'remote' in the username will be granted remote access on % - meaning that user can connect from anywhere. If you have not run our enablement script in order to allow MariaDB to listen on all interfaces and your firewall port is still closed, then this has no security impact.

If you need to grant remote access to an existing database you will need to grant the appropriate privileges to a new or existing user in MySQL using the command line, or alternatively using phpmyadmin - please see instructions on how to achieve this on the command line in the instructions below.

Manual configuration using the command line

Prerequisites

  • A fresh Webdock cloud Ubuntu instance with LEMP / LAMP installed.
  • You have shell (SSH) access to your VPS.
  • A root password is set up on your VPS.

Note : You can refer to the Webdock DNS Guide to manage the DNS records.

Verify MariaDB Server

Before starting, make sure the MariaDB server is running by using the following command:

You should get the following output:

Xampp synology download

By default, the MariaDB server is listening on localhost only for security reasons. You can check it with the following command:

In the following output, you should see that the MariaDB server is listening on localhost (127.0.0.1):

Configure MariaDB

By default, the MariaDB is allow connection only from the localhost, all connections from a remote server is denied by default.

First thing you need to do is to configure the MariaDB server to listen on all IP addresses on the system.

You can do it by editing the MariaDB default configuration file /etc/mysql/my.cnf. You can open this file using your favorite text editor:

Change the value of the bind-address from 127.0.0.1 to 0.0.0.0. So that MariaDB server accepts connections on all host IPv4 interfaces.

Save and close the file when you are finished. Then, restart the MariaDB service to apply the changes:

You can now verify the MariaDB listening status with the following command:

If everything is fine, you should get the following output:

Now, the MariaDB server is setup to listen to all IP addresses.

Note : If your are running MySQL Server instead of MariaDB, the main configuration file is located at /etc/mysql/mysql.conf.d/mysqld.cnf. You can change the bind-address by editing this file.

The remaining steps are all the same.

Grant Access to a User from a Remote System

Synology

In this section, we will create a new database named wpdb and user named wpuser, and grant access to the remote system to connect to a database wpdb as user wpuser.

First, login to the MariaDB shell with the following command:

Provide your admin (root) password as shown in the Webdock backend and when you get the prompt create a database and user with the following command:

Next, you will need to grant permissions to the remote system with IP address 208.117.84.50 to connect to a database named wpdb as user wpuser. You can do it with the following command:

Next, flush the privileges and exit from the MariaDB shell with the following command:

A brief explanation of each parameter is shown below:

  • wpdb : It is the name of the MariaDB database that the user want to connect.
  • wpuser : It is the name of the MariaDB database user.
  • 208.117.84.50 : It is the IP address of the remote system from which user want to connect.
  • password : It is the password of the database user.

If you want to grant remote access on all databases for wpuser, run the following command:

If you want to grant access to all remote IP address on wpdb as a wpuser, use % instead of IP address (208.117.84.50) as shown below:

If you want to grant access to all IP addresses in the subnet 208.117.84.0/24 on wpdb as a wpuser, run the following command:

Configure Firewall

Synology

If your MariaDB server is configured with the UFW firewall (which it is by default on all Webdock servers) then you will need to allow traffic on port 3306 from the remote system.

You can grant access to the remote system with IP 208.117.84.50 to connect the port 3306 with the following command:

Synology Diskstation Xampp

If you want to grant access from any IP address you would use the following command:

Next, reload the firewall with the following command:

This time zone converter lets you visually and very quickly convert EST to UTC and vice-versa. Simply mouse over the colored hour-tiles and glance at the hours selected by the column. EST stands for Eastern Standard Time. UTC is known as Universal Time. View the EST to UTC conversion below. Eastern Standard Time is 4 hours behind Coordinated Universal Time.Convert more time zones by visiting the time zone page and clicking on common time zone conversions. Or use the form at the bottom of this page for easy conversion. EST to UTC call time Best time for a conference call or a meeting is between 8am-1pm in EST which corresponds to 1pm-6pm in UTC 7:30 am Eastern Daylight Time (EDT). Eastern to utc. This time zone converter lets you visually and very quickly convert EDT to UTC and vice-versa. Simply mouse over the colored hour-tiles and glance at the hours selected by the column. EDT stands for Eastern Daylight Time. UTC is known as Universal Time. Eastern Standard Time (EST) is UTC-5:00, and Eastern Daylight Time (EDT) is UTC-4:00, this time zone is called Eastern Time Zone (ET) in the United States, parts of eastern Canada, Mexico, Panama and the Caribbean Islands.

Once you are finished, you can proceed to the next step.

Test Connection from Remote System

At this point, the MariaDB server is configured to allow connection from the remote system with IP address 208.117.84.50. Now, it's time to test the connection from the client system to the MariaDB server. Here we show how to do this on the command line in Linux, but you can also test this from your desktop (if not on Linux) by utilizing any MySQL remote manager such as the ones listed in the introduction to this article.

First, you will need to install the MariaDB Client package in the remote system. You can install it with the following command:

Once the installation is completed, connect to the MariaDB server by running the following command on the remote system:

You will be asked to provide the password of the wpuser as shown below:

Once the connection has been established, you should get the following output:

Xampp Synology Download

You can now list the databases using the following command:

You should get the following output:

Conclusion

Xampp Synology App

In the above tutorial, we learned how to configure MariaDB for remote connections. we also learned how to grant access on a specific database or all databases to the specific IP address or all IP addresses. We hope this guide helps you to understand how to connect your web application to the database hosted on the remote server and how to secure it properly with IP restrictions.