phpMyAdmin

phpMyAdmin is an open source tool written in PHP intended to handle the administration of MySQL. phpMyAdmin is enabled on all Fastdot cPanel web hosting accounts.

Articles:

Searching through a database with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin Now let’s learn how to use the Search feature Click the database you wish to search here Then click the Search button Enter words or values to search for in the database. There are several options you can use to refine your search. This database only

See More

Renaming database tables with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin Now let’s learn how to rename database tables Click the database table you wish to rename Then click the Operations button Enter a new name for the table here Then click Go That’s it! The information table has been renamed infotable, and is listed here This

See More

Running SQL queries on a database with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin Now let’s learn how to run SQL queries on a database Click the database table you wish to run a SQL query on As demonstrated in another tutorial, you can delete (or drop) a field from a table by selecting it here then clicking the drop

See More

Modifying fields in database tables with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin Now let’s learn how to modify fields in database tables Select the details table here Let’s modify the address field Click the Change icon Make the changes you want, then click Save That’s it! We’ve successfully changed the name of the address field to city This

See More

Inserting fields into database tables with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin Now let’s learn how to insert fields into database tables Select the details table here In this case, let’s choose to add an address field AFTER the name field Click Save when finished That’s it! Our details table now has a new address field This is

See More

Importing databases and tables with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin Now let’s learn how to import a database Click the database you wish to import here Let’s assume the data in our details table is corrupt, and we want to import a saved (exported) copy of the data. Therefore, let’s first delete the existing details table

See More

Databases in phpMyAdmin

This tutorial and video will discuss how to manage and use databases in phpMyAdmin This tutorial assumes you’ve already logged in to phpMyAdmin. From this phpMyAdmin screen, we have access directly to the database demo1234_members, listed here. A database consists of one or more tables, and it is in the tables that database information is

See More

Export databases with phpMyAdmin

This tutorial will show you how to export databases with phpMyAdmin Click the database you wish to export here Then click the Export button In this case, we want to export the entire database in SQL format, so we can easily import it later. This is a good way to backup your database Be sure

See More

Deleting tables from a database with phpMyAdmin

This tutorial will show you the steps for deleting tables from a database with phpMyAdmin Select the table you wish to delete here You can delete individual fields from this table by selecting them here then clicking the delete icon here However, in this tutorial we’re going to demonstrate how to delete the entire table

See More

Deleting fields from database tables with phpMyAdmin

This tutorial will show you the steps for deleting fields from database tables with phpMyAdmin Now let’s learn how to delete fields from database tables Select the details table here Let’s delete the city field Click the Delete (or Drop) icon Click Yes to confirm That’s it! We’ve successfully deleted the city field from our

See More