{"id":679,"date":"2010-11-16T12:58:10","date_gmt":"2010-11-16T11:58:10","guid":{"rendered":"https:\/\/www.uk-cheapest.co.uk\/support\/?p=679"},"modified":"2011-11-16T12:59:44","modified_gmt":"2011-11-16T11:59:44","slug":"how-do-i-access-mysql-databases-from-a-remote-client","status":"publish","type":"post","link":"https:\/\/www.uk-cheapest.co.uk\/support\/how-do-i-access-mysql-databases-from-a-remote-client\/","title":{"rendered":"How do I access mySql databases from a remote client?"},"content":{"rendered":"

It is possible to configure a database user in your Plesk control panel so that you may access your mySQL databases remotely – ie. directly from your home or office PC network.<\/p>\n

By default, all remote access to mySQL is blocked by the firewall, this prevents your databases being hacked externally. Remote access can only be granted to a static IP address. If you have a dynamic IP address you need to contact your internet provider and request a static IP address, some providers charge for this service.<\/p>\n

To enable remote access to a mySQL database<\/h3>\n
    \n
  1. Create a database (if not done so already)<\/li>\n
  2. Create a database user that will be used for remote access<\/li>\n
  3. Advise the\u00a0Helpdesk<\/a>\u00a0of your Static IP address<\/li>\n
  4. Allow 24 hours for the firewall to be updated<\/li>\n
  5. Once enabled you will be able to connect using port 3306<\/li>\n<\/ol>\n

    That’s all there is to it! If you have any problems simply contact the\u00a0Helpdesk<\/a>\u00a0for further assistance,<\/p>\n","protected":false},"excerpt":{"rendered":"

    It is possible to configure a database user in your Plesk control panel so that you may access your mySQL databases remotely – ie. directly from your home or office PC network. By default, all remote access to mySQL is blocked by the firewall, this prevents your databases being hacked externally. Remote access can only … Read more…<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"generate_page_header":"","footnotes":""},"categories":[79],"tags":[],"class_list":["post-679","post","type-post","status-publish","format-standard","hentry","category-phpmyadmin-support"],"yoast_head":"\nHow do I access mySql databases from a remote client? - UK-Cheapest.co.uk<\/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.uk-cheapest.co.uk\/support\/how-do-i-access-mysql-databases-from-a-remote-client\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How do I access mySql databases from a remote client?\" \/>\n<meta property=\"og:description\" content=\"It is possible to configure a database user in your Plesk control panel so that you may access your mySQL databases remotely – ie. directly from your home or office PC network. By default, all remote access to mySQL is blocked by the firewall, this prevents your databases being hacked externally. Remote access can only ... Read more...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.uk-cheapest.co.uk\/support\/how-do-i-access-mysql-databases-from-a-remote-client\/\" \/>\n<meta property=\"og:site_name\" content=\"UK-Cheapest.co.uk\" \/>\n<meta property=\"article:published_time\" content=\"2010-11-16T11:58:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2011-11-16T11:59:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.uk-cheapest.co.uk\/support\/wp-content\/uploads\/2023\/12\/IMG_3064.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"439\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"UKC\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ukchelpdesk\" \/>\n<meta name=\"twitter:site\" content=\"@ukchelpdesk\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"UKC\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated 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\":\"WebPage\",\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/how-do-i-access-mysql-databases-from-a-remote-client\/\",\"url\":\"https:\/\/www.uk-cheapest.co.uk\/support\/how-do-i-access-mysql-databases-from-a-remote-client\/\",\"name\":\"How do I access mySql databases from a remote client? - UK-Cheapest.co.uk\",\"isPartOf\":{\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/#website\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/how-do-i-access-mysql-databases-from-a-remote-client\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.uk-cheapest.co.uk\/support\/how-do-i-access-mysql-databases-from-a-remote-client\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/how-do-i-access-mysql-databases-from-a-remote-client\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"UK-Cheapest.co.uk\",\"item\":\"https:\/\/www.uk-cheapest.co.uk\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How do I access mySql databases from a remote client?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/#website\",\"url\":\"https:\/\/www.uk-cheapest.co.uk\/support\/\",\"name\":\"UK-Cheapest.co.uk\",\"description\":\"Cheap Domain Names, Web Hosting, Site Builder & Web Security\",\"publisher\":{\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.uk-cheapest.co.uk\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/#organization\",\"name\":\"UKC\",\"url\":\"https:\/\/www.uk-cheapest.co.uk\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.uk-cheapest.co.uk\/support\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-14-at-17.40.07.png\",\"contentUrl\":\"https:\/\/www.uk-cheapest.co.uk\/support\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-14-at-17.40.07.png\",\"width\":217,\"height\":55,\"caption\":\"UKC\"},\"image\":{\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/ukchelpdesk\",\"https:\/\/www.instagram.com\/ukc_hosting\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/#\/schema\/person\/135cf981b8a3a120603fcbc027eed746\",\"name\":\"UKC\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.uk-cheapest.co.uk\/support\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f39b95f178ec21ebe3134a71baa1146d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f39b95f178ec21ebe3134a71baa1146d?s=96&d=mm&r=g\",\"caption\":\"UKC\"},\"sameAs\":[\"https:\/\/www.uk-cheapest.co.uk\"],\"url\":\"https:\/\/www.uk-cheapest.co.uk\/support\/author\/colin\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How do I access mySql databases from a remote client? - UK-Cheapest.co.uk","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.uk-cheapest.co.uk\/support\/how-do-i-access-mysql-databases-from-a-remote-client\/","og_locale":"en_GB","og_type":"article","og_title":"How do I access mySql databases from a remote client?","og_description":"It is possible to configure a database user in your Plesk control panel so that you may access your mySQL databases remotely – ie. directly from your home or office PC network. By default, all remote access to mySQL is blocked by the firewall, this prevents your databases being hacked externally. Remote access can only ... Read more...","og_url":"https:\/\/www.uk-cheapest.co.uk\/support\/how-do-i-access-mysql-databases-from-a-remote-client\/","og_site_name":"UK-Cheapest.co.uk","article_published_time":"2010-11-16T11:58:10+00:00","article_modified_time":"2011-11-16T11:59:44+00:00","og_image":[{"width":768,"height":439,"url":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-content\/uploads\/2023\/12\/IMG_3064.jpeg","type":"image\/jpeg"}],"author":"UKC","twitter_card":"summary_large_image","twitter_creator":"@ukchelpdesk","twitter_site":"@ukchelpdesk","twitter_misc":{"Written by":"UKC","Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/how-do-i-access-mysql-databases-from-a-remote-client\/","url":"https:\/\/www.uk-cheapest.co.uk\/support\/how-do-i-access-mysql-databases-from-a-remote-client\/","name":"How do I access mySql databases from a remote client? - UK-Cheapest.co.uk","isPartOf":{"@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#website"},"breadcrumb":{"@id":"https:\/\/www.uk-cheapest.co.uk\/support\/how-do-i-access-mysql-databases-from-a-remote-client\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.uk-cheapest.co.uk\/support\/how-do-i-access-mysql-databases-from-a-remote-client\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/how-do-i-access-mysql-databases-from-a-remote-client\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"UK-Cheapest.co.uk","item":"https:\/\/www.uk-cheapest.co.uk\/support\/"},{"@type":"ListItem","position":2,"name":"How do I access mySql databases from a remote client?"}]},{"@type":"WebSite","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#website","url":"https:\/\/www.uk-cheapest.co.uk\/support\/","name":"UK-Cheapest.co.uk","description":"Cheap Domain Names, Web Hosting, Site Builder & Web Security","publisher":{"@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.uk-cheapest.co.uk\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#organization","name":"UKC","url":"https:\/\/www.uk-cheapest.co.uk\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-14-at-17.40.07.png","contentUrl":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-14-at-17.40.07.png","width":217,"height":55,"caption":"UKC"},"image":{"@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/ukchelpdesk","https:\/\/www.instagram.com\/ukc_hosting\/"]},{"@type":"Person","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#\/schema\/person\/135cf981b8a3a120603fcbc027eed746","name":"UKC","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f39b95f178ec21ebe3134a71baa1146d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f39b95f178ec21ebe3134a71baa1146d?s=96&d=mm&r=g","caption":"UKC"},"sameAs":["https:\/\/www.uk-cheapest.co.uk"],"url":"https:\/\/www.uk-cheapest.co.uk\/support\/author\/colin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/posts\/679"}],"collection":[{"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/comments?post=679"}],"version-history":[{"count":1,"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/posts\/679\/revisions"}],"predecessor-version":[{"id":680,"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/posts\/679\/revisions\/680"}],"wp:attachment":[{"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/media?parent=679"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/categories?post=679"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/tags?post=679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}