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 several notable advantages:

1. Versatile: Supports most MySQL and MariaDB features, such as managing databases, tables, fields, relationships, indexes, users, and permissions.
2. User-Friendly: Offers an easy-to-use graphical interface to help users perform various database operations effortlessly.
3. Multi-Language Support: Available in 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 boosts productivity but also simplifies the complexities of database management.

Accessing phpMyAdmin

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

Managing ServBay's Built-in MariaDB (MySQL) Databases with phpMyAdmin

Logging into the Server

1. Open a Browser: Access the phpMyAdmin URL.
2. Enter Connection Information: Input server connection details on the login page:
   • Username and Password: Obtainable from ServBay's 'Settings' - 'Database'.
   • 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: Upon successful login, click “Databases” in the left menu.
2. Create a New Database:
   • Enter the database name in the “Create database” field.
   • Choose a character set (optional).
   • Click the “Create” button to create the database.

Creating a Table

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

Adding Data

1. Select a Table: Choose the table you wish to operate on from the left menu.
2. Insert Data:
   • Click “Insert”.
   • Enter the data values.
   • Click the “Go” button to save the data.

Querying Data

1. Select a Table: Choose the table you wish to operate on from the left menu.
2. Browse Data:
   • Click “Browse” to view the data in the table.
   • Use the query feature to filter data if necessary.

Updating Data

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

Deleting Data

1. Select a Table: Choose the table you wish to operate on from the left menu.
2. Delete Data:
   • Click “Browse” to view data.
   • Select the row(s) you wish to delete by checking the corresponding checkbox.
   • Click the “Delete” button to confirm deletion.

Dropping a Table

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

Dropping a Database

1. Select Database: Choose the database you want 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 operation.

By following the above steps, you can easily use phpMyAdmin to manage ServBay's built-in MariaDB (MySQL) databases. phpMyAdmin's user-friendly interface and powerful features will significantly enhance your database management efficiency. Whether creating databases, tables, or inserting, querying, updating, and deleting data, phpMyAdmin offers a convenient user experience.