Loading...

Knowledge Base
Up to 75% off on hosting for WordPress websites and online stores

How to Manage a Database Using PhpMyAdmin

Working with databases can be a complex and confusing process. Fortunately, phpMyAdmin provides an easy-to-use and easy-to-understand interface to administer your database(s). phpMyAdmin is available through your Bluehost cPanel under the databases section.

What is phpMyAdmin?

phpMyAdmin is a software tool written in PHP intended to handle the administration of MySQL via a web browser. It provides an easy-to-use graphical interface to manage your databases, tables, fields, and relationships. With phpMyAdmin, you can manage databases, tables, fields, relations, indexes, users, permissions, etc.. At the same time, you can still execute SQL statements directly.

How to Access phpMyAdmin

via the Websites Tab

  1. Log in to your Bluehost Account Manager.
  2. Click the Websites tab from the left-side navigation, then click the SETTINGS button for the website you would like to access phpMyAdmin.
    Websites tab on left menu and Settings button for website
  3. Search for the Quick Links tile and click the PHPMYADMIN button.
    Websites tab on left menu and Settings button for website

via the Hosting Tab

  1. Log in to your Bluehost Account Manager.
  2. Select the Hosting tab from the left navigation menu.
  3. Search for the Quick Links tile and click the CPANEL button.
    Cpanel button under Quick Links
  4. Go to Databases, then click phpMyAdmin.
    phpMyAdmin icon under Databases

Viewing the Home Screen

You will see options on the phpMyAdmin home page, such as Collation, Language, and Font size. There are also links to Documentation, wiki, and the official homepage for phpMyAdmin.
php-home-page

Managing a Database Using phpMyAdmin

Creating a Database & Database User

Before using phpMyAdmin, you must create your database from within the Bluehost cPanel. Please see How to Create and Delete MySQL Databases and Users for specific instructions on creating databases and database users.

Selecting the Database

To view the structure of your databases, click on the database name in the home page's left column. Alternatively, click on the Databases tab at the top of the screen. Clicking on the name of the database shows the structure of the database. The structure shows individual table names that make up your database.
php-my-admin-database

Browsing the Database

Once you have selected the database, click the 1st icon (browse) under the action beside the table name while in the structure view. The Browse view displays rows of data in the database (if applicable). A link to 'Create PHP Code' is also based on the current view. To navigate through the rows of data, you should click the > or >> buttons or choose a page number from the drop-down box.   
php-my-admin-browse

Viewing MySQL Processes

You may view the current MySQL processes running by selecting the Processes tab while on the home page of phpMyAdmin. To kill a process, click the Kill link to the left of the process ID number.
php-status-processes

Performing Common Functions in phpMyAdmin

Searches & SQL Queries

Databases Functions

Manipulating Tables

Manipulating Columns

Summary

phpMyAdmin is a powerful tool that simplifies managing MySQL databases. With its easy-to-use interface, you can manage a database using phpMyAdmin to create and manipulate databases, tables, fields, and relationships with just a few clicks. Whether you are an experienced developer or a beginner, phpMyAdmin can help you do the job efficiently and effectively. If you encounter any issues while using phpMyAdmin, don't hesitate to contact the support team for assistance.

If you need further assistance, feel free to contact us via Chat or Phone:

  • Chat Support - While on our website, you should see a CHAT bubble in the bottom right-hand corner of the page. Click anywhere on the bubble to begin a chat session.
  • Phone Support -
    • US: 888-401-4678
    • International: +1 801-765-9400

You may also refer to our Knowledge Base articles to help answer common questions and guide you through various setup, configuration, and troubleshooting steps.

Did you find this article helpful?

 
* Your feedback is too short

Loading...