{"id":1747,"date":"2023-03-09T23:13:39","date_gmt":"2023-03-09T14:13:39","guid":{"rendered":"https:\/\/www.typea.info\/blog\/?p=1747"},"modified":"2023-03-09T23:14:30","modified_gmt":"2023-03-09T14:14:30","slug":"lightsail_mysql_workbench_ssh","status":"publish","type":"post","link":"https:\/\/www.typea.info\/blog\/index.php\/2023\/03\/09\/lightsail_mysql_workbench_ssh\/","title":{"rendered":"Lightsail\u306b\u69cb\u7bc9\u3057\u305fMySQL\u306bMySQL Workbench \u304b\u3089 SSH\u63a5\u7d9a"},"content":{"rendered":"<p>AWS \u306e\u4f4e\u984d\u30ec\u30f3\u30bf\u30eb\u30b5\u30fc\u30d0\u30fc\u00a0<a style=\"font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;\" href=\"https:\/\/www.typea.info\/blog\/index.php\/category\/lightsail\/\">Lightsail<\/a>\u00a0\u306b\u3001<\/p>\n<ul>\n<li><a href=\"https:\/\/www.typea.info\/blog\/index.php\/2022\/04\/02\/lowprice_aws_lightsail_ssh\/\">SSH\u63a5\u7d9a<\/a><\/li>\n<li><a href=\"https:\/\/www.typea.info\/blog\/index.php\/2022\/04\/04\/aws_lightsail_static_ip\/\">\u9759\u7684IP<\/a><\/li>\n<\/ul>\n<p>\u30af\u30e9\u30a6\u30c9\u306e\u30b9\u30c8\u30ec\u30fc\u30b8\u30b5\u30fc\u30d3\u30b9\u306f\u9ad8\u3044\u306e\u3067\u3001MySQL\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3002<\/p>\n<p>\u540c\u3058\u30b5\u30fc\u30d0\u30fc\u306b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3082\u7f6e\u304f\u524d\u63d0\u3067MySQL\u3078\u306e\u63a5\u7d9a\u306f\u76f4\u63a5\u5916\u90e8\u516c\u958b\u3057\u306a\u3044\u3002<\/p>\n<p>SSH\u7d4c\u7531\u3067\u5916\u90e8\u304b\u3089\u63a5\u7d9a\u3059\u308b\u3002<\/p>\n<p>MySQL Workbench\u306e\u65b0\u898f\u63a5\u7d9a\u306e\u753b\u9762\u304b\u3089\u3001<\/p>\n<ol>\n<li>Connection Method \u306b Standard TCP\/IP over SSH\u3092\u6307\u5b9a<\/li>\n<li>SSH Hostname\u306b\u3068\u308a\u3042\u3048\u305a\u3001\u9759\u7684IP\u3092\u632f\u3063\u305f\u306e\u3067IP\u3092\u6307\u5b9a<\/li>\n<li>SSH\u306e\u63a5\u7d9a\u60c5\u5831\u3092\u6307\u5b9a(<a href=\"https:\/\/www.typea.info\/blog\/index.php\/2022\/04\/04\/aws_lightsail_static_ip\/\">SSH Key File\u306a\u3069\u306e\u5165\u624b\u65b9\u6cd5\u306f\u3053\u3061\u3089<\/a>)<\/li>\n<li>SSH\u3067\u5185\u90e8\u306b\u63a5\u7d9a\u3057\u3066\u304b\u3089\u306eMySQL\u306eHost\u306b\u306a\u308b\u306e\u3067\u3001\u30eb\u30fc\u30d7\u30d0\u30c3\u30af\u30a2\u30c9\u30ec\u30b9127.0.0.1\u3092\u6307\u5b9a<\/li>\n<li>\u4ed6\u306f\u9069\u5b9cMySQL\u306e\u30b9\u30ad\u30fc\u30de\u3084\u3089\u30e6\u30fc\u30b6\u30fc\u3084\u3089\u3092\u6307\u5b9a<\/li>\n<\/ol>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/2023\/03\/workbench_settings.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"workbench_settings.png\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/2023\/03\/workbench_settings.png\" alt=\"Workbench settings\" width=\"741\" height=\"467\" border=\"0\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>AWS \u306e\u4f4e\u984d\u30ec\u30f3\u30bf\u30eb\u30b5\u30fc\u30d0\u30fc\u00a0Lightsail\u00a0\u306b\u3001 SSH\u63a5\u7d9a \u9759\u7684IP \u30af\u30e9\u30a6\u30c9\u306e\u30b9\u30c8\u30ec\u30fc\u30b8\u30b5\u30fc\u30d3\u30b9\u306f\u9ad8\u3044\u306e\u3067\u3001MySQL\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3002 \u540c\u3058\u30b5\u30fc\u30d0\u30fc\u306b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3082\u7f6e\u304f\u524d\u63d0\u3067MySQL\u3078\u306e\u63a5\u7d9a\u306f\u76f4\u63a5\u5916\u90e8\u516c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1746,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"sns_share_botton_hide":"","vkExUnit_sns_title":"","_vk_print_noindex":"","sitemap_hide":"","_veu_custom_css":"","veu_display_promotion_alert":"","vkexunit_cta_each_option":"","footnotes":""},"categories":[59],"tags":[177,166],"class_list":["post-1747","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-lightsail","tag-mysql"],"veu_head_title_object":{"title":"","add_site_title":""},"_links":{"self":[{"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1747","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=1747"}],"version-history":[{"count":2,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1747\/revisions"}],"predecessor-version":[{"id":1749,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1747\/revisions\/1749"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/media\/1746"}],"wp:attachment":[{"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=1747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=1747"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=1747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}