{"id":2880,"date":"2024-02-09T11:22:00","date_gmt":"2024-02-09T10:22:00","guid":{"rendered":"https:\/\/www.easyhost.be\/en\/help\/?post_type=ht_kb&#038;p=2880"},"modified":"2024-12-11T11:39:29","modified_gmt":"2024-12-11T10:39:29","slug":"how-to-connect-to-my-database-from-my-own-computer","status":"publish","type":"ht_kb","link":"https:\/\/www.easyhost.be\/en\/help\/kb\/how-to-connect-to-my-database-from-my-own-computer\/","title":{"rendered":"How to connect to my database from my own computer"},"content":{"rendered":"\n<p>To connect to your database from your own computer, you need to set up a so-called &#8216;SSH tunnel&#8217;. You then first make an SSH connection to your account. Only then can you connect locally to perform operations on your database.<\/p>\n\n\n\n<div class=\"wp-block-ht-block-toc  is-style-outline htoc htoc--position-wide toc-list-style-plain\" data-htoc-state=\"expanded\"><span class=\"htoc__title\"><span class=\"ht_toc_title\">Table of Contents<\/span><span class=\"htoc__toggle\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"16\" height=\"16\"><g fill=\"#444\"><path d=\"M15 7H1c-.6 0-1 .4-1 1s.4 1 1 1h14c.6 0 1-.4 1-1s-.4-1-1-1z\"><\/path><path d=\"M15 1H1c-.6 0-1 .4-1 1s.4 1 1 1h14c.6 0 1-.4 1-1s-.4-1-1-1zM15 13H1c-.6 0-1 .4-1 1s.4 1 1 1h14c.6 0 1-.4 1-1s-.4-1-1-1z\"><\/path><\/g><\/svg><\/span><\/span><div class=\"htoc__itemswrap\"><ul class=\"ht_toc_list\"><li class=\"\"><a href=\"#h-the-data-to-connect-to-your-database\">The data to connect to your database<\/a><\/li><li class=\"\"><a href=\"#htoc-connect-to-your-database\">Connect to your database<\/a><\/li><\/ul><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-data-to-connect-to-your-database\">The data to connect to your database<\/h2>\n\n\n\n<p>To connect to your database, you need an SSH key and your database details.<\/p>\n\n\n\n<ol>\n<li>First set up an SSH connection to your web hosting using an SSH key.<br><a href=\"https:\/\/www.easyhost.be\/en\/help\/kb\/create-an-ssh-key-to-log-in-to-your-hosting-via-ssh-without-a-password\/\">Follow our manual for this<\/a><\/li>\n\n\n\n<li>Afterwards, look up your database details via your <a href=\"https:\/\/my.easyhost.be\/en\" target=\"_blank\" rel=\"noopener\">control panel<\/a>.<br>To do so, go to &#8220;My products&#8221; > &#8220;Databases&#8221; > &#8220;Manage database&#8221;.\n<ul>\n<li>Hostname<\/li>\n\n\n\n<li>Database<\/li>\n\n\n\n<li>User<\/li>\n\n\n\n<li>Database password<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.easyhost.be\/en\/help\/wp-content\/uploads\/Screenshot-2024-02-09-at-11.03.31.png\" alt=\"\" class=\"wp-image-23641\"\/><figcaption class=\"wp-element-caption\">Example of your database data (Dutch)<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\"><strong>Forgot your password?<br><\/strong>Set a new password for your user via &#8220;Manage users&#8221; &gt; Click on the three dots next to your user and click &#8220;Edit password&#8221;.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"htoc-connect-to-your-database\">Connect to your database<\/h2>\n\n\n\n<p>To do this, install a programme to manage your database such as: MySQL workbench (Windows\/Mac), Sequel Pro (Mac), MySQL Ace (Mac), DBeaver (Linux).<\/p>\n\n\n\n<p>Just about all these programmes allow you to connect via SSH tunnel at once. This is indicated as &#8216;<strong>SSH tunnel<\/strong>&#8216;, &#8216;<strong>TCP\/IP over SSH<\/strong>&#8216; or simply &#8216;<strong>SSH<\/strong>&#8216;.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\"><strong>Authenticity of the server cannot be verified?<br><\/strong>After filling in the details, you may get this message the first time. Choose to connect anyway.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"htoc-some-examples-from-database-programmes\">Some examples from database programmes<\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.easyhost.be\/en\/help\/wp-content\/uploads\/Windows_mysql_workbench_client.png\" alt=\"\" class=\"wp-image-23645\"\/><figcaption class=\"wp-element-caption\">MySQL Workbench Windows<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.easyhost.be\/en\/help\/wp-content\/uploads\/mac_mysql_pro_client.png\" alt=\"\" class=\"wp-image-23646\"\/><figcaption class=\"wp-element-caption\">Sequel Pro<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.easyhost.be\/en\/help\/wp-content\/uploads\/linux_dbeaver_client_2-1024x813.png\" alt=\"\" class=\"wp-image-23651\"\/><figcaption class=\"wp-element-caption\">DBeaver Linux<\/figcaption><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>To connect to your database from your own computer, you need to set up a so-called &#8216;SSH tunnel&#8217;. You then first make an SSH connection to your account. Only then can you connect locally to perform operations on your database. The data to connect to your database To connect to&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[16,28],"ht-kb-tag":[],"acf":[],"_links":{"self":[{"href":"https:\/\/www.easyhost.be\/en\/help\/wp-json\/wp\/v2\/ht-kb\/2880"}],"collection":[{"href":"https:\/\/www.easyhost.be\/en\/help\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.easyhost.be\/en\/help\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.easyhost.be\/en\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.easyhost.be\/en\/help\/wp-json\/wp\/v2\/comments?post=2880"}],"version-history":[{"count":4,"href":"https:\/\/www.easyhost.be\/en\/help\/wp-json\/wp\/v2\/ht-kb\/2880\/revisions"}],"predecessor-version":[{"id":2972,"href":"https:\/\/www.easyhost.be\/en\/help\/wp-json\/wp\/v2\/ht-kb\/2880\/revisions\/2972"}],"wp:attachment":[{"href":"https:\/\/www.easyhost.be\/en\/help\/wp-json\/wp\/v2\/media?parent=2880"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.easyhost.be\/en\/help\/wp-json\/wp\/v2\/ht-kb-category?post=2880"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.easyhost.be\/en\/help\/wp-json\/wp\/v2\/ht-kb-tag?post=2880"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}