How to host Adminer DB on Linode VM Instance - ServerAvatar

Adminer is an open-source database management tool known for its comprehensive functionality and ease of use. With its user-friendly interface and flexible capabilities, Adminer enables effective database management without needing extensive technical knowledge. It allows organizations to effectively manage and administer various database systems with features for querying, data manipulation, and user management. Hosting Adminer DB on Linode provides a dependable and scalable solution. Linode 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 Linode.

Create a server in Linode

First of all, Let's create a VM instance in Linode. It provides a lot of different types of VM instances. You can create shared VM instances, Dedicated Instances, Memory-optimized instances, and GPU instances. To host a simple website, You will need a shared VM instance.

If you think your application uses high CPU or RAM, You can go for a Dedicated CPU VM or Memory Optimised VM respectively. Let's get started with the process.

Step 1: Go to Linode VM Instance Creation Form

When you log in to your Linode account, You will see the Create Linode button on the top-right corner of the page. Click on it to go to the Linode creation form.

Step 2: Select the Distribution

In this step, we need to select the operating system for your instance. Generally, the Adminer DB requires Ubuntu 18.04 LTS or a later version for compatibility and support.

We will use ServerAvatar as a server management panel. It supports Ubuntu 20.04 as well as Ubuntu 22.04. So, it is recommended to select any one of the supported OS.

Step 3: Select the Region

Linode has multiple data centers located in different regions worldwide. It is recommended to choose the region that is closest to your major traffic source to reduce latency and improve the performance of your applications.

Step 4: Select Linode Plan

Linode offers various plans with different configurations of CPU, RAM, and storage. Choose a plan that fits in your budget and meets your application's needs. With ServerAvatar, You can also host multiple applications on a single Linode VM Instance.

Step 5: Set Label and Select Tags

The label is a human-readable name that you can use to identify your instance. Tags are keywords that you can use to categorize and search for your instances. You can also group Linodes by Tags on the dashboard.

Step 6: Set Strong Root Password and Select SSH Key

The root password is the administrator password that you will use to access and manage your VM instance. Make sure to use a strong password that is hard to guess and includes a combination of uppercase and lowercase letters, numbers, and special characters.

Next, select an SSH key if you want to authenticate with SSH keys. SSH keys are a more secure way to log in to your VM instance than using passwords. If you have an SSH key, you can upload it to your Linode account and use it to log in to your VM instance.

Step 7: Select VLAN (If Required)

A VLAN is a logical network that separates traffic from different virtual machines or physical servers. It can be used to isolate network traffic and improve security.

Step 8: Select Add-ons - Backups and Private IP

Linode provides an easy way to create and store backups for your VM instances. Backups are highly recommended as they can help you with disaster recovery quickly. In the last step, You can enable the Private IP address for your VM instance if required.

Step 9: Click on "Create Linode"

Finally, Click on the Create Linode button at the end of the form to create a Linode VM instance. It usually takes around 2 minutes to create a new Linode instance. Once done, You can connect it with ServerAvatar for ease of site and server configuration management.

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 user's 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.