1. Knowledge Base
  2. >
  3. Results
  4. >
  5. Article

Using phpMyAdmin

What is phpMyAdmin

phpMyAdmin is a Web-based database management system, which allows you to perform most database administration functions, including:
  • Create, drop and alter tables
  • Delete, edit and add fields as well as manage keys on fields
  • Execute any SQL statement
  • Query your databases
  • Manage privileges
  • Export data into various formats
  • Back up and restore your databases


Manage a MySQL Database in phpMyAdmin

After you create your database using the MySQL Management tool, you can log into phpMyAdmin to administer it.
  1. Log into your hosting control panel.
  2. Go to the Hosting Tools.
    Enter Hosting summary
  3. In the left pane, click MySQL Management.
    MySQL Management link
  4. Click Manage on the database you want to access
    Manage your domain
  5. Click on phpMyAdmin for the selected database.
    Click on phpMyAdmin.
  6. You now have access to phpMyAdmin for your database.
    phpMyAdmin 4.8.5 interface
Main phpMyAdmin Homepage
  • The left frame in phpMyAdmin is used for navigation and lists your databases and tables. As you create tables, they will show below the database name.
  • The MySQL section has links to MySQL actions.
  • The phpMyAdmin section has settings and preferences you can set as well as links to documentation and the phpMyAdmin Website.
Managing Database and Tables
To edit databases and their tables, click the database name in the left navigation area. The database homepage displays with the following main tabs:
  • Structure: The active tab shows a list of the tables in the database (if any) along with the following functions:
    • Perform actions on selected tables: Select tables, and then select an action from the With selected list, such as Drop, Empty, Optimize table and Analyze table.
    • Print view displays a printable summary of the tables in the database.
    • Data Dictionary displays the data description for the fields in each table in the database.
    • Create a new table
   

Manage a MySQL database table and its fields in phpMyAdmin

Managing Tables and Fields
You can edit tables and fields through the homepage of the table.
  1. On the left side of the program window, click on the database in which the table resides.
  2. Click on the table you want to edit to display the Structure page for the table.
The table homepage has the following main tabs:
  • Browse: Display records in the table.
    The rows and starting from record # fields allow you to choose the number of records displayed and on what record number to start. By default, 30 rows display and starting from will be the next 30 records.
    • To select your own values, enter a number in each field, and then click Show.
    • To set sorting, select a sort option, and then click Go.
  • Structure: View the fields in the table with information about them and perform the following actions:
    • Browse: Shows the field values.
    • Change: Allows you to edit field properties.
    • Drop: Allows you to delete a field.
    • Primary: Allows you to make a field primary.
    • Index: Allows you to make a field an index field.
    • Unique: Allows you to make a field unique.
    • Fulltext: Allows you to add full-text indexing on the column. Indexing can be removed or edited in the Indexing section.
    To apply these actions to multiple fields, select the checkbox to the left of the fields to edit, and then click the icon to the right of With selected.
    Printing Table Fields: Click Print view to display a list of the fields and their properties in a simple printable format.
    Adding Fields
    1. In the Add field, enter the number of fields you want to add.
    2. Indicate the location of the fields.
    3. If you selected After, select the field after which the new fields will be added.
    4. Click Go. Field definition rows display for the number of fields to be added.
    5. Complete the properties for the fields. Refer to the field descriptions in Creating Tables for details.
    6. Click Save to add the fields to the table.
  • SQL: Run SQL queries on the database.
  • Search: Search for records based on certain criteria.
  • Insert: Manually add records to the table.
  • Export: Export records from the table into various file formats.
  • Import: Upload a text file to populate a table.
  • Operations: Perform table operations, such as running table maintenance actions, renaming the table and adding table comments.
  • Empty: Empty the table of all records.
  • Drop: Remove the table from the database.
yieldmanager

Thanks for visiting! Since you landed on this page of our website, we wanted to let you know you visited one of our paid endorsers while researching your purchase. close