{"id":154,"date":"2023-07-25T13:55:28","date_gmt":"2023-07-25T04:55:28","guid":{"rendered":"https:\/\/knowledge.comadori.com\/?p=154"},"modified":"2023-07-25T14:16:47","modified_gmt":"2023-07-25T05:16:47","slug":"mysql-mariadb-create-database-and-user","status":"publish","type":"post","link":"https:\/\/knowledge.comadori.com\/wp\/?p=154","title":{"rendered":"MySQL\/MariaDB create database and user"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">GOAL<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL \/ MariaDB \u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u3068\u30e6\u30fc\u30b6\u306e\u4f5c\u6210<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Creating a database and user in MySQL \/ MariaDB<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">ENVIRONMENT<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>MySQL 5.5+<\/li>\n\n\n\n<li>MariaDB 10.3+<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">PARAMETER<\/h2>\n\n\n\n<dl>\n<dt>database name<\/dt>\n<dd>PARAM_01: <input type=\"text\" name=\"PARAM_01\"><\/dd>\n<\/dl>\n\n\n\n<dl>\n<dt>user name<\/dt>\n<dd>PARAM_02: <input type=\"text\" name=\"PARAM_02\"><\/dd>\n<\/dl>\n\n\n\n<dl>\n<dt>user password<\/dt>\n<dd>PARAM_03: <input type=\"text\" name=\"PARAM_03\"><\/dd>\n<\/dl>\n\n\n\n<dl>\n<dt>host name<\/dt>\n<dd>PARAM_04: <input type=\"text\" name=\"PARAM_04\"><\/dd>\n<\/dl>\n\n\n\n<h2 class=\"wp-block-heading\">CODE<\/h2>\n\n\n\n<script>\nconst param_reflector = (e) => {\n  let original_codes = [];\n  const reflection = () => {\n    original_codes.forEach((code) => {\n      let content = code.content;\n      document.querySelectorAll('[name^=\"PARAM_\"]').forEach((param, idx) => {\n        switch(param.type) {\n          case 'radio':\n            if (!param.checked) return;\n            break;\n          default:\n            if (!param.value) return;\n          }\n          content = content.replaceAll(`[${param.name}]`, param.value);\n          content = content.replaceAll(`<span class=\"token punctuation\">[<\/span>${param.name}<span class=\"token punctuation\">]<\/span>`, param.value);\n      });\nconsole.log(content)\n      code.elem.innerHTML = content;\n    });\n  };\n  setTimeout(() => {\n    document.querySelectorAll('.code code').forEach((elem, idx) => {\n      original_codes.push({elem: elem, content: elem.innerHTML});\n    }, 500);\n  });\n  document.querySelectorAll('[name^=\"PARAM_\"]').forEach((elem, idx) => {\n    elem.addEventListener('change', reflection);\n  });\n};\ndocument.addEventListener('DOMContentLoaded', param_reflector);\n<\/script>\n\n\n\n<h3 class=\"wp-block-heading\">create database<\/h3>\n\n\n\n<div class=\"hcb_wrap code\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>CREATE DATABASE [PARAM_01] CHARACTER SET utf8mb4;<\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">create user<\/h3>\n\n\n\n<div class=\"hcb_wrap code\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>CREATE USER [PARAM_02] IDENTIFIED BY password(&#39;[PARAM_03]&#39;);<\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">grant user<\/h3>\n\n\n\n<div class=\"hcb_wrap code\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>GRANT ALL ON [PARAM_01].* to &#39;[PARAM_02]&#39;@&#39;%&#39;;\nGRANT ALL ON [PARAM_01].* to &#39;[PARAM_02]&#39;@&#39;localhost&#39;;<\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading code\">grant user with host name<\/h3>\n\n\n\n<div class=\"hcb_wrap code\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>GRANT ALL ON [PARAM_01].* to &#39;[PARAM_02]&#39;@&#39;[PARAM_04]&#39;;<\/code><\/pre><\/div>\n","protected":false},"excerpt":{"rendered":"<p>MySQL \/ MariaDB \u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u3068\u30e6\u30fc\u30b6\u306e\u4f5c\u6210 Creating a database and user in MySQL \/ MariaDB database name PARAM_01: user [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,15,14],"tags":[],"class_list":["post-154","post","type-post","status-publish","format-standard","hentry","category-database","category-mariadb","category-mysql-database"],"_links":{"self":[{"href":"https:\/\/knowledge.comadori.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/154","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/knowledge.comadori.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/knowledge.comadori.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/knowledge.comadori.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/knowledge.comadori.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=154"}],"version-history":[{"count":6,"href":"https:\/\/knowledge.comadori.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/154\/revisions"}],"predecessor-version":[{"id":165,"href":"https:\/\/knowledge.comadori.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/154\/revisions\/165"}],"wp:attachment":[{"href":"https:\/\/knowledge.comadori.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=154"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/knowledge.comadori.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=154"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/knowledge.comadori.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}