How to Use Adminer for Database Management

What is Adminer

Adminer is a lightweight database management tool that supports multiple database systems, including MySQL, MariaDB, PostgreSQL, SQLite, among others. Compared to other database management tools, Adminer offers several notable advantages:

1. Single-File Deployment: Adminer can run with just one PHP file, making deployment and use greatly convenient.
2. Support for Multiple Databases: Adminer can manage multiple database systems, making it a versatile tool for developers.
3. Simple Interface: Adminer provides a clean and intuitive user interface, helping developers easily perform various database operations.
4. Powerful Features: Adminer supports complete database management functionalities, including creating, modifying, and deleting databases and tables, executing SQL queries, and importing and exporting data.

For developers, Adminer not only enhances work efficiency but also simplifies the complexities of database management.

Accessing Adminer

ServBay has Adminer built-in, which you can access at the following address: https://servbay.host/adminer.php

Managing ServBay's MariaDB (MySQL) Database with Adminer

Log in to the Server

1. Open a browser and go to Adminer's URL.
2. On the login screen, select the database type as "MySQL".
3. Enter the server connection information:
   • Username and password: Can be found in ServBay’s 'Settings' - 'Database'.
   • Server: localhost or /Applications/ServBay/tmp/mysql.sock
4. Click the "Login" button to enter the database management interface.

Create Database

1. After logging in successfully, click "Create Database" in the left menu.
2. Enter the database name.
3. Click the "Save" button to create the database.

Add Data

1. Select the newly created database.
2. Click "Create Table".
3. Enter the table name and field information.
4. Click the "Save" button to create the table.
5. Select the created table, and click "Insert".
6. Enter data and click the "Save" button.

Delete Data

1. Select the table to operate on.
2. Click the "Select" button, and choose the data rows to delete.
3. Click the "Delete" button to confirm the deletion.

Delete Database

1. Select the database to delete from the database list.
2. Click the "Delete" button.
3. Confirm the deletion operation.

Managing ServBay's PostgreSQL Database with Adminer

Log in to the Server

1. Open a browser and go to Adminer's URL.
2. On the login screen, select the database type as "PostgreSQL".
3. Enter the server connection information:
   • Username and password: Can be found in ServBay’s 'Settings' - 'Database'.
   • Server: /Applications/ServBay/tmp
   • Database: postgres or another manageable database with permissions
4. Click the "Login" button to enter the database management interface.

Create Database

1. After logging in successfully, click "Create Database" in the left menu.
2. Enter the database name.
3. Click the "Save" button to create the database.

Add Data

1. Select the newly created database.
2. Click "Create Table".
3. Enter the table name and field information.
4. Click the "Save" button to create the table.
5. Select the created table, and click "Insert".
6. Enter data and click the "Save" button.

Delete Data

1. Select the table to operate on.
2. Click the "Select" button, and choose the data rows to delete.
3. Click the "Delete" button to confirm the deletion.

Delete Database

1. Select the database to delete from the database list.
2. Click the "Delete" button.
3. Confirm the deletion operation.

Managing SQLite 3 Database with Adminer

Log in to the Server

1. Open a browser and go to Adminer's URL.
2. On the login screen, select the database type as "SQLite 3".
3. Enter the database file path: It is recommended to place the DB file in the /Applications/ServBay/db/sqlite directory.
4. Click the "Login" button to enter the database management interface.

Create Database

1. Enter a new database file name in the database file path.
2. Click the "Save" button to create the database.

Add Data

1. Select the newly created database.
2. Click "Create Table".
3. Enter the table name and field information.
4. Click the "Save" button to create the table.
5. Select the created table, and click "Insert".
6. Enter data and click the "Save" button.

Delete Data

1. Select the table to operate on.
2. Click the "Select" button, and choose the data rows to delete.
3. Click the "Delete" button to confirm the deletion.

Delete Database

1. Choose the database file to delete in the database file path.
2. Manually delete the file or use a file management tool to delete it.

Following these steps, you can easily manage the various database systems bundled with ServBay using Adminer. Adminer's simple interface and powerful functionalities will significantly enhance your database management efficiency.