How to host Adminer DB on Contabo VM Instance - ServerAvatar

Adminer is an open-source database management tool known for its comprehensive functionality and ease of use. It allows organizations to effectively manage and administer various database systems with features for querying, data manipulation, and user management. With its user-friendly interface and flexible capabilities, Adminer enables effective database management without needing extensive technical knowledge. When selecting a hosting solution for Adminer DB, Contabo stands out as a reliable option with scalable infrastructure and simple deployment solutions. ServerAvatar makes the deployment of the Adminer DB on the Contabo platform straightforward through a simplified process.

Create VM Instance in Contabo

What Is Contabo?

Contabo is a web hosting company that provides a variety of internet hosting services. Founded in Germany in 2003, Contabo offers services such as:

1. VPS Hosting: Virtual Private Servers with scalable resources for various needs, from small projects to larger applications.
2. Dedicated Servers: Physical servers dedicated to a single user, offering high performance and control.
3. Web Hosting: Shared hosting solutions for websites, which include storage, bandwidth, and various management tools.
4. Object Storage: Scalable storage solutions for managing large amounts of data.
5. Domain Registration: Services for registering and managing domain names.

Contabo is known for its competitive pricing, high-performance hardware, and customer service, making it a popular choice for both individual users and businesses looking for reliable hosting solutions.

To set up a server in Contabo, begin by logging into your Contabo account. Once logged in, proceed with the following steps.

Step 1: Create an account on Contabo

Login to your Contabo account, select "VPS" from the dropdown menu, and then click on "Cloud VPS".

Step 2: Select your Cloud VPS plan

Contabo offers a variety of Cloud VPS options. The minimum requirements for Adminer DB are a minimum of 1GB of RAM, but more is recommended for better performance, especially if the server is handling other services or a large number of database connections, and a minimum of 5GB of free disk space is recommended, but more may be needed depending on the Adminer’s files, logs, and any associated database storage.

Here, you should select the plan that best meets your requirements as shown in the below image.

Step 3: Select Region

• First, you need to select the term length (in months) according to your requirements.
• Next, you will need to select the location for your VPS. Contabo offers multiple options for selecting the location.
• It's recommended to select the region closest to your audience. This ensures that your sites load faster for the majority of your audience due to reduced latency.

Step 4: Select your Storage Type

Contabo provides different types of storage space, including both complimentary and paid options. Here, you should select the storage type based on your specific requirements. As shown in the image below.

Step 5: Select an Image or an OS

In this step, you need to select the Operating System for your cloud VPS. We recommend using Ubuntu 20.04 LTS x64 or Ubuntu 22.04 LTS x64. Ubuntu is known for its ease of configuration and management. If you are using ServerAvatar to manage your cloud VPS, these operating systems are recommended.

Step 6: Setting a Password

Here, it's recommended to create a strong password for your root user, as it holds all privileges on the Linux OS.

Step 7: Select Object Storage

Now, you need to select object storage space for backing up your VPS. You will find several options ranging from 250 GB to 1 TB. If you do not require object storage you can select the None option from the dropdown.

Step 8: Select Network

• In the Network section, you will find three options, You should select these according to your specific requirements:
  • Private Network
  • Bandwidth
  • IPv4

Step 9: Selecting Additional Options

• Backup Space: This option allows you to add additional storage space dedicated specifically for backups of your VPS data.
• Server Management: Contabo offers server management services where they handle the day-to-day operations of your VPS.
• Monitoring: This option provides monitoring services for your VPS. It includes monitoring server uptime, resource usage (CPU, RAM, disk), and network connectivity.
• SSL: SSL (Secure Sockets Layer) certificates are crucial for securing communication between your website and its visitors.

After completing all the necessary steps, click on the "Next" button to proceed to the payment method where you can finalize your details.

Step 10: Finalize Details

In this step, you can review all your selections for your Cloud VPS, finalize your details, and proceed with the payment. In a few minutes, your Cloud VPS will be ready. Now, we need to perform the initial configuration to host PHP-based frameworks and software.

Initial Server Configuration

The Initial server configuration includes the installation and configuration of various packages required to host your website. Usually, You have to write commands and modify configuration files. Luckily, With ServerAvatar, Your full server configuration and optimization can be automated.

Here are the three ways to automatically configure your server with ServerAvatar.

wget https://srvr.so/install
chmod +x install
./install

Install and Setup Adminer DB on Cloud using ServerAvatar

Adminer - Database management using Adminer With ServerAvatar

What Is Adminer?

Adminer is a PHP-based, Free, and Open Source Database Management Tool. It is very simple to deploy on your server and easy to use. Here, you only need to upload a single PHP file, point your browser to it, and simply click the login button.

Requirements:

1. PHP: Ensure you have a PHP 5 or higher version installed.

Use Cases:

You can easily create, edit, and delete databases, tables, and rows, as well as execute SQL queries and view results in a clear and concise format. Adminer supports a wide range of database systems, including MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, etc.

Step-by-Step Installation Guide:

Let’s Configure Adminer with ServerAvatar.

First, you have to go to the following URL.

URL: https://www.adminer.org/

Step 1: Download the Adminer

Clicking on the link will take you to the official site of Adminer. Navigate to Downloads section and click on the version of Adminer according to your need.

Step 2: Create a GitHub application

Start by creating a GitHub application using ServerAvatar. Go to the Applications tab on the server panel and click on the Create button as shown in the image below.

To proceed with the installation and deployment of Adminer, ensure you have met the prerequisites.

• Enter an Application Name of your choice.
• Specify a Domain (choose between a Test Domain or a Primary Domain).

Now, Clone Adminer from the available public repository in Github. and then click on the Create Application button.

• Method: Git
• Service Provider: Github
• Repository Type: Public
• Clone HTTPS URL: https://github.com/vrana/adminer.git
• Branch: master

Step 3: Create Adminer Database

Go to the server panel, navigate to the Databases tab, and click on the Create button as shown in the following image.

On the following screen, complete the database details, including:

• Database Name
• Database Username
• Database Password

Step 4: Upload Adminer File

• Navigate to the Application Panel tab by clicking on the icon next to the application as shown in the below image.

• Now, go to the FIle Manager option and open the public_html folder.

• Click the Upload icon and choose the previously downloaded Adminer file to upload it into the public_html folder.

• You can see the Adminer file that you uploaded in the public_html directory as shown in the image below.

• Now, we need to rename the Adminer file that we uploaded. Select the checkbox next to the file and click on the rename icon, as shown in the image below. Rename the file to index.php.

Step 5: Accessing the Adminer Database Homepage

• Now, to access the Adminer Database Homepage, open your application.

• To log in to your Adminer’s Database Homepage, you need to have your database Username and Password. Navigate to the Application Dashboard and click on the Databases option to get the database credentials.
• After navigating to the Databases Section, you have to click on the users icon as highlighted in the below image.

• After clicking on the user's icon, you will navigate to the database users page. You will get the database credentials from there.

• Fill in the database information such as Database Name, Username, and Password on the login page of your Adminer as shown in the below image. After filling in the details click on the Login button.

• After successfully logging in, you will be able to see the dashboard.

• Now you can perform various tasks such as creating tables, altering tables, dropping tables, inserting values into tables, updating values, and deleting values.

Conclusion:

• Adminer is a powerful, lightweight, and user-friendly database management tool that offers a wide range of features in a single PHP file.
• Its simplicity, efficiency, and support for multiple database systems make it an excellent choice for developers and administrators looking for an alternative to more complex tools.
• Whether managing a small personal project or a large enterprise database, Adminer offers extensive functionalities. By using Adminer you can experience the benefits of efficient database management.