{"id":6521,"date":"2018-12-20T15:28:46","date_gmt":"2018-12-20T15:28:46","guid":{"rendered":"https:\/\/www.siliconhouse.net\/support\/?page_id=6521"},"modified":"2018-12-20T15:41:37","modified_gmt":"2018-12-20T15:41:37","slug":"phpmyadmin-cpanel","status":"publish","type":"page","link":"https:\/\/www.siliconhouse.net\/support\/phpmyadmin-cpanel\/","title":{"rendered":"How do i access phpMyAdmin using sub domain via separate URL?"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/www.siliconhouse.net\/dedicated-servers-managed\"> Linux dedicated servers<\/a> and <a href=\"https:\/\/www.siliconhouse.net\/linux-reseller-web-hosting-india\">reseller hosting<\/a> comes with cPanel\/whm where the clients can perform various kind of operation according to their requirements. cPanel provides phpmyadmin using that we can drop databases, create\/drop\/alter tables, delete\/edit\/add fields, execute any SQL statement, manage keys on fields, and export data into various formats.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\n\n<aside id=\"text-16\" class=\"widget widget_text amr_widget\">\t\t\t<div class=\"textwidget\"><div class=\"reseller_web_hosting_support_advts\">\r\n\r\n<div class=\"reseller_web_hosting_support_advts_left\">\r\n<a href=\"https:\/\/www.siliconhouse.net\/linux-reseller-web-hosting-india\" target=\"_blank\"><img decoding=\"async\" border=\"0\" src=\"https:\/\/www.siliconhouse.net\/wp-content\/uploads\/2018\/06\/336X280-saffron-unlimited-499-kickstart.gif\" width=\"336\" height=\"280\" alt=\"Reseller Hosting Special Offer\"><\/a>\r\n<\/div>\r\n\r\n<div class=\"reseller_web_hosting_support_advts_right\">\r\n<a href=\"https:\/\/www.siliconhouse.net\/linux-cloud-server-hosting-india\" target=\"_blank\"><img decoding=\"async\" border=\"0\" src=\"https:\/\/www.siliconhouse.net\/wp-content\/uploads\/2018\/06\/336X280-purple-enterprise-cloud-stak-19.jpg\" width=\"336\" height=\"280\" alt=\"Enterprise Cloud Stack\"><\/a>\r\n<\/div>\r\n\r\n<\/div><\/div>\n\t\t<\/aside><aside id=\"text-20\" class=\"extendedwopts-md-center widget widget_text amr_widget\">\t\t\t<div class=\"textwidget\"><div class=\"reseller_web_hosting_support_advts\">\r\n<div class=\"reseller_web_hosting_support_advts_left\">\r\n<img decoding=\"async\" border=\"0\" src=\"http:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/12\/reseller-hosting-249-offer.gif\" width=\"320\" height=\"100\" alt=\"Reseller Hosting Special Offer\">\r\n<\/div>\r\n\r\n<div class=\"reseller_web_hosting_support_advts_right\">\r\n<img decoding=\"async\" border=\"0\" src=\"http:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/12\/reseller-hosting-249-offer.gif\" width=\"320\" height=\"100\" alt=\"Reseller Hosting Special Offer\">\r\n<\/div>\r\n\r\n<\/div><\/div>\n\t\t<\/aside>\n\n<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kindly follow the below procedure to access phpmyadmin using sub domain,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Installing PHP MY ADMIN<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><br>1.Download the phpMyAdmin at&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/files.phpmyadmin.net\/phpMyAdmin\/4.0.10.20\/phpMyAdmin-4.0.10.20-english.tar.gz\" target=\"_blank\">https:\/\/files.phpmyadmin.net\/phpMyAdmin\/4.0.10.20\/phpMyAdmin-4.0.10.20-english.tar.gz<\/a>&nbsp;according to your phpmyadmin version<br>NOTE: Download the release phpMyAdmin-4.0.10.20-english.tar.gz<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2.Upload the downloaded tar file ( ex: phpMyAdmin-4.0.10.20-english.tar.gz ) into public_html folder of your domain and then extract it.&nbsp;IMPORTANT : Rename the folder phpMyAdmin-4.0.10.20 so that you can call the phpmyadmin control panel with that name. Rename phpMyAdmin-4.0.10.20 with a different folder name like &#8220;care3d&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3.Now go to the folder where php my admin is uploaded [ for example &#8220;care3d&#8221; ] and rename the file config.sample.inc.php as config.inc.php<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4.Open the file in config.inc.php in file manager and look for the line below line<br>$cfg[&#8216;blowfish_secret&#8217;] = &#8216;a8b7c6d&#8217;; \/* YOU MUST FILL IN THIS FOR COOKIE AUTH! *\/<br>In this line instead of &#8216;a8b7c6d&#8217; give a strong secret like &#8216;ru476%$yfu8%&amp;fugiw93jfi&#8217; and save the file<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5.Now you can access your php my admin at&nbsp;<a rel=\"noreferrer noopener\" href=\"http:\/\/yourdomain.com\/phpmyadminfoldername\" target=\"_blank\">http:\/\/yourdomain.com\/phpmyadminfoldername<\/a>&nbsp;[ for example :&nbsp;<a rel=\"noreferrer noopener\" href=\"http:\/\/www.yourdomain.com\/care3d\" target=\"_blank\">http:\/\/www.yourdomain.com\/care3d<\/a>&nbsp;]&nbsp; &nbsp; &nbsp;Now you can login using cpanel user name and password or using your database user name and password<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">6.To secure your php my admin folder, go to the folder where php my admin is installed [ example : care3d ]. Create a .htaccess file using file manager. Open .htaccess in file manager and place the following lines in it and save it. In the place of ip address, put your internet ip address. You can get it from&nbsp;<a rel=\"noreferrer noopener\" href=\"http:\/\/www.getmyip.co.in\/\" target=\"_blank\">www.getmyip.co.in<\/a>Options -Indexesdeny from allallow from 78.34.5.6 [ Put your ip address here ]<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once you have done this you can access your phpmyadmin only from ips that are allowed in this .htaccess file.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">WARNING ! : Once you have completed your work in your database and feel that php my admin will not be used in future, please remove the folder for security reasons. We do not advise you to use outdated versions <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Linux dedicated servers and reseller hosting comes with cPanel\/whm where the clients can perform various kind of operation according to<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-6521","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How do i access phpmyadmin using sub domain via separate URL?<\/title>\n<meta name=\"description\" content=\"phpmyadmin in cpanel used to drop databases, create\/drop\/alter tables, delete\/edit\/add fields, execute SQL statement, manage keys on fields, export data.\" \/>\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.siliconhouse.net\/support\/phpmyadmin-cpanel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How do i access phpmyadmin using sub domain via separate URL?\" \/>\n<meta property=\"og:description\" content=\"phpmyadmin in cpanel used to drop databases, create\/drop\/alter tables, delete\/edit\/add fields, execute SQL statement, manage keys on fields, export data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.siliconhouse.net\/support\/phpmyadmin-cpanel\/\" \/>\n<meta property=\"og:site_name\" content=\"Silicon House - Reseller Hosting - Dedicated Servers - Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/siliconhouse.net\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-20T15:41:37+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@siliconhouse\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/phpmyadmin-cpanel\\\/\",\"url\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/phpmyadmin-cpanel\\\/\",\"name\":\"How do i access phpmyadmin using sub domain via separate URL?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/#website\"},\"datePublished\":\"2018-12-20T15:28:46+00:00\",\"dateModified\":\"2018-12-20T15:41:37+00:00\",\"description\":\"phpmyadmin in cpanel used to drop databases, create\\\/drop\\\/alter tables, delete\\\/edit\\\/add fields, execute SQL statement, manage keys on fields, export data.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/phpmyadmin-cpanel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/phpmyadmin-cpanel\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/phpmyadmin-cpanel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How do i access phpMyAdmin using sub domain via separate URL?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/#website\",\"url\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/\",\"name\":\"Silicon House - Reseller Hosting - Dedicated Servers - Cloud\",\"description\":\"Reseller Hosting - Dedicated Servers - Cloud\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/#organization\",\"name\":\"Silicon House\",\"url\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/wp-content\\\/uploads\\\/2016\\\/10\\\/siliconhouse-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/wp-content\\\/uploads\\\/2016\\\/10\\\/siliconhouse-logo.png\",\"width\":42,\"height\":40,\"caption\":\"Silicon House\"},\"image\":{\"@id\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/siliconhouse.net\",\"https:\\\/\\\/x.com\\\/siliconhouse\",\"https:\\\/\\\/www.youtube.com\\\/siliconhouse\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How do i access phpmyadmin using sub domain via separate URL?","description":"phpmyadmin in cpanel used to drop databases, create\/drop\/alter tables, delete\/edit\/add fields, execute SQL statement, manage keys on fields, export data.","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.siliconhouse.net\/support\/phpmyadmin-cpanel\/","og_locale":"en_US","og_type":"article","og_title":"How do i access phpmyadmin using sub domain via separate URL?","og_description":"phpmyadmin in cpanel used to drop databases, create\/drop\/alter tables, delete\/edit\/add fields, execute SQL statement, manage keys on fields, export data.","og_url":"https:\/\/www.siliconhouse.net\/support\/phpmyadmin-cpanel\/","og_site_name":"Silicon House - Reseller Hosting - Dedicated Servers - Cloud","article_publisher":"https:\/\/www.facebook.com\/siliconhouse.net","article_modified_time":"2018-12-20T15:41:37+00:00","twitter_card":"summary_large_image","twitter_site":"@siliconhouse","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.siliconhouse.net\/support\/phpmyadmin-cpanel\/","url":"https:\/\/www.siliconhouse.net\/support\/phpmyadmin-cpanel\/","name":"How do i access phpmyadmin using sub domain via separate URL?","isPartOf":{"@id":"https:\/\/www.siliconhouse.net\/support\/#website"},"datePublished":"2018-12-20T15:28:46+00:00","dateModified":"2018-12-20T15:41:37+00:00","description":"phpmyadmin in cpanel used to drop databases, create\/drop\/alter tables, delete\/edit\/add fields, execute SQL statement, manage keys on fields, export data.","breadcrumb":{"@id":"https:\/\/www.siliconhouse.net\/support\/phpmyadmin-cpanel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.siliconhouse.net\/support\/phpmyadmin-cpanel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.siliconhouse.net\/support\/phpmyadmin-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.siliconhouse.net\/support\/"},{"@type":"ListItem","position":2,"name":"How do i access phpMyAdmin using sub domain via separate URL?"}]},{"@type":"WebSite","@id":"https:\/\/www.siliconhouse.net\/support\/#website","url":"https:\/\/www.siliconhouse.net\/support\/","name":"Silicon House - Reseller Hosting - Dedicated Servers - Cloud","description":"Reseller Hosting - Dedicated Servers - Cloud","publisher":{"@id":"https:\/\/www.siliconhouse.net\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.siliconhouse.net\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.siliconhouse.net\/support\/#organization","name":"Silicon House","url":"https:\/\/www.siliconhouse.net\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.siliconhouse.net\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/10\/siliconhouse-logo.png","contentUrl":"https:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/10\/siliconhouse-logo.png","width":42,"height":40,"caption":"Silicon House"},"image":{"@id":"https:\/\/www.siliconhouse.net\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/siliconhouse.net","https:\/\/x.com\/siliconhouse","https:\/\/www.youtube.com\/siliconhouse"]}]}},"_links":{"self":[{"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages\/6521","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/comments?post=6521"}],"version-history":[{"count":3,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages\/6521\/revisions"}],"predecessor-version":[{"id":6543,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages\/6521\/revisions\/6543"}],"wp:attachment":[{"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/media?parent=6521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}