How to Use phpMyAdmin to Manage Databases

What is phpMyAdmin

phpMyAdmin is a widely used open-source database management tool, specifically designed for managing MySQL and MariaDB databases. It provides a web-based user interface, making database management more intuitive and convenient. phpMyAdmin has the following notable advantages:

1. Versatile: Supports most MySQL and MariaDB functionalities, such as managing databases, tables, fields, relations, indexes, users, and permissions.
2. User-friendly: Provides an easy-to-use graphical interface to help users effortlessly perform various database operations.
3. Multilingual Support: Supports multiple languages, making it suitable for global users.
4. Highly Extensible: Supports plugins and script extensions, allowing users to customize as needed.

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

Accessing phpMyAdmin

ServBay comes with phpMyAdmin pre-installed, and you can access it at the following URL: https://servbay.host/phpmyadmin

Using phpMyAdmin to Manage the Built-in MariaDB (MySQL) Database of ServBay

Logging into the Server

1. Open Browser: Access the phpMyAdmin URL.
2. Enter Connection Information: Input server connection details on the login page:
   • Username and Password: Obtainable from 'Settings' - 'Database' in ServBay.
   • Server: default or specific version.
3. Log in: Click the "Log in" button to enter the database management interface.

Creating a Database

1. Enter Database Management Interface: After logging in, click "Databases" in the left menu.
2. Create a New Database:
   • Enter the database name in the "Create database" field.
   • Select character set (optional).
   • Click the "Create" button to create the database.

Creating a Table

1. Choose Database: Select the newly created database from the left menu.
2. Create a Table:
   • Click "Create table".
   • Input table name and field information (e.g., field name, type, length, default value, etc.).
   • Click the "Save" button to create the table.

Adding Data

1. Choose Table: Select the table you want to operate on from the left menu.
2. Insert Data:
   • Click "Insert".
   • Input data values.
   • Click the "Go" button to save the data.

Querying Data

1. Choose Table: Select the table you want to operate on from the left menu.
2. Browse Data:
   • Click "Browse" to view data in the table.
   • Use the query feature to filter data.

Updating Data

1. Choose Table: Select the table you want to operate on from the left menu.
2. Edit Data:
   • Click "Browse" to view data.
   • Locate the data row to edit and click the "Edit" icon.
   • Modify data values.
   • Click the "Go" button to save changes.

Deleting Data

1. Choose Table: Select the table you want to operate on from the left menu.
2. Delete Data:
   • Click "Browse" to view data.
   • Select the data row to delete by checking the corresponding checkbox.
   • Click the "Delete" button to confirm deletion.

Deleting a Table

1. Choose Database: Select the database containing the table to delete from the left menu.
2. Delete Table:
   • In the database structure view, select the table to delete.
   • Click the "Drop" button.
   • Confirm the deletion.

Deleting a Database

1. Choose Database: Select the database to delete from the left menu.
2. Delete Database:
   • Click the "Operations" tab.
   • Scroll to the bottom of the page and click the "Drop the database" button.
   • Confirm the deletion.

By following the steps above, you can easily manage the built-in MariaDB (MySQL) database of ServBay using phpMyAdmin. Its user-friendly interface and powerful functions will greatly enhance your database management efficiency. Whether it’s creating databases, tables, or inserting, querying, updating, and deleting data, phpMyAdmin provides a convenient operating experience.