{"id":17304,"date":"2015-06-09T15:16:53","date_gmt":"2015-06-09T20:16:53","guid":{"rendered":"https:\/\/secure.rosehosting.com\/blog\/?p=17304"},"modified":"2022-12-15T06:42:00","modified_gmt":"2022-12-15T12:42:00","slug":"install-adminer-on-a-centos-vps","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/","title":{"rendered":"Install Adminer on CentOS"},"content":{"rendered":"
<\/div>
\"How
How to Install Adminer on CentOS<\/figcaption><\/figure>\n

\"installingToday we will show you how to install\u00a0Adminer on CentOS<\/strong>. Adminer is a database management tool written in PHP. It is similar to phpMyAdmin and it is developed to improve security, user experience, performance etc. It is very lightweight and at the same time, it is very powerful. Today we are going to show you how to install Adminer on a Linux VPS<\/a>. Installing Adminer on CentOS is an easy task and it should take less than 10 minutes to complete. Let’s get started!
\n<\/p>\n

Adminer is written in PHP and it requires PHP 5 to be installed on your VPS. It works with MySQL, PostgreSQL, SQLite, Oracle, MS SQL, MongoDB, and other database systems. Some of the Adminer features are connecting to a database server with a username and password, selecting existing databases or creating new ones, export databases to SQL or CSV and many more. The full list of features can be found at http:\/\/www.adminer.org\/<\/a> which is the official Adminer website.
\nTo install Adminer on your CentOS VPS<\/a>, you need to log in to your server via SSH and execute several commands. If you do not know how to log in to your server via SSH<\/a>, we recommend you to check our guide about this topic. Otherwise, you are ready to go.<\/p>\n

The first thing you need to do is to create a directory for Adminer and download the Adminer installation. For this purpose you can use the following command:<\/p>\n

mkdir \/usr\/share\/adminer && cd \/usr\/share\/adminer && wget http:\/\/downloads.sourceforge.net\/adminer\/adminer-4.2.1.php -O index.php\r\n<\/pre>\n
Once Adminer is downloaded in your \/usr\/share\/adminer directory, next step is to configure your Apache web server. Create and edit the \/etc\/httpd\/conf.d\/adminer.conf file with the following command:<\/p>\n
nano \/etc\/httpd\/conf.d\/adminer.conf<\/pre>\n
Add the following content to that file:<\/p>\n
Alias \/adminer \"\/usr\/share\/adminer\"\r\n<Directory \"\/usr\/share\/adminer\">\r\n        AllowOverride All\r\n        Options FollowSymlinks\r\n        Order deny,allow\r\n        Deny from all\r\n        Allow from 111.111.111.111\r\n<\/Directory>\r\n<\/pre>\n
Please do not forget to replace 111.111.111.111 with your local IP address because you will not be able to access Adminer using a web browser. To find your IP address you can use this helpful tool.<\/p>\n
https:\/\/www.whatismyip.com\/<\/a><\/pre>\n
After you enter your local IP address, save the file and close it.<\/p>\n
The last step is to restart your Apache web server. To restart your Apache web server you can use the following command:<\/p>\n
\/etc\/init.d\/httpd restart<\/pre>\n
Congratulation, you are ready to use Adminer now.
\nTo access the web interface, you need to open your favorite web browser and navigate to:<\/p>\n
http:\/\/yourdomain.com\/adminer<\/pre>\n
or<\/p>\n
http:\/\/IP-address\/adminer<\/pre>\n
Please do not forget to replace yourdomain.com with one of your domain names hosted on the same server, or IP-address with the IP address of your server.<\/p>\n
To log in, you can use your MySQL root user and password, or any other database user and its password.<\/p>\n
For additional help or useful information, we recommend you to check the official Adminer web site.<\/p>\n
\n
\"installOf course, you don\u2019t have to do any of this if you use one of our Linux VPS hosting services<\/a>, in which case you can simply ask our expert Linux admins to install Adminer for you. They are available 24\u00d77 and will take care of your request immediately.<\/p>\n
PS. If you liked this post please share it with your friends on social networks or simply leave a reply below. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"
Today we will show you how to install\u00a0Adminer on CentOS. Adminer is a database management tool written in PHP. It … <\/p>\n
Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":28973,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1699,1702,13],"tags":[837,832,831],"yoast_head":"\nInstall Adminer on CentOS - RoseHosting<\/title>\n<meta name=\"description\" content=\"Install Adminer on CentOS - RoseHosting\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Install Adminer on CentOS - RoseHosting\" \/>\n<meta property=\"og:description\" content=\"Install Adminer on CentOS - RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/\" \/>\n<meta property=\"og:site_name\" content=\"RoseHosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RoseHosting\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/rosehosting.helpdesk\" \/>\n<meta property=\"article:published_time\" content=\"2015-06-09T20:16:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-15T12:42:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/06\/How-to-Install-Adminer-on-CentOS.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"742\" \/>\n\t<meta property=\"og:image:height\" content=\"372\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:site\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"Install Adminer on CentOS\",\"datePublished\":\"2015-06-09T20:16:53+00:00\",\"dateModified\":\"2022-12-15T12:42:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/\"},\"wordCount\":530,\"commentCount\":5,\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/06\/How-to-Install-Adminer-on-CentOS.jpg\",\"keywords\":[\"adminer\",\"adminer linux vps\",\"install adminer linux\"],\"articleSection\":[\"CentOS\",\"Databases\",\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/\",\"name\":\"Install Adminer on CentOS - RoseHosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/06\/How-to-Install-Adminer-on-CentOS.jpg\",\"datePublished\":\"2015-06-09T20:16:53+00:00\",\"dateModified\":\"2022-12-15T12:42:00+00:00\",\"description\":\"Install Adminer on CentOS - RoseHosting\",\"breadcrumb\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/#primaryimage\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/06\/How-to-Install-Adminer-on-CentOS.jpg\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/06\/How-to-Install-Adminer-on-CentOS.jpg\",\"width\":742,\"height\":372,\"caption\":\"How to Install Adminer on CentOS\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.rosehosting.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Install Adminer on CentOS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"name\":\"RoseHosting\",\"description\":\"Premium Linux Tutorials Since 2001\",\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\",\"name\":\"RoseHosting\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"width\":192,\"height\":192,\"caption\":\"RoseHosting\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/RoseHosting\",\"https:\/\/x.com\/rosehosting\",\"https:\/\/www.linkedin.com\/in\/rosehosting\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g\",\"caption\":\"Jeff Wilson\"},\"description\":\"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.\",\"sameAs\":[\"https:\/\/www.rosehosting.com\",\"https:\/\/www.facebook.com\/rosehosting.helpdesk\"],\"url\":\"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Install Adminer on CentOS - RoseHosting","description":"Install Adminer on CentOS - RoseHosting","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/","og_locale":"en_US","og_type":"article","og_title":"Install Adminer on CentOS - RoseHosting","og_description":"Install Adminer on CentOS - RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2015-06-09T20:16:53+00:00","article_modified_time":"2022-12-15T12:42:00+00:00","og_image":[{"width":742,"height":372,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/06\/How-to-Install-Adminer-on-CentOS.jpg","type":"image\/jpeg"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"Install Adminer on CentOS","datePublished":"2015-06-09T20:16:53+00:00","dateModified":"2022-12-15T12:42:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/"},"wordCount":530,"commentCount":5,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/06\/How-to-Install-Adminer-on-CentOS.jpg","keywords":["adminer","adminer linux vps","install adminer linux"],"articleSection":["CentOS","Databases","Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/","url":"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/","name":"Install Adminer on CentOS - RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/06\/How-to-Install-Adminer-on-CentOS.jpg","datePublished":"2015-06-09T20:16:53+00:00","dateModified":"2022-12-15T12:42:00+00:00","description":"Install Adminer on CentOS - RoseHosting","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/06\/How-to-Install-Adminer-on-CentOS.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/06\/How-to-Install-Adminer-on-CentOS.jpg","width":742,"height":372,"caption":"How to Install Adminer on CentOS"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/install-adminer-on-a-centos-vps\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Install Adminer on CentOS"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting","description":"Premium Linux Tutorials Since 2001","publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rosehosting.com\/blog\/#organization","name":"RoseHosting","url":"https:\/\/www.rosehosting.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","width":192,"height":192,"caption":"RoseHosting"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RoseHosting","https:\/\/x.com\/rosehosting","https:\/\/www.linkedin.com\/in\/rosehosting\/"]},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g","caption":"Jeff Wilson"},"description":"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.","sameAs":["https:\/\/www.rosehosting.com","https:\/\/www.facebook.com\/rosehosting.helpdesk"],"url":"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/17304"}],"collection":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/comments?post=17304"}],"version-history":[{"count":3,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/17304\/revisions"}],"predecessor-version":[{"id":44290,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/17304\/revisions\/44290"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/28973"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=17304"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=17304"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=17304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}