What is the difference between Mysql and phpMyAdmin?

Asked

Viewed 10,816 times

26

What’s the difference between Mysql and phpMyAdmin?

mysql phpmyadmin

1 answer

42


What is the Mysql?

Mysql is a server that works by TCP, but not by HTTP, in installations like Xampp and Wamp it is not connected directly to Apache or PHP, it is actually a server of database totally separate that can be installed even on a computer other than the same network or an external network that is accessible and is on a port other than HTTP.

Him no folder browsing like HTTP servers it stays on a different port, while Apache, Ngnix, Lighttpd usually stay on ports like 80, 8000, 8080, 9000, while Mysql most often stays on port 3306.

When dynamic languages or software access Mysql it actually only sends "commands" to the mysql server via TCP, similar to "terminal" commands (it is possible to install mysql on a machine and use as client to access a Mysql server, may be on the same machine or not).

What is phpMyAdmin?

phpMyAdmin is not a server, it is a "manager" written in and , i.e., it is an application and should not be used by other applications accessible to other users, it is a tool that should be used only by the database administrator and sometimes by those who maintain the scripts (for example PHP), it is not part of Mysql, it is not a database, it is only a tool to facilitate the management of the database and there are alternatives to it.

Applications like PHP don’t connect to it, it is an application that runs alongside Apache and PHP and the only relation with Mysql is that it (phpMyAdmin) connects to Mysql at the time of running SWEETHEARTS, as well as a normal web page using database.

As the website itself says https://www.phpmyadmin.net/:

A tool Written in PHP intended to Handle the Administration of Mysql over the WWW.

translating:
It is a tool written in PHP intended to handle Mysql administration over WWW.

Extra:

To know the difference of Xampp, Wamp, Easyphp read the following question:

  • 1

    Nor will I answer, that answer is enough!

  • 2

    I think the Workbench is far more powerful.

  • 1

    @Jorgeb. For sure :D ... the problem is that the last version for windows is bugged, it’s been about 4 months :/ ... I’m using Heidesql, very good too

  • @Guilhermenascimento uses linux :D

Browser other questions tagged mysql phpmyadmin

You are not signed in. Login or sign up in order to post.