{"id":6304,"date":"2023-08-18T11:28:56","date_gmt":"2023-08-18T11:28:56","guid":{"rendered":"https:\/\/www.webhi.com\/how-to\/?p=6304"},"modified":"2023-08-18T11:28:58","modified_gmt":"2023-08-18T11:28:58","slug":"mysql-database-management-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.webhi.com\/how-to\/mysql-database-management-phpmyadmin\/","title":{"rendered":"MySQL Database management with phpMyAdmin"},"content":{"rendered":"\n
\"MySQL<\/figure>\n\n\n\n

PhpMyAdmin is a free and open source tool written in PHP that allows you to easily manage MySQL databases through a web interface. With PhpMyAdmin, you can create and configure databases, create\/edit\/drop tables, insert data, execute SQL queries and manage users.<\/p>\n\n\n\n

In this article we will go through the key things you can do in phpMyAdmin to manage your MySQL databases and tables.<\/p>\n\n\n\n

Login to phpMyAdmin<\/h2>\n\n\n\n

To access the phpMyAdmin interface, you just need to navigate to the url where it is hosted, usually something like:<\/p>\n\n\n\n

http:\/\/localhost\/phpmyadmin<\/code><\/pre>\n\n\n\n
Or<\/p>\n\n\n\n
http:\/\/ip-address\/phpmyadmin<\/code><\/pre>\n\n\n\n
Depending on how it has been setup.<\/p>\n\n\n\n
You will be presented with a login screen where you need to enter your MySQL username and password. These are the credentials you use to normally access MySQL and not specific phpMyAdmin credentials.<\/p>\n\n\n\n
\"phpmyadmin<\/figure>\n\n\n\n
Once logged in, you will be taken to the main dashboard which displays the existing databases.<\/p>\n\n\n\n
Creating a New Database<\/h2>\n\n\n\n
To create a new database, click on the “New” link near the top left.<\/p>\n\n\n\n
\"phpmyadmin<\/figure>\n\n\n\n
This will bring up a form where you need to enter the name for your new database. Make sure you choose a descriptive name relevant to the application.<\/p>\n\n\n\n
Once you enter the name, click Create and the new database will be instantiated. The dashboard will now display the new database in the list.<\/p>\n\n\n\n
Editing and Deleting a Database<\/h2>\n\n\n\n
To edit or delete an existing database, check the checkbox beside it’s name in the dashboard then click Operations.<\/p>\n\n\n\n
This will give you the options to Edit or Delete it. Edit allows you to change the name.<\/p>\n\n\n\n
Deleting will completely remove the database and all tables and data contained within. Make sure you really want to delete it before clicking Delete.<\/p>\n\n\n\n
Creating Tables<\/h2>\n\n\n\n
To create a new table, click on the database you want to create it in from the dashboard.<\/p>\n\n\n\n
This will show you a list of existing tables (if any) and options to create a new table.<\/p>\n\n\n\n
Click the New button to bring up the Create Table form.<\/p>\n\n\n\n
Here you need to enter the Name for your table and specify the number of columns\/fields.<\/p>\n\n\n\n
For each field you need to set:<\/p>\n\n\n\n