Home » Hosting Encyclopedia » Hosting Terms » Database » phpMyAdmin

phpMyAdmin

PhpMyAdmin is a program written mainly in PHP (also with CSS and JavaScript) for the management of website databases. phpMyAdmin is an open-source tool with a web-based interface that can be accessed via any web browser. It is created especially for the administration of MySQL databases and can be used on any operating system. Another great advantage of the phpMyAdmin is that it is available in multiple languages (currently translated in 68 languages). phpMyAdmin was initially released in 1998 and since then it has become one of the most widely used applications for the management of MySQL databases.

 

PhpMyAdmin Features

Using the graphic interface of PHPMyAdmin you can easily make, delete or edit databases and manage all their elements: tables with their rows and columns, indexes, fields, statements, and queries. You can control users’ permissions and administer several servers simultaneously. PhpMyAdmin will help you to easily synchronize databases and search through them, import text files and monitor changes in your databases. You can execute complex quires and SQL statements, create and edit functions, events, and triggers. With phpMyAdmin, you can back up your databases and export data into different formats including CSV (comma-separated values), SQL, XML, PDF, OpenDocument Text and Spreadsheet, Word, Excel, LATEX, etc. PhpMyAmin supports foreign keys, MySQL and InnoDB.

Was this article useful?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Newest Articles:

What is a WordPress Sitemap

A WordPress sitemap is a file, which contains data about your site – pages, text, media, links, tags, and information on how they relate to each other. There are two types of sitemaps – XML and HTML maps. An XML Sitemap is a file that lists all your site content in an...

What is an Anchor Text in WordPress

Anchor texts provide you with a handy way of linking to internal or external pages in a very natural way. This is why they are widely used and often seen on various web pages. Furthermore, anchors are a ranking factor, and when used correctly, can contribute to your...

KVM

What you need to know: KVM (Kernel-based Virtual Machine) is a virtualization technology that is free, open-source, and available in most modern Linux distributions. Thanks to it, you can create and run Linux and Windows-based virtual machines that are independent of...

Second Level Domain (SLD)

The Second Level Domain or SLD is an essential part of the hierarchical Domain Name System. It is the second part of the full domain name after the Top Level Domain, on its left side. The Second Level Domain is often the same as the website name, the company or the...

Top-Level Domain (TLD)

The Top Level Domain name (TLD) is the last or right-most fragment of the domain name. The parts of the domain name are separated with dots and form their own hierarchy in the Domain Name System (DNS). There is a Top-Leveл Domain list where you can see all available...

Ready to Create Your Website?