How to Use Adminer to Manage Databases

What is Adminer

Adminer is a lightweight database management tool that supports multiple database systems, including MySQL, MariaDB, PostgreSQL, SQLite, and more. Compared to other database management tools, Adminer has the following notable advantages:

1. Single File Deployment: Adminer runs with just one PHP file, making deployment and usage extremely convenient.
2. Multi-Database Support: Adminer can manage various 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 Functions: Adminer supports comprehensive database management functions, including creating, modifying, deleting databases and tables, executing SQL queries, importing and exporting data, etc.

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

Accessing Adminer

ServBay comes with Adminer pre-installed, and you can access Adminer via the following URL: https://servbay.host/adminer.php

Using Adminer to Manage the MariaDB (MySQL) Database Provided by ServBay

Logging into the Server

1. Open your browser and navigate to Adminer's URL.
2. In the login interface, select the database type as "MySQL."
3. Enter the server connection information:
   • Username and password: Available in ServBay under 'Settings' - 'Database.'
   • Server: localhost or /Applications/ServBay/tmp/mysql.sock
4. Click the "Login" button to enter the database management interface.

Creating a Database

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

Adding 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 the data and click the "Save" button.

Deleting Data

1. Select the table you want to operate on.
2. Click the "Select" button to choose the rows you want to delete.
3. Click the "Delete" button to confirm deletion.

Deleting a Database

1. In the database list, select the database you want to delete.
2. Click the "Delete" button.
3. Confirm the delete operation.

Using Adminer to Manage the PostgreSQL Database Provided by ServBay

Logging into the Server

1. Open your browser and navigate to Adminer's URL.
2. In the login interface, select the database type as "PostgreSQL."
3. Enter the server connection information:
   • Username and password: Available in ServBay under 'Settings' - 'Database.'
   • Server: /Applications/ServBay/tmp
   • Database: postgres or another manageable database
4. Click the "Login" button to enter the database management interface.

Creating a Database

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

Adding 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 the data and click the "Save" button.

Deleting Data

1. Select the table you want to operate on.
2. Click the "Select" button to choose the rows you want to delete.
3. Click the "Delete" button to confirm deletion.

Deleting a Database

1. In the database list, select the database you want to delete.
2. Click the "Delete" button.
3. Confirm the delete operation.

Using Adminer to Manage SQLite 3 Databases

Logging into the Server

1. Open your browser and navigate to Adminer's URL.
2. In the login interface, 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.

Creating a Database

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

Adding 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 the data and click the "Save" button.

Deleting Data

1. Select the table you want to operate on.
2. Click the "Select" button to choose the rows you want to delete.
3. Click the "Delete" button to confirm deletion.

Deleting a Database

1. In the database file path, select the database file you want to delete.
2. Manually delete the file or use a file management tool to delete it.

By following the above steps, you can easily use Adminer to manage the various database systems provided by ServBay. Adminer's simple interface and powerful functions will greatly improve your database management efficiency.