{"id":5259,"date":"2018-05-19T19:02:00","date_gmt":"2018-05-19T19:02:00","guid":{"rendered":"https:\/\/www.truehost.co.ke\/support\/?post_type=ht_kb&p=5259"},"modified":"2024-06-07T13:03:55","modified_gmt":"2024-06-07T13:03:55","password":"","slug":"connect-mysql-database-remotely-vps-dedicated-server","status":"publish","type":"docs","link":"https:\/\/www.truehost.com\/support\/knowledge-base\/connect-mysql-database-remotely-vps-dedicated-server\/","title":{"rendered":"Connect to a MySQL database remotely from a VPS\/Dedicated Server"},"content":{"rendered":"

The best advantage of using a cloud server for web hosting is the control it offers. With a VPS or Dedicated Server, you get full control of the system and this means you can easily configure your mysql server to allow remote management. To do this, we follow the steps below:<\/p>\n

    \n
  1. Log in to the mysql server as root via terminal# mysql -u root -p <\/i>\n

    You will be promted for the root user password which you will enter to proceed.<\/li>\n

  2. Grant access to the remote user.To do this, you need to first get your IP address. Type the word myip <\/b>on google.com to get your public IP. Issue the GRANT command to grant remote access to a user:\n

    mysql> GRANT ALL ON db_name.* TO ‘user’@’remote_ip’ IDENTIFIED BY ‘user_password’;<\/i><\/span><\/span><\/li>\n<\/ol>\n

    Note: Include the quotation ma<\/i>rks in the SQL command<\/i><\/p>\n

      \n
    1. From there, access the remote computer (the computer you will use to access your database remotely). Access the config.inc.php file and add the following snippet.<\/li>\n<\/ol>\n

      $i++;<\/i><\/span><\/span><\/p>\n

      $cfg[‘Servers’][$i][‘host’] = ‘XXX.XXX.XXX.XXX’; \/\/provide hostname and port if other than default<\/i><\/span><\/span><\/p>\n

      $cfg[‘Servers’][$i][‘user’] = ‘db_username’; \/\/user name for your remote server<\/i><\/span><\/span><\/p>\n

      $cfg[‘Servers’][$i][‘password’] = ‘db_password’; \/\/password<\/i><\/span><\/span><\/p>\n

      $cfg[‘Servers’][$i][‘auth_type’] = ‘config’; \/\/ keep it as config<\/i><\/span><\/span><\/p>\n

       <\/p>\n

      <\/p>\n

       <\/p>\n

       <\/p>\n

       <\/p>\n

       <\/p>\n

       <\/p>\n

       <\/p>\n

       <\/p>\n

       <\/p>\n

       <\/p>\n

       <\/p>\n

        \n
      1. Launch phpMyAdmin and on the log in page displayed, select a the server whose IP you specified in step 3 above, then type in the log in credentials and log in. <\/span><\/li>\n<\/ol>\n

        Note:<\/i><\/span><\/p>\n

        If your phpMyAdmin does not bring a log in page, you can either configure it to load it at startup or log in with your default account and select the server at the top left. See image<\/i><\/span><\/p>\n

        <\/p>\n","protected":false},"excerpt":{"rendered":"

        The best advantage of using a cloud server for web hosting is the control it offers. With a VPS or Dedicated Server, you get full control of the system and this means you can easily configure your mysql server to allow remote management. To do this, we follow the steps below: Log in to the […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_eb_attr":"","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"doc_category":[],"doc_tag":[],"class_list":["post-5259","docs","type-docs","status-publish","hentry"],"year_month":"2026-06","word_count":296,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"w m","author_nicename":"wm","author_url":"https:\/\/www.truehost.com\/support\/author\/wm\/"},"doc_category_info":[],"doc_tag_info":[],"yoast_head":"\nConnect to a MySQL database remotely from a VPS\/Dedicated Server -<\/title>\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.truehost.com\/support\/knowledge-base\/connect-mysql-database-remotely-vps-dedicated-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connect to a MySQL database remotely from a VPS\/Dedicated Server -\" \/>\n<meta property=\"og:description\" content=\"The best advantage of using a cloud server for web hosting is the control it offers. With a VPS or Dedicated Server, you get full control of the system and this means you can easily configure your mysql server to allow remote management. To do this, we follow the steps below: Log in to the […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.truehost.com\/support\/knowledge-base\/connect-mysql-database-remotely-vps-dedicated-server\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-07T13:03:55+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/knowledge-base\\\/connect-mysql-database-remotely-vps-dedicated-server\\\/\",\"url\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/knowledge-base\\\/connect-mysql-database-remotely-vps-dedicated-server\\\/\",\"name\":\"Connect to a MySQL database remotely from a VPS\\\/Dedicated Server -\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/#website\"},\"datePublished\":\"2018-05-19T19:02:00+00:00\",\"dateModified\":\"2024-06-07T13:03:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/knowledge-base\\\/connect-mysql-database-remotely-vps-dedicated-server\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.truehost.com\\\/support\\\/knowledge-base\\\/connect-mysql-database-remotely-vps-dedicated-server\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/knowledge-base\\\/connect-mysql-database-remotely-vps-dedicated-server\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Connect to a MySQL database remotely from a VPS\\\/Dedicated Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/#website\",\"url\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/\",\"name\":\"\",\"description\":\"Help In a Click\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/#organization\",\"name\":\"Truehost Kenya\",\"url\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/cropped-image_2026-04-16_174808866.png\",\"contentUrl\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/cropped-image_2026-04-16_174808866.png\",\"width\":240,\"height\":48,\"caption\":\"Truehost Kenya\"},\"image\":{\"@id\":\"https:\\\/\\\/www.truehost.com\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Connect to a MySQL database remotely from a VPS\/Dedicated Server -","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.truehost.com\/support\/knowledge-base\/connect-mysql-database-remotely-vps-dedicated-server\/","og_locale":"en_US","og_type":"article","og_title":"Connect to a MySQL database remotely from a VPS\/Dedicated Server -","og_description":"The best advantage of using a cloud server for web hosting is the control it offers. With a VPS or Dedicated Server, you get full control of the system and this means you can easily configure your mysql server to allow remote management. To do this, we follow the steps below: Log in to the […]","og_url":"https:\/\/www.truehost.com\/support\/knowledge-base\/connect-mysql-database-remotely-vps-dedicated-server\/","article_modified_time":"2024-06-07T13:03:55+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.truehost.com\/support\/knowledge-base\/connect-mysql-database-remotely-vps-dedicated-server\/","url":"https:\/\/www.truehost.com\/support\/knowledge-base\/connect-mysql-database-remotely-vps-dedicated-server\/","name":"Connect to a MySQL database remotely from a VPS\/Dedicated Server -","isPartOf":{"@id":"https:\/\/www.truehost.com\/support\/#website"},"datePublished":"2018-05-19T19:02:00+00:00","dateModified":"2024-06-07T13:03:55+00:00","breadcrumb":{"@id":"https:\/\/www.truehost.com\/support\/knowledge-base\/connect-mysql-database-remotely-vps-dedicated-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.truehost.com\/support\/knowledge-base\/connect-mysql-database-remotely-vps-dedicated-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.truehost.com\/support\/knowledge-base\/connect-mysql-database-remotely-vps-dedicated-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.truehost.com\/support\/"},{"@type":"ListItem","position":2,"name":"Connect to a MySQL database remotely from a VPS\/Dedicated Server"}]},{"@type":"WebSite","@id":"https:\/\/www.truehost.com\/support\/#website","url":"https:\/\/www.truehost.com\/support\/","name":"","description":"Help In a Click","publisher":{"@id":"https:\/\/www.truehost.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.truehost.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.truehost.com\/support\/#organization","name":"Truehost Kenya","url":"https:\/\/www.truehost.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.truehost.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.truehost.com\/support\/wp-content\/uploads\/2026\/04\/cropped-image_2026-04-16_174808866.png","contentUrl":"https:\/\/www.truehost.com\/support\/wp-content\/uploads\/2026\/04\/cropped-image_2026-04-16_174808866.png","width":240,"height":48,"caption":"Truehost Kenya"},"image":{"@id":"https:\/\/www.truehost.com\/support\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.truehost.com\/support\/wp-json\/wp\/v2\/docs\/5259","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.truehost.com\/support\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.truehost.com\/support\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.truehost.com\/support\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.truehost.com\/support\/wp-json\/wp\/v2\/comments?post=5259"}],"version-history":[{"count":3,"href":"https:\/\/www.truehost.com\/support\/wp-json\/wp\/v2\/docs\/5259\/revisions"}],"predecessor-version":[{"id":5262,"href":"https:\/\/www.truehost.com\/support\/wp-json\/wp\/v2\/docs\/5259\/revisions\/5262"}],"wp:attachment":[{"href":"https:\/\/www.truehost.com\/support\/wp-json\/wp\/v2\/media?parent=5259"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.truehost.com\/support\/wp-json\/wp\/v2\/doc_category?post=5259"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.truehost.com\/support\/wp-json\/wp\/v2\/doc_tag?post=5259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}