How to host Adminer DB on Vultr Server - ServerAvatar

Adminer DB is a powerful and lightweight database management tool that is written in PHP. It provides a user-friendly web interface for managing various databases, including MySQL, PostgreSQL, SQLite, and more. Adminer DB enables effective database management without needing extensive technical knowledge. Hosting Adminer DB on Vultr provides a dependable and scalable solution. Vultr provides a wide range of instance types and configurations to match various performances with flexible deployment options. ServerAvatar simplifies the process by providing a clear, step-by-step guide to setting up your Adminer DB on Vultr VPS.

Create a Cloud Instance in Vultr

To create a server in Vultr, follow the below-given steps. If you want to learn How to use Vultr to manage your infrastructure in Vultr, You can refer to our Vultr cloud guide.

Step 1: Go to the Instance Creation Page

Vultr provides different types of cloud instances. From the server creation page, you can create cloud instances such as Regular VMs, Dedicated, Bare Metal, Cloud GPUs, and some managed services.

To access the server creation page, log in to your Vultr account and click on the Deploy New Server option from the + button given on the dashboard.

Step 2: Choose the Server

You can create 4 different types of cloud instances which includes Optimised Cloud Compute, Cloud Compute, Cloud GPU, and Bare Metal. Select the one that fits your requirements.

Step 3: Choose Server Type

Based on your selection of the server in the second step, You will have to select a specific type of server. If you have selected the Optimised Cloud Compute instance, You will see the options like this as shown in the image below:

Step 4: Select Server Location

Location is a very important option. Make sure to select a server location closest to your major traffic source demographically. You can select locations in 5 different continents.

Step 5: Select Server Image

In simple terms, a Server image is an operating system running on the server. So here, You have to select an OS for your server.

If you are managing your servers with ServerAvatar, Select Ubuntu 20.04 or Ubuntu 22.04.

Step 6: Select Server Size

Here, Select a server size according to your requirements. The minimum requirements for Adminer DB are a minimum of 1GB or more RAM 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.

If you are just getting started with the project, You can start with a small configuration and then upgrade it according to future requirements.

Step 7: Add Auto Backups and Additional Features

We recommend you to enable auto backups for important websites or apps. If you are creating a temporary server, You can skip the auto backups.

In addition to this feature, You can enable DDOS Protection and other options according to your requirements.

Do not enable the "No Public IPv4 Address" option. It will create the server without IPv4, which is impossible to connect with ServerAvatar.

Step 8: Select an SSH Key

If you use an SSH key to authenticate with the server, Select an SSH key in this section. If you haven't uploaded your key yet, You can do it by clicking on the Add New option.

SSH key is not mandatory. If you don’t want to use SSH keys, Ignore this option. You can still connect to your server by using the password.

Step 9: Firewall Group

If you are using the Vultr firewall, You can select the firewall group from here.

If you do not have the 43210 port enabled in your firewall group, you need to configure it to connect a server with ServerAvatar.

Step 10: Server Hostname and Label

In this step, you have to choose the hostname and the label for the server. You can set the same hostname and label. They are used for identification purposes only.

Step 11: Deploy Now!

Finally, click on the Deploy Now button to create a server. It might take a minute or two to fully boot up your server. Once it is ready, You will see it in the Products section in Vultr.

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.