Skip to main content
All CollectionsWordPress & PHP TroubleshootingPHP
Managing Your Database with phpMyAdmin
Managing Your Database with phpMyAdmin

Tips and tricks for efficiently managing your database using phpMyAdmin for optimal performance and security.

Rapyd Team avatar
Written by Rapyd Team
Updated over a week ago

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.

    Creating a database

  • Enter a name for your new database, choose a collation from the drop-down menu and press the Create button.


    Entering a name for your new database

Creating tables

  • Choose your database from the left-side menu and click on it. For example, we will use “Test”.


    Creating tables

  • In the Create Table section, enter a name for the table and specify the number of columns. Finally hit the Create button.


    Entering a name for the table and specify the number of columns

  • 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.


    Making necessary changes in each column and drop-down menu, Add table comments and Choose the collection and Storage Engine

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”)


    Inserting data
  • Click the Insert tab at the top menu and include necessary data.

    Click the Insert tab at the top menu and include necessary data
  • Finally press the Go button to add the Values to the table.

    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.


    Modifying 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.


    Deleting 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.


    Managing users

  • To create a new user, click Add user account and fill in the necessary information.


    Add user account

  • To modify an existing user, click Edit privileges next to the user.


    Edit privileges

  • To delete a user, click the box next to the user and confirm the action by clicking Go in Remove selected user accounts box.


    Remove selected user account

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.


    Exporting databases

  • To import, click the Import tab choose the file you want to import, and click Import key from the bottom of the page.


    Importing databases

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.

Did this answer your question?