{"id":1629,"date":"2015-12-17T03:55:41","date_gmt":"2015-12-17T09:55:41","guid":{"rendered":"http:\/\/www.supportpro.com\/blog\/?p=1629"},"modified":"2019-08-21T07:01:08","modified_gmt":"2019-08-21T13:01:08","slug":"adminer","status":"publish","type":"post","link":"https:\/\/www.supportpro.com\/blog\/adminer\/","title":{"rendered":"Adminer"},"content":{"rendered":"<p><strong>Adminer<\/strong> is a fully featured database management tool written in PHP. Adminer is an alternative to <a href=\"https:\/\/www.phpmyadmin.net\/\">phpMyAdmin<\/a> where we can manage content in MySQL, SQLite, Oracle, PostgreSQL databases effectively.<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>Adminer Features<\/strong><\/span><\/p>\n<p>&gt; Basic functions : Add\/remove\/modify the databases and tables<br \/>\n&gt; Modify database objects (views, triggers, procedures, user permissions, variables, processes etc.)<br \/>\n&gt; Execute SQL commands from a text field or a file.<br \/>\n&gt; Import and export databases and tables.<br \/>\n&gt; Export database, data, structure, views, routines to SQL or CSV.<!--more--><\/p>\n<p><span style=\"text-decoration: underline;\"><strong>Prerequisites<\/strong><\/span><\/p>\n<p>&gt; Apache webserver<br \/>\n&gt; Supports PHP 5 with enabled sessions<br \/>\n&gt; Database (MySQL, PostgreSQL, SQLite, MongoDB, etc.)<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>Installation of Adminer in Linux<\/strong><\/span><\/p>\n<p>Download the latest source file and extract it in the document root :<\/p>\n<p>[root@demo public_html]# wget http:\/\/downloads.sourceforge.net\/adminer\/adminer-4.0.2.zip<br \/>\n[root@demo public_html]# unzip adminer-4.0.2.zip<br \/>\n[root@demo public_html]# chown -R nobody. adminer-4.0.2<\/p>\n<p>Finally, open and point to your browser at \u2018adminer\u2018 directory.<\/p>\n<p>http:\/\/localhost\/adminer-4.02\/adminer<br \/>\nor<br \/>\nhttp:\/\/ip-address\/adminer-4.02\/adminer<\/p>\n<p>Enter your username and password of your database to login into a panel.<\/p>\n<p><a href=\"https:\/\/www.supportpro.com\/requestquote.php\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone wp-image-1630 size-full\" src=\"https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2016\/01\/adminer1.jpg\" alt=\"login page of adminer\" width=\"780\" height=\"356\" srcset=\"https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2016\/01\/adminer1.jpg 780w, https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2016\/01\/adminer1-300x137.jpg 300w\" sizes=\"(max-width: 780px) 100vw, 780px\" \/><\/a><\/p>\n<p>Creating a database :<\/p>\n<p><a href=\"https:\/\/www.supportpro.com\/requestquote.php\"><img decoding=\"async\" class=\"alignnone wp-image-1631 size-full\" src=\"https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2016\/01\/adminer2.jpg\" alt=\"Creating a database in adminer\" width=\"700\" height=\"348\" srcset=\"https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2016\/01\/adminer2.jpg 700w, https:\/\/www.supportpro.com\/blog\/wp-content\/uploads\/2016\/01\/adminer2-300x149.jpg 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>Thus the database has been created.<\/p>\n<p>If you require help, <a href=\"https:\/\/www.supportpro.com\/requestquote.php\">contact SupportPRO Server Admin<\/a><\/p>\n<p style=\"text-align: center;\"><!--HubSpot Call-to-Action Code --><span id=\"hs-cta-wrapper-9d590242-d641-4383-94b4-8cfd62f0af6b\" class=\"hs-cta-wrapper\"><span id=\"hs-cta-9d590242-d641-4383-94b4-8cfd62f0af6b\" class=\"hs-cta-node hs-cta-9d590242-d641-4383-94b4-8cfd62f0af6b\"><!-- [if lte IE 8]><\/p>\n\n\n\n\n\n<div id=\"hs-cta-ie-element\"><\/div>\n\n\n<![endif]--><a href=\"https:\/\/www.supportpro.com\/requestquote.php\"><img decoding=\"async\" id=\"hs-cta-img-9d590242-d641-4383-94b4-8cfd62f0af6b\" class=\"hs-cta-img\" style=\"border-width: 0px;\" src=\"https:\/\/no-cache.hubspot.com\/cta\/default\/2725694\/9d590242-d641-4383-94b4-8cfd62f0af6b.png\" alt=\"Server not running properly? Get A FREE Server Checkup By Expert Server Admins - $125 Value\" \/><\/a><\/span><script charset=\"utf-8\" src=\"https:\/\/js.hscta.net\/cta\/current.js\"><\/script><script type=\"text\/javascript\"> hbspt.cta.load(2725694, '9d590242-d641-4383-94b4-8cfd62f0af6b', {}); <\/script><\/span><!-- end HubSpot Call-to-Action Code --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Adminer is a fully featured database management tool written in PHP. Adminer is an alternative to phpMyAdmin where we can manage content in MySQL, SQLite, Oracle, PostgreSQL databases effectively. Adminer&hellip;<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[6,1],"tags":[],"class_list":["post-1629","post","type-post","status-publish","format-standard","hentry","category-linux-basics","category-miscellaneous"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/posts\/1629","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/comments?post=1629"}],"version-history":[{"count":4,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/posts\/1629\/revisions"}],"predecessor-version":[{"id":4102,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/posts\/1629\/revisions\/4102"}],"wp:attachment":[{"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/media?parent=1629"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/categories?post=1629"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/tags?post=1629"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}