PhpMyAdmin is a free, open-source web-based tool that allows you to manage MySQL and MariaDB databases. It offers an intuitive user interface to perform common database tasks such as creating, modifying, and deleting tables, users, and databases. Always create a complete backup of your site before making any major changes in phpMyAdmin, so you can revert to the previous state if any issues arise during the upgrade process.
You have the ability to administer your database using phpMyAdmin and carry out a range of tasks. In this discussion, we'll cover some fundamental actions you can execute within the phpMyAdmin dashboard.
Managing Database with phpMyAdmin
1. Creating a database
Click on the Databases tab from the top menu and press “New” from the left side menu.
Enter a name for your new database, choose a collation from the drop-down menu and press the Create button.
Creating tables
Choose your database from the left-side menu and click on it. For example, we will use “Test”.
In the Create Table section, enter a name for the table and specify the number of columns. Finally hit the Create button.
Make necessary changes in each column and drop-down menu, Add table comments and Choose the collection and Storage Engine. After every modification is done press the Save button to create the table.
Inserting data
Enter the table you want to edit, first click on the existing table from the left side menu. (For Example Here We Use “Demo Table”)
Click the Insert tab at the top menu and include necessary data.
Finally press the Go button to add the Values to the table.
Modifying data
Go to the desired table by clicking on it from the left-side menu.
Click the Browse tab to view the table's data.
Now press the Edit button (a pencil icon) next to the row you want to modify.
Make the necessary changes and click Go to save.
Deleting data
Click on your table in the left sidebar.
Click the Browse tab to view the table's data.
Check the box next to the row(s) you want to delete.
Select Delete from the With selected dropdown menu and confirm the action.
Managing users
Click on the User accounts tab at the top.
To create a new user, click Add user account and fill in the necessary information.
To modify an existing user, click Edit privileges next to the user.
To delete a user, click the box next to the user and confirm the action by clicking Go in Remove selected user accounts box.
Exporting and Importing databases
Click on your database in the left sidebar.
To export, click the Export tab, choose a format, and click Export key to download the database.
To import, click the Import tab choose the file you want to import, and click Import key from the bottom of the page.
For more Information
PhpMyAdmin has its own comprehensive documentation. The documentation covers various aspects of using the software, such as installation, configuration, managing databases, tables, and records, and working with SQL queries. You can find the official documentation on the phpMyAdmin website:
Keep in mind that as the software gets updated, new features may be added, and the documentation may change accordingly. Always refer to the latest version of the documentation for the most up-to-date information.