What is phpMyAdmin?

Posted:  May 14th, 2018

 

phpMyAdmin is a free and open source administration tool for MySQL and MariaDB. As a portable web application written primarily in PHP, it has become one of the most popular MySQL administration tools, especially for web hosting services.

 

In addition, PHP is a server-side scripting language used to write interactive web pages. Most of the interactivity in web pages involves reading from or writing to databases. MySQL is a database management program commonly used in small and medium sized websites. (It does on a web server roughly what Microsoft Access does on your local computer.)

 

PHP and MySQL work well together, so they're commonly mentioned together as php/mysql.

 

With phpMyAdmin you can create and modify MySQL databases. It's a good tool for doing this.

 

When developing a website where there's database interactivity, it's very useful to be able to easily get in and mess directly with the database. A web page which reads or writes to a database generally is pretty fixed in its queries (Select field1, field2 from table where field3=whatever and field4 < somethingelse). When developing, you have to get that SQL right, so with phpmyadmin you can not only go in and tweak the values in the database to create various situations to see if your queries work. You can also paste (or write) an SQL query directly into phpmyadmin to amke sure it does whatever you want it to do.

 

And finally, when you have your site up and running, you can even use it to go in and look at or tweak the live database, as is sometimes necessary.

 

 

Features provided by the program include:

 

1) Web interface

 

2) MySQL and MariaDB database management

 

3) Import data from CSV and SQL

 

4) Export data to various formats: CSV, SQL, XML, PDF (via the TCPDF library), ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel, LaTeX and others

 

5) Administering multiple servers

 

6) Creating PDF graphics of the database layout

 

7) Creating complex queries using query-by-example (QBE)

 

8) Searching globally in a database or a subset of it

 

9) Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link

 

10) Live charts to monitor MySQL server activity like connections, processes, CPU/memory usage, etc.

 

11) Working with different operating systems.

 

12) Make complex SQL queries easier.

 

 

Article sourced from Wikipedia.org

 

https://en.wikipedia.org/wiki/PhpMyAdmin