{"id":2550,"date":"2012-01-31T14:23:41","date_gmt":"2012-01-31T14:23:41","guid":{"rendered":"https:\/\/supportex.net\/?p=2550"},"modified":"2019-05-10T17:18:01","modified_gmt":"2019-05-10T15:18:01","slug":"phpmyadmin-mysql-servers","status":"publish","type":"post","link":"https:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/","title":{"rendered":"phpMyAdmin: how to use it with several MySQL servers"},"content":{"rendered":"<p>If you have several MySQL servers it makes sense to use one phpMyAmin to manage them. \u00a0To do it just add as many server as you need to <em>config.inc.php<\/em>. In Fedora and Centos it is located in \/etc\/phpMyAdmin\/. Here&#8217;s an example:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"php\">&lt;?php\n\n\/* Servers configuration *\/\n$i = 0;\n\n\/* Server: localhost [1] *\/\n$i++;\n$cfg['Servers'][$i]['verbose'] = '';\n$cfg['Servers'][$i]['host'] = 10.20.90.1;\n$cfg['Servers'][$i]['port'] = '';\n$cfg['Servers'][$i]['socket'] = '';\n$cfg['Servers'][$i]['connect_type'] = 'tcp';\n$cfg['Servers'][$i]['extension'] = 'mysqli';\n$cfg['Servers'][$i]['auth_type'] = 'cookie';\n\n\/* Server: 10.20.90.2 [2] *\/\n$i++;\n$cfg['Servers'][$i]['verbose'] = '';\n$cfg['Servers'][$i]['host'] = '10.20.90.2';\n$cfg['Servers'][$i]['port'] = '';\n$cfg['Servers'][$i]['socket'] = '';\n$cfg['Servers'][$i]['connect_type'] = 'tcp';\n$cfg['Servers'][$i]['extension'] = 'mysqli';\n$cfg['Servers'][$i]['auth_type'] = 'cookie';\n\n\/* End of servers configuration *\/\n\n$cfg['blowfish_secret'] = '3242fndsnj342qljds32s';\n$cfg['DefaultLang'] = 'en';\n$cfg['ServerDefault'] = 0;\n$cfg['UploadDir'] = '';\n$cfg['SaveDir'] = '';\n?&gt;<\/pre>\n<p>Now you can select which MySQL server to use before you logged in. For security reasons it&#8217;s always better to use only SSL hosts, non-root MySQL accounts and limit access to phpMyAdmin at least with IP addresses.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you have several MySQL servers it makes sense to use one phpMyAmin to manage them. \u00a0To do it just add as many server as you need to config.inc.php. In Fedora and Centos it is located in \/etc\/phpMyAdmin\/. Here&#8217;s an example: &lt;?php \/* Servers configuration *\/ $i = 0; \/* Server: localhost [1] *\/ $i++;&hellip; <\/p>\n<div class=\"readmore-wrapper\"><a href=\"https:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/\" class=\"more-link\">Read <\/a><\/div>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[152],"tags":[275,199,256],"class_list":["post-2550","post","type-post","status-publish","format-standard","hentry","category-linux","tag-linux","tag-mysql-en","tag-phpmyadmin-en"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>phpMyAdmin: how to use it with several MySQL servers &#8211; Supportex.NET blog<\/title>\n<meta name=\"description\" content=\"How to use phpMyAdmin with several MySQL servers. phpMyAdmin with multi MySQL servers\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"phpMyAdmin: how to use it with several MySQL servers &#8211; Supportex.NET blog\" \/>\n<meta property=\"og:description\" content=\"How to use phpMyAdmin with several MySQL servers. phpMyAdmin with multi MySQL servers\" \/>\n<meta property=\"og:url\" content=\"https:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/\" \/>\n<meta property=\"og:site_name\" content=\"Supportex.NET blog\" \/>\n<meta property=\"article:published_time\" content=\"2012-01-31T14:23:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-05-10T15:18:01+00:00\" \/>\n<meta name=\"author\" content=\"Oleksii Tykhonov\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oleksii Tykhonov\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/\"},\"author\":{\"name\":\"Oleksii Tykhonov\",\"@id\":\"https:\/\/supportex.net\/blog\/en\/#\/schema\/person\/0690c26a0266603129fc15eae6243251\"},\"headline\":\"phpMyAdmin: how to use it with several MySQL servers\",\"datePublished\":\"2012-01-31T14:23:41+00:00\",\"dateModified\":\"2019-05-10T15:18:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/\"},\"wordCount\":92,\"keywords\":[\"linux\",\"mysql\",\"phpMyAdmin\"],\"articleSection\":[\"linux\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/\",\"url\":\"https:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/\",\"name\":\"phpMyAdmin: how to use it with several MySQL servers &#8211; Supportex.NET blog\",\"isPartOf\":{\"@id\":\"https:\/\/supportex.net\/blog\/en\/#website\"},\"datePublished\":\"2012-01-31T14:23:41+00:00\",\"dateModified\":\"2019-05-10T15:18:01+00:00\",\"author\":{\"@id\":\"https:\/\/supportex.net\/blog\/en\/#\/schema\/person\/0690c26a0266603129fc15eae6243251\"},\"description\":\"How to use phpMyAdmin with several MySQL servers. phpMyAdmin with multi MySQL servers\",\"breadcrumb\":{\"@id\":\"https:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/supportex.net\/blog\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"phpMyAdmin: how to use it with several MySQL servers\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/supportex.net\/blog\/en\/#website\",\"url\":\"https:\/\/supportex.net\/blog\/en\/\",\"name\":\"Supportex.NET blog\",\"description\":\"Server and network management company\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/supportex.net\/blog\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/supportex.net\/blog\/en\/#\/schema\/person\/0690c26a0266603129fc15eae6243251\",\"name\":\"Oleksii Tykhonov\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/supportex.net\/blog\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4fd5f58002717075c88963469b9babef?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4fd5f58002717075c88963469b9babef?s=96&d=mm&r=g\",\"caption\":\"Oleksii Tykhonov\"},\"url\":\"https:\/\/supportex.net\/blog\/author\/oleksiitykhonov\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"phpMyAdmin: how to use it with several MySQL servers &#8211; Supportex.NET blog","description":"How to use phpMyAdmin with several MySQL servers. phpMyAdmin with multi MySQL servers","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:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/","og_locale":"en_US","og_type":"article","og_title":"phpMyAdmin: how to use it with several MySQL servers &#8211; Supportex.NET blog","og_description":"How to use phpMyAdmin with several MySQL servers. phpMyAdmin with multi MySQL servers","og_url":"https:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/","og_site_name":"Supportex.NET blog","article_published_time":"2012-01-31T14:23:41+00:00","article_modified_time":"2019-05-10T15:18:01+00:00","author":"Oleksii Tykhonov","twitter_misc":{"Written by":"Oleksii Tykhonov","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/#article","isPartOf":{"@id":"https:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/"},"author":{"name":"Oleksii Tykhonov","@id":"https:\/\/supportex.net\/blog\/en\/#\/schema\/person\/0690c26a0266603129fc15eae6243251"},"headline":"phpMyAdmin: how to use it with several MySQL servers","datePublished":"2012-01-31T14:23:41+00:00","dateModified":"2019-05-10T15:18:01+00:00","mainEntityOfPage":{"@id":"https:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/"},"wordCount":92,"keywords":["linux","mysql","phpMyAdmin"],"articleSection":["linux"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/","url":"https:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/","name":"phpMyAdmin: how to use it with several MySQL servers &#8211; Supportex.NET blog","isPartOf":{"@id":"https:\/\/supportex.net\/blog\/en\/#website"},"datePublished":"2012-01-31T14:23:41+00:00","dateModified":"2019-05-10T15:18:01+00:00","author":{"@id":"https:\/\/supportex.net\/blog\/en\/#\/schema\/person\/0690c26a0266603129fc15eae6243251"},"description":"How to use phpMyAdmin with several MySQL servers. phpMyAdmin with multi MySQL servers","breadcrumb":{"@id":"https:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/supportex.net\/blog\/2012\/01\/phpmyadmin-mysql-servers\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/supportex.net\/blog\/en\/"},{"@type":"ListItem","position":2,"name":"phpMyAdmin: how to use it with several MySQL servers"}]},{"@type":"WebSite","@id":"https:\/\/supportex.net\/blog\/en\/#website","url":"https:\/\/supportex.net\/blog\/en\/","name":"Supportex.NET blog","description":"Server and network management company","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/supportex.net\/blog\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/supportex.net\/blog\/en\/#\/schema\/person\/0690c26a0266603129fc15eae6243251","name":"Oleksii Tykhonov","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/supportex.net\/blog\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4fd5f58002717075c88963469b9babef?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4fd5f58002717075c88963469b9babef?s=96&d=mm&r=g","caption":"Oleksii Tykhonov"},"url":"https:\/\/supportex.net\/blog\/author\/oleksiitykhonov\/"}]}},"_links":{"self":[{"href":"https:\/\/supportex.net\/blog\/wp-json\/wp\/v2\/posts\/2550","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/supportex.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/supportex.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/supportex.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/supportex.net\/blog\/wp-json\/wp\/v2\/comments?post=2550"}],"version-history":[{"count":3,"href":"https:\/\/supportex.net\/blog\/wp-json\/wp\/v2\/posts\/2550\/revisions"}],"predecessor-version":[{"id":3160,"href":"https:\/\/supportex.net\/blog\/wp-json\/wp\/v2\/posts\/2550\/revisions\/3160"}],"wp:attachment":[{"href":"https:\/\/supportex.net\/blog\/wp-json\/wp\/v2\/media?parent=2550"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/supportex.net\/blog\/wp-json\/wp\/v2\/categories?post=2550"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/supportex.net\/blog\/wp-json\/wp\/v2\/tags?post=2550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}