Home » Knowledgebase » Database » MySQL » How to use phpMyAdmin to manage the mySQL database?

How to use phpMyAdmin to manage the mySQL database?

How to use phpMyAdmin to manage the mySQL database?

You can read this article if you have difficulties in inputting the database information in the phpMyAdmin.

To open the phpMyAdmin, you can browse the link, http://phpmyadmin.mysite4now.com/, with your web browser and you will see the following page.
( you can also open it with Hosting Control Panel -> Database -> MySql manager )

To create connection to your database, please type in the database information and click on the Go button.

After you login with your database user, the main page of phpMyAdmin will show up and there are many function for you to choose. The following picture will show the simple description of links/icons.

To manage your database, please click on the link with your database name. You will see the main page of your database.

You can create table with the bottom function by typing the new table info and clicking on "Go".

You also see some icon

. They represent different function to manage your table.
Here is the list of the function.

- to browse your data

- to manage your table structure

- to search your data in the table

- to insert new data to your table

- to empty your table

- to drop the table from the database

To run your query,
1) You can open the query window from the main page of phpMyAdmin,
2) or you can click on the Query Tab in the database page.

Tags:

database, database tools, mysql, phpmyadmin