{"id":3794,"date":"2020-03-04T15:54:36","date_gmt":"2020-03-04T15:54:36","guid":{"rendered":"https:\/\/lamp.ciscoar.com\/?page_id=3794"},"modified":"2020-04-08T21:54:20","modified_gmt":"2020-04-08T21:54:20","slug":"phpmyadmin","status":"publish","type":"page","link":"https:\/\/lamp.ciscoar.com\/?page_id=3794","title":{"rendered":"phpMyAdmin"},"content":{"rendered":"\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"199\" height=\"111\" src=\"https:\/\/lamp.ciscoar.com\/wp-content\/uploads\/2020\/01\/PhpMyAdmin_logo_199x111.png\" alt=\"\" class=\"wp-image-1715\"\/><figcaption>phpMyAdmin logo<\/figcaption><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">What&#8217;s phpMyAdmin?<\/h2>\n\n\n\n<p> phpMyAdmin is a free software tool written in PHP and HTML, intended to handle the administration of MySQL (and MariaDB) via a local&nbsp;<strong>website&nbsp;<\/strong>specifically made for that purpose, phpMyAdmin allows database administrators to do most of the common operations on MySQL and also MariaDB. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What can I do with phpMyAdmin?<\/h2>\n\n\n\n<p>Frequently used operations when managing databases, like dealing with tables, columns, relations, indexes, users, permissions, etc, can be performed via the friendly&nbsp;<strong>GUI&nbsp;<\/strong>(Graphical User Interface) provided by phpMyAdmin, while you still have the ability to directly execute any SQL statement on the&nbsp;<strong>CLI&nbsp;<\/strong>(Command Line Interface). <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Let&#8217;s start using phpMyAdmin<\/h2>\n\n\n\n<p>The logical requirement is to have both <a rel=\"noreferrer noopener\" aria-label=\"PHP  (opens in a new tab)\" href=\"\/php\/\" target=\"_blank\">PHP <\/a>and also MySQL (or <a rel=\"noreferrer noopener\" aria-label=\"MariaDB (opens in a new tab)\" href=\"\/mysql\/\" target=\"_blank\">MariaDB<\/a>) already installed on your system, otherwise it make no sense to install phpMyAdmin.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"\/installing-phpmyadmin-on-centos-7\/\">How to install phpMyAdmin on CentOS 7<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>What&#8217;s phpMyAdmin? phpMyAdmin is a free software tool written in PHP and HTML, intended to handle the administration of MySQL (and MariaDB) via a local&nbsp;website&nbsp;specifically made for that purpose, phpMyAdmin allows database administrators to do most of the common operations on MySQL and also MariaDB. What can I do with phpMyAdmin? Frequently used operations when &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/lamp.ciscoar.com\/?page_id=3794\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;phpMyAdmin&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-3794","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/pages\/3794","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3794"}],"version-history":[{"count":15,"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/pages\/3794\/revisions"}],"predecessor-version":[{"id":4874,"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=\/wp\/v2\/pages\/3794\/revisions\/4874"}],"wp:attachment":[{"href":"https:\/\/lamp.ciscoar.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}