PHP and MySQL are becoming more and more popular due to their amazing way to store and retrieve data. Although being able to create and edit a MySQL database with PHP alone is a great skill to have, learning how to use a program to do it for you – such as phpMyAdmin – can greatly reduce your work load and stress. Thus, this article presents how to create a MySQL Database with phpMyAdmin.
For those of you unfamiliar with phpMyAdmin, it is a feature provided by most web hosts to manage MySQL databases with ease. Just look up the basic MySQL information about your host to access it.
When first opening phpMyAdmin, you will receive a screen looking like this:
To create your first MySQL database, type in a name under create new database. In this case, I used the name my_database
Once you have hit create, you should be redirected to the following page:
Continue the process by entering a name for a new table and the number of fields:
This should result in:
At this point, you can type in names, types, lengths, etc. for each field in the MySQL database that your require:
Once you submit this last part, you are done! Your new MySQL database is up and running:
If you know any other programs that help to manage MySQL databases, much like phpMyAdmin, please share them with the rest of us in a comment below!