{"id":2835,"date":"2021-10-22T00:17:28","date_gmt":"2021-10-22T08:17:28","guid":{"rendered":"https:\/\/wonghoi.humgar.com\/blog\/?p=2835"},"modified":"2021-10-22T00:17:30","modified_gmt":"2021-10-22T08:17:30","slug":"dbeaver-connecting-to-mysql-in-namecheap-shared-hosting","status":"publish","type":"post","link":"https:\/\/wonghoi.humgar.com\/blog\/2021\/10\/22\/dbeaver-connecting-to-mysql-in-namecheap-shared-hosting\/","title":{"rendered":"DBeaver connecting to MySQL in Namecheap Shared Hosting"},"content":{"rendered":"\n

Namecheap already provided instructions to connect MySQL Workbench client<\/a> for its shared hosting, which involves SSH-tunneling<\/a> because they disallowed direct MySQL connection out of security concerns.<\/p>\n\n\n\n

So here’s basically the logistics:<\/p>\n\n\n\n

  1. SSH to your namecheap hostname (can use your domain name) at SSH port 21098<\/code><\/li>
  2. Tunnel listens to Port 5522 <\/code>and forward it to localhost<\/code> (the client itself) at MySQL Port 3306<\/code><\/li>
  3. Instead of connecting directly to the {namecheap shared hosting server}:3306<\/code>, connect to the localhost:3306<\/code><\/li><\/ol>\n\n\n\n

    It’s a little confusing on how to do it on DBeaver because “Advanced settings” is hidden by default which you will need. The name ‘local client’ (source) vs ‘remote’ (destination) in the dialog box is confusing. It’s actually equivalent<\/a> to <\/p>\n\n\n\n

    ssh -L [\"Local host<\/em>\":]\"Local port<\/em>\":\"Remote host<\/em>\":\"Remote port<\/em>\"\nssh -L [bind_address:]port:host:hostport<\/code><\/pre>\n\n\n\n
    bind_address<\/code> can be left blank. If you are paranoid and don’t want other machines to use your current MySQL client machine as a gateway (they tunnel into your machine to use the tunnel you are currently establishing), set (aka bind) it to localhost<\/code>, or you can bind it to the client’s network adapter’s IP which you want to allow machines on a trusted network to use this MySQL client computer as a gateway.<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    For some reason (I suspect it’s IPv6), “Remote host” needs to be set to the loopback adapter 127.0.0.1 (cannot use the special hostname ‘localhost<\/code>‘). <\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    Remember MySQL’s username and password is the special database-only login credentials you created at cPanel.<\/p>\n
    <\/div>
    <\/path><\/svg><\/i> \"Loading\"<\/p>
    <\/div>","protected":false},"excerpt":{"rendered":"
    Namecheap already provided instructions to connect MySQL Workbench client for its shared hosting, which involves SSH-tunneling because they disallowed direct MySQL connection out of security concerns. So here’s basically the logistics: SSH to your namecheap hostname (can use your domain … Continue reading →<\/span><\/a><\/p>\n
    <\/div>\n
    <\/path><\/svg><\/i> \"Loading\"<\/p>\n
    <\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[42],"tags":[],"class_list":["post-2835","post","type-post","status-publish","format-standard","hentry","category-web-services"],"_links":{"self":[{"href":"https:\/\/wonghoi.humgar.com\/blog\/wp-json\/wp\/v2\/posts\/2835","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wonghoi.humgar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wonghoi.humgar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wonghoi.humgar.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wonghoi.humgar.com\/blog\/wp-json\/wp\/v2\/comments?post=2835"}],"version-history":[{"count":1,"href":"https:\/\/wonghoi.humgar.com\/blog\/wp-json\/wp\/v2\/posts\/2835\/revisions"}],"predecessor-version":[{"id":2838,"href":"https:\/\/wonghoi.humgar.com\/blog\/wp-json\/wp\/v2\/posts\/2835\/revisions\/2838"}],"wp:attachment":[{"href":"https:\/\/wonghoi.humgar.com\/blog\/wp-json\/wp\/v2\/media?parent=2835"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wonghoi.humgar.com\/blog\/wp-json\/wp\/v2\/categories?post=2835"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wonghoi.humgar.com\/blog\/wp-json\/wp\/v2\/tags?post=2835"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}