phpMyAdmin tutorial – Quick start guide for beginners
Today, almost all of the websites, web portals or cloud-based online applications use databases in the back-end.
You may sometimes have to access your respective databases to – create/modify/delete – new tables, data or databases. This task is quite difficult without the proper knowledge of MySQL commands and tools – because a minor mistake may lead to database corruption and hence the functional impact on the web portal.
Don’t worry – phpMyAdmin is here for you!!
Objectives of this article:
- What is phpMyAdmin?
- History of phpMyAdmin
- Why and who uses phpmyadmin?
- Main features of phpMyAdmin
- What database operation can be performed using phyMyAdmin?
- How to install and configure phpmyadmin on Windows and Linux?
- How to create a database using phpmyadmin?
- How to create a table using phpmyadmin?
- How to run queries using phpmyadmin?
- How to import and export the database in phpMyAdmin?
- How to Change WordPress Theme via phpMyAdmin
What is phpMyAdmin?
phpMyAdmin has become one of the most popular web-based application for MySQL database management.
phpMyAdmin is a free and open-source administration tool for MySQL. It is a browser-based tool for MySQL administration.
phpMyAmin is written in PHP language and provides a simple web interface to users. Being a portable web application written in PHP language, it was known as one of the most popular MySQL administration tools for web developers and hosting services.
It allows you to manage MySQL users, tables, databases and user privileges.
phpMyAmin also enables you to simply import/export databases using web-based interface. Hence, its now very simple to take backup of MySQL DB in any format (SQL, CSV, XML, etc).
Yes, you got it right!
phpMyAmin is open source free software, designed to handle the administration and management of MySQL databases through a graphic user interface
History of phpMyAdmin
Tobias Ratschiller, then an IT consultant and later founder of the software company Maguma, started to work on a PHP-based web front-end to MySQL in 1998, inspired by Peter Kuppelwieser’s MySQL-Webadmin. He gave up the project (and phpAdsNew, of which he was also the original author) in 2000 because of lack of time.
By that time, phpMyAdmin had already become one of the most popular PHP applications and MySQL administration tools, with a large community of users and contributors. In order to coordinate the growing number of patches, a group of three developers, Olivier Müller, Marc Delisle, and Loïc Chapeaux, registered the phpMyAdmin project at SourceForge.net and took over the development in 2001. Since 2015 the development is completely based on GitHub.
The magic behind phpMyAdmin Name!
The phpMyAdmin name is obviously a mixture of PHP as the language it uses, MySQL as the database it manages and administration as the activity it handles. Even though the name seems to be quite simple, many people mix it up and they refer to phpMyAdmin under different names, such as myphpadmin, phpadmin, phpmysqladmin (these are the three most frequent Google searches going to this website aside from the correctly spelled variant).
Why phpMyAdmin & who uses it?
Bringing MySQL to the Web interface rather than the command-line interface (CLI).
This user-friendly web-based MySQL interface enables you to interact with your databases easily. It is used by – web developers, administrators, users, and web hosting services.
phpMyAdmin allows you to create, alter, drop, delete, import and export MySQL database tables. You can run MySQL queries, optimize, repair and check tables, change collation and execute other database management commands.
Main features of phpMyAdmin
The phpMyAdmin tutorial guide:
- Provides a web-based simple interface to administer your MySQL databases
- MySQL and MariaDB database management
- Administering multiple servers
- Support phpMyAdmin on both Windows and Linux-based servers.
- Import data from CSV and SQL
- Modify or alter any value in your databases, tables.
- Export data to multiple formats: SQL, CSV, PDF, and XML (via the TCPDF library), ISO/IEC 26300 – OpenDocument Text and Spreadsheet, Word, Excel, LaTeX, and others
- Run SQL queries to interact with your databases and perform various operations.
- Create and remove databases whenever required
- Creating PDF graphics of the database layout
- Creating complex queries using Query-by-example (QBE)
- Searching globally in a database or a subset of it
- Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link
- Live charts to monitor MySQL server activity like connections, processes, CPU/memory usage, etc.
- Working with different operating systems
- Make complex SQL queries easier.
A full list of all the features phpMyAdmin has can be found at the official project page.
Conclusion & Caution!
With great power comes great responsibility. phpMyAdmin allows you to interact with the database directly: it also lets you mess up the database directly. There is no “undo” or “undelete” in your database. Always exercise caution when working with the database.