{"id":8600,"date":"2014-12-03T02:07:15","date_gmt":"2014-12-03T02:07:15","guid":{"rendered":"https:\/\/wp.okra.host\/article\/connecting-remotely-to-mysql\/"},"modified":"2021-03-07T14:31:46","modified_gmt":"2021-03-07T13:31:46","slug":"connecting-remotely-to-mysql","status":"publish","type":"ht_kb","link":"https:\/\/kb.okra.host\/de\/article\/connecting-remotely-to-mysql\/","title":{"rendered":"Entfernte Verbindung zu MySQL"},"content":{"rendered":"<h2 id=\"overview\" >\u00dcbersicht<\/h2>\n<p>By default, MySQL permissions only permit same-server access for clients. This\u00a0protects your database by preventing external access, but also precludes desktop database utilities like <a href=\"http:\/\/navicat.com\/\">Navicat<\/a>, <a href=\"http:\/\/www.mysql.com\/products\/workbench\/\">MySQL Workbench<\/a>, und <a href=\"https:\/\/eclipse.org\/pdt\/\">Eclipse<\/a> from managing your database schema.<\/p>\n<h2 id=\"solution\" >L\u00f6sung<\/h2>\n<p>Create a new MySQL user within the <a title=\"Anmeldung am Bedienfeld\" href=\"https:\/\/kb.okra.host\/de\/control-panel\/logging-into-the-control-panel\/\">Bedienfeld<\/a> unter <strong>Databases<\/strong> &gt; <strong>MySQL Manager<\/strong>.<\/p>\n<ul>\n<li>Enter a user under\u00a0<em>Name<\/em>\n<ul>\n<li><span style=\"color: #000080\">Remember<\/span>: your newly-created user will be prefixed with your database prefix that precedes the input field<\/li>\n<\/ul>\n<\/li>\n<li>Enter a password under the\u00a0<em>Password<\/em> field<\/li>\n<li>Select <strong>Advanced<\/strong> mode<\/li>\n<li>Enter a new host under the\u00a0<em>Host<\/em>\u00a0field\n<ul>\n<li>Only IP addresses are accepted<\/li>\n<li>Use _ and % for single\/multiple wildcards\n<ul>\n<li>64.22._0.1 matches 64.22.10.1 and 64.22.90.1 <em>but not 64.22.110.1<\/em><\/li>\n<li>62.22.% matches 64.22.68.1, 64.22.110.230, etc <em>but not 64.23.110.230<\/em><\/li>\n<li>64.22.%.1 would match 64.22.68.1, 64.22.230.1, <em>but not 64.22.230.2<\/em><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li>Click\u00a0<strong>Benutzer hinzuf\u00fcgen<\/strong><\/li>\n<\/ul>\n<p>A user has been created, but now requires database privileges:<\/p>\n<ul>\n<li>Select <em>Change Mode<\/em> &gt; <strong>List Users and Databases<\/strong><\/li>\n<li>Select the database under\u00a0<em>Edit Databases<\/em> &gt;\u00a0<em>Database Name<strong>.\u00a0<\/strong><\/em><\/li>\n<li>Under\u00a0<em>User Privileges<\/em>, select\u00a0<strong>READ<\/strong> und\u00a0<strong>WRITE<\/strong>\n<ul>\n<li>READ will permit the user to connect and issue <em>SELECT<\/em> statements<\/li>\n<li>WRITE will permit <em>INSERT<\/em>, <em>UPDATE<\/em>, und <em>DELETE<\/em><\/li>\n<\/ul>\n<\/li>\n<li>Click\u00a0<strong>Save<\/strong><\/li>\n<\/ul>\n<p>Connect to the database using your <a title=\"Wie lautet der Name meines Servers?\" href=\"https:\/\/kb.okra.host\/de\/platform\/what-is-my-server-name\/\">server name<\/a> (or domain name), and corresponding username + password previously created. Port is the default port 3306.<\/p>","protected":false},"excerpt":{"rendered":"<p>Overview By default, MySQL permissions only permit same-server access for clients. This\u00a0protects your database by preventing external access, but also precludes desktop database utilities like Navicat, MySQL Workbench, and Eclipse from managing your database schema. Solution Create a new MySQL user within the control panel under Databases &gt; MySQL Manager&#8230;.<\/p>","protected":false},"author":1,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[61],"ht-kb-tag":[],"class_list":["post-8600","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-mysql"],"_links":{"self":[{"href":"https:\/\/kb.okra.host\/de\/wp-json\/wp\/v2\/ht-kb\/8600","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb.okra.host\/de\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/kb.okra.host\/de\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/kb.okra.host\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.okra.host\/de\/wp-json\/wp\/v2\/comments?post=8600"}],"version-history":[{"count":1,"href":"https:\/\/kb.okra.host\/de\/wp-json\/wp\/v2\/ht-kb\/8600\/revisions"}],"predecessor-version":[{"id":8601,"href":"https:\/\/kb.okra.host\/de\/wp-json\/wp\/v2\/ht-kb\/8600\/revisions\/8601"}],"wp:attachment":[{"href":"https:\/\/kb.okra.host\/de\/wp-json\/wp\/v2\/media?parent=8600"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/kb.okra.host\/de\/wp-json\/wp\/v2\/ht-kb-category?post=8600"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/kb.okra.host\/de\/wp-json\/wp\/v2\/ht-kb-tag?post=8600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}