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

Managing 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 in to your Account Manager.
2. On the left pane, click on Hosting.

   

3. Under the Configurations section, click on Database Manager.

   

4. In the MySQL Database section, look for the database name you want to access and then click its Admin » button on the right.

   

5. A new window tab will open for phpMyAdmin. You now have access to the phpMyAdmin, where you can view and manage your databases.

   

    

What's on my 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 the database names below.
• 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.

phpMyAdmin MySQL Databases and Tables

To edit databases and their tables, click the database name on the left navigation area. The database homepage displays 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

• SQL: Run SQL queries on the database.
• Search: Search in the database for designated words or phrases.
• Query: Build and submit queries.
• Export: Export the data and structure of tables in the database in various file formats.
• Import: Import tables.
• Operations: Perform database operations: create a new table, rename a database, and copy a database.

Managing a MySQL database table and its fields

You can edit tables and fields through the table's homepage.

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 primary tabs:

• Browse: Display records in the table.
  The rows and starting from record # fields allow you to choose the number of records displayed and the record number to start with. By default, 30 rows will be displayed, and starting from them will be the next 30 records.
  • To select your 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 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 select After, select the field after which the new fields will be added.
  4. Click Go. Field definition rows display 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.