When working with Databases, it is common to use a database administration tool. It can be very tedious to administer a database through command lines.
A popular tool designed for this purpose is PhpMyAdmin. This free tool allows us to administer our database through a graphical user interface (GUI). At the same time, it preserves the ability to directly execute SQL statements to our DB.
PhpMyAdmin offers many commonly used administrative operations. This includes the ability to create, delete and modify databases, tables, columns, relations, indexes, users and permissions. We can also do many other tasks including:
This list is not exhaustive, and the tool provides many other features.
Since PhpMyAdmin is an open source tool, it is very popular in the web development community. There is a wide range of documentation and support available for it.
If you are taking this course as part of the Web Development Masterclass, you don't have to worry about installing PhpMyAdmin. It comes standard with our installation of WAMP/MAMP.
We have also already installed it on our live testing server as part of one of the packages we configured during setup (LAMP Stack).
To access PhpMyAdmin on your local computer, click on your WAMP/MAMP icon. Make sure your server is running (green). From the Menu, select "PhpMyAdmin".
Alternatively, you can plugin localhost/phpmyadmin in your web address bar.