This site utilizes JavaScript to function correctly. Looks like it's disabled on your browser. Please enable it for your best experience.

For instructions on enabling JavaScript, click here

Skip to main content

Just Host Web Hosting Help

Managing Your DB 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 Just Host cPanel under the databases section.

phpMyAdmin is a software tool written in PHP, intended to handle the administration of MySQL via a web browser. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute SQL statements.

phpMyAdmin can be accessed via your cPanel and is integrated with your Just Host hosting account.


Basic Functions of phpMyAdmin:

Creating a database & database user:

Before you can get started using phpMyAdmin, you must create your database from within the Just Host cPanel. For specific instructions on creating databases and database users, Click Here

Accessing phpMyAdmin

Login to cPanel and click the phpMyAdmin icon in the Databases section.

Viewing the home screen:

At the phpMyAdmin home page, you will see option such as Collation, Language and Font size. There are also links to Documentation, wiki and the official homepage for phpMyAdmin.

Selecting the Database:

To view the structure of your databases, simply click on the database name in the left column of the home page. Alternatively you may click on the databases tab along the top of the screen. Clicking on the name of the database shows the structure of the database. The structure shows individual table names which make up your database.

Browse the Database:

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

View MySQL Processes:

You may view the current MySQL processes running by selecting the "Processes" tab while at the home page of phpMyAdmin. To kill a process simply click the 'kill' link to the left of the process id number.


Performing Common Functions in phpMyAdmin

Searches & SQL Queries

Databases Functions

Manipulating Tables

Manipulating Columns

Knowledgebase Article 376,658 views bookmark tags: commands database mysql phpmyadmin


Was this resource helpful?

Did this resolve your issue?


Please add any other comments or suggestions about this content:





Recommended Help Content

How do I import a backup of my database (.sql file) using phpMyAdmin?
Knowledgebase Article 783,023 views tags: database mysql phpmyadmin

A guide to duplicating a MySQL database using phpMyAdmin
Knowledgebase Article 244,134 views tags: databases mysql phpmyadmin

A tutorial on how to perminately delete columns from your mySQL database using phpMyAdmin
Knowledgebase Article 189,522 views tags: Plesk cpanel databases mysql phpmyadmin

Related Help Content

How to Restore your MySQL Database?
Knowledgebase Article 384,950 views tags: admin database mysql php phpmyadmin restore

A guide on performing a standard SQL query using the phpMyAdmin interface
Knowledgebase Article 192,931 views tags: databases mysql phpmyadmin

Guidance on adding tables to your mySQL database in phpMyAdmin
Knowledgebase Article 115,250 views tags: mysql phpmyadmin

How to repair and optimize your database using phpMyAdmin:
Knowledgebase Article 442,985 views tags: database mysql optimizing repairing slow speed

This article will show you how to rename a database table in phpMyAdmin.
Knowledgebase Article 323,645 views tags: databases mysql phpmyadmin

Step by step directions on how you can search your database using phpMyAdmin
Knowledgebase Article 186,011 views tags: Plesk cpanel databases mysql phpmyadmin

I am prompted to set a new MySQL password. What does this mean and how do I change it?
Knowledgebase Article 250,550 views tags: connect database mysql password phpmyadmin username

This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database.
Knowledgebase Article 875,136 views tags: creation database mysql

** Google ad credits are only available to customers in the United States, Canada, and the United Kingdom at this time.

¹ VAT (Value Added Tax) is not included in our advertised price and will be charged separately and itemized on invoices and billing information. Standard VAT rates based on EU Member State regulations may apply. Learn more.