{"id":1588,"date":"2021-11-07T20:08:28","date_gmt":"2021-11-07T11:08:28","guid":{"rendered":"https:\/\/curecode.jp\/tech\/?p=1588"},"modified":"2021-11-07T20:08:28","modified_gmt":"2021-11-07T11:08:28","slug":"ansible-mariadb-creat-database-and-user","status":"publish","type":"post","link":"https:\/\/curecode.jp\/tech\/ansible-mariadb-creat-database-and-user\/","title":{"rendered":"Ansible \u306b\u3088\u308b MariaDB 10 \u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30fb\u30e6\u30fc\u30b6\u30fc\u8a2d\u5b9a"},"content":{"rendered":"<p>Ansible \u306e playbook \u3092\u4f7f\u3063\u3066 MariaDB 10.5 \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066 MariaDB \u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30e6\u30fc\u30b6\u30fc\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u3067\u3059\u3002<\/p>\n<p>Alma Linux 10.4 \u3067\u78ba\u8a8d\u3057\u307e\u3057\u305f\u3002Alma Linux \u306e AppStream \u304b\u3089\u306f MariaDB 10.5 \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u304d\u307e\u3059\u3002<\/p>\n<pre><code class=\"yml\">\r\n- name: Install MariaDB packages from AppStream\r\n  yum:\r\n    name: ['mariadb', 'mariadb-common', 'mariadb-server', 'mariadb-server-utils', 'mariadb-backup']\r\n\r\n- name: Start and enable MariaDB Service\r\n  service:\r\n    name: mariadb\r\n    state: started\r\n    enabled: true\r\n<\/code><\/pre>\n<h3>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210<\/h3>\n<p>MariaDB 10.4 \u304b\u3089\u306f\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u30ed\u30fc\u30ab\u30eb\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b\u5834\u5408\u306e root \u30d1\u30b9\u30ef\u30fc\u30c9\u306f\u8981\u6c42\u3055\u308c\u3066\u3044\u307e\u305b\u3093\u3002\u305d\u3053\u3067 playbook \u306b\u3082\u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u8a18\u8f09\u3092\u3057\u306a\u3044\u3067\u3082\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3068\u601d\u3044\u3001\u4f55\u3082\u8a18\u8f09\u3057\u306a\u3044\u3067\u3084\u3063\u3066\u307f\u307e\u3059\u3002<\/p>\n<pre><code class=\"yml\">\r\n- name: Create Database\r\n  mysql_db:\r\n    name: \"{{ db_name }}\"\r\n    state: present\r\n    encoding: utf8mb4\r\n    collation: utf8mb4_general_ci\r\n<\/code><\/pre>\n<p>\u3057\u304b\u3057\u3001\u5b9f\u884c\u3059\u308b\u3068\u30a8\u30e9\u30fc\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<h3>unable to find \/root\/.my.cnf. Exception message: (1698, Access denied for user) \u30a8\u30e9\u30fc<\/h3>\n<p>\u56de\u907f\u7b56\u3068\u3057\u3066\u3001login_host, login_user, login_password \u3092\u8ffd\u52a0\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n<pre><code class=\"yml\">\r\n- name: Create Database\r\n  mysql_db:\r\n    login_host: localhost\r\n    login_user: root\r\n    login_password: \"{{ mysql_root_password }}\"\r\n    name: \"{{ db_name }}\"\r\n    state: present\r\n    encoding: utf8mb4\r\n    collation: utf8mb4_general_ci\r\n<\/code><\/pre>\n<p>\u3061\u306a\u307f\u306b mysql_root_password \u306f\u7a7a\u306b\u8a2d\u5b9a\u3057\u3066\u3042\u308a\u307e\u3059\u3002\u3057\u304b\u3057\u3053\u308c\u3067\u3082\u3046\u307e\u304f\u3044\u304d\u307e\u305b\u3093\u3002<\/p>\n<p>\u305d\u3082\u305d\u3082\u30ed\u30fc\u30ab\u30eb\u30a2\u30af\u30bb\u30b9\u3068\u306f\u3044\u3063\u3066\u3082\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u304c\u8981\u6c42\u3055\u308c\u306a\u3044\u306e\u306f socket \u63a5\u7d9a\u306e\u5834\u5408\u3067\u3059\u3002\uff08\u3053\u308c\u306f\u30b5\u30fc\u30d0\u30fc\u306e root \u6a29\u9650\u3092\u6301\u3063\u3066\u3044\u308b\u306e\u306b root \u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u6c42\u3081\u308b\u3053\u3068\u304c\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u7684\u306b\u7121\u610f\u5473\u3068\u3044\u3046\u8003\u3048\u304b\u3089\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u3053\u306e\u3088\u3046\u306a\u52d5\u4f5c\u306b\u306a\u3063\u3066\u3044\u308b\u3088\u3046\u3067\u3059\u3002\u3082\u3061\u308d\u3093\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002\uff09<\/p>\n<p>\u305d\u306e\u305f\u3081\u30bd\u30b1\u30c3\u30c8\u63a5\u7d9a\u3057\u305f\u3044\u306e\u3067 login_host \u3067\u306f\u306a\u304f\u3001login_unix_socket \u3092\u4f7f\u3048\u3070\u826f\u3055\u305d\u3046\u3067\u3059\u3002<\/p>\n<pre><code class=\"yml\">\r\n- name: Create Database\r\n  mysql_db:\r\n    login_unix_socket: \/var\/lib\/mysql\/mysql.sock\r\n    login_user: root\r\n    login_password: \"{{ mysql_root_password }}\"\r\n    name: \"{{ db_name }}\"\r\n    state: present\r\n    encoding: utf8mb4\r\n    collation: utf8mb4_general_ci\r\n<\/code><\/pre>\n<p>\u3053\u308c\u3067\u3046\u307e\u304f\u3044\u304d\u307e\u3057\u305f\u3002<\/p>\n<h3>\u30e6\u30fc\u30b6\u30fc\u306e\u4f5c\u6210<\/h3>\n<p>\u3053\u3061\u3089\u3082\u540c\u69d8\u306b login_unix_socket \u3092\u4f7f\u3063\u305f\u8a2d\u5b9a\u3092\u3057\u307e\u3059\u3002<\/p>\n<pre><code class=\"yml\">\r\n- name: Create Database User\r\n  mysql_user:\r\n    login_unix_socket: \/var\/lib\/mysql\/mysql.sock\r\n    login_user: root\r\n    login_password: \"{{ mysql_root_password }}\"\r\n    name: \"{{ db_user_name }}\"\r\n    password: \"{{ db_user_password }}\"\r\n    host: \"{{ db_hostname }}\"\r\n    priv: '*.*:ALL'\r\n    state: present\r\n<\/code><\/pre>\n<h3>root \u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u8a2d\u5b9a<\/h3>\n<p>\u6700\u5f8c\u306b root \u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3059\u308b\u306e\u3082 Ansible \u3067\u3084\u3063\u3066\u307f\u307e\u3059\u3002<br \/>\ndb_root_password \u306b\u65b0\u3057\u3044\u30d1\u30b9\u30ef\u30fc\u30c9\u3001mysql_root_password \u306f\u53e4\u3044\u30d1\u30b9\u30ef\u30fc\u30c9\uff08\u7a7a\uff09\u3067\u3059\u3002<\/p>\n<pre><code class=\"yml\">\r\n- name: Set mariadb root password\r\n  mysql_user:\r\n    login_unix_socket: \/var\/lib\/mysql\/mysql.sock\r\n    login_user: root\r\n    login_password: \"{{ mysql_root_password }}\"\r\n    name: root\r\n    password: \"{{db_root_password}}\"\r\n    host_all: yes\r\n<\/code><\/pre>\n<h3>IT\u30a8\u30f3\u30b8\u30cb\u30a2\u52df\u96c6\u4e2d\uff01<\/h3>\n<p>\u30ad\u30e5\u30a2\u30b3\u30fc\u30c9\u682a\u5f0f\u4f1a\u793e\u306fIT\u30a8\u30f3\u30b8\u30cb\u30a2\u3092\u52df\u96c6\u3057\u3066\u304a\u308a\u307e\u3059\u3002\u5c11\u4eba\u6570\u306e\u8077\u5834\u306a\u306e\u3067\u3001\u4e0a\u6d41\u30fb\u4e0b\u6d41\u3084\u30b5\u30fc\u30d0\u30fc\u30fb\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u5bfe\u5fdc\u306e\u57a3\u6839\u306a\u304f\u3001\u3042\u306a\u305f\u306e\u5f37\u307f\u3092\u6d3b\u304b\u3057\u306a\u304c\u3089 \u3044\u308d\u3044\u308d\u306a\u3053\u3068\u306b\u30c1\u30e3\u30ec\u30f3\u30b8\u53ef\u80fd\u3067\u3059\u3002\u30a8\u30f3\u30b8\u30cb\u30a2\u3068\u3057\u3066\u306e\u672a\u7d4c\u9a13\u306e\u65b9\u3001\u7d4c\u9a13\u304c\u5c11\u306a\u3044\u65b9\u3082\u6b53\u8fce\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u4e0b\u8a18\u3088\u308aIT\u30a8\u30f3\u30b8\u30cb\u30a2\u52df\u96c6\u306e\u63a1\u7528\u60c5\u5831\u3092\u3054\u89a7\u3044\u305f\u3060\u3051\u307e\u3059\u3002<\/p>\n<div class=\"curecode_recruit_bn\">\n\t\t\t\t<a href=\"https:\/\/curecode.jp\/recruit\/itengineer\/\" target=\"_blank\" rel=\"noopener noreferrer\"><br \/>\n\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/curecode.jp\/tech\/wp-content\/themes\/tech\/images\/it_recruit.png?20241220\" alt=\"\u4e8b\u696d\u62e1\u5927\u306b\u4f34\u3044\u65b0\u3057\u3044\u9818\u57df\u306b\u4e00\u7dd2\u306b\u53d6\u308a\u7d44\u3093\u3067\u3044\u304f\u30e1\u30f3\u30d0\u30fc\u3092\u52df\u96c6\u3057\u307e\u3059\u3002\"  width=\"500\" height=\"180\"\/><br \/>\n\t\t\t\t<\/a>\n\t\t<\/div>\n<h3>\u30ad\u30e5\u30a2\u30b3\u30fc\u30c9\u516c\u5f0f\u30a4\u30f3\u30b9\u30bf\u30b0\u30e9\u30e0<\/h3>\n<p>\u30ad\u30e5\u30a2\u30b3\u30fc\u30c9\u682a\u5f0f\u4f1a\u793e\u306e\u65b0\u30b5\u30fc\u30d3\u30b9\u60c5\u5831\u3084\u3001\u30aa\u30d5\u30a3\u30b9\u30e9\u30a4\u30d5\u306e\u7d20\u6575\u306a\u77ac\u9593\u307e\u3067\u3002\u79c1\u305f\u3061\u306e\u65e5\u3005\u306e\u55b6\u307f\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n<div class=\"curecode_recruit_bn\">\n\t\t\t\t<a href=\"https:\/\/www.instagram.com\/curecode\/\" target=\"_blank\" rel=\"noopener noreferrer\"><br \/>\n\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/curecode.jp\/tech\/wp-content\/themes\/tech\/images\/insta_bn.png?20241220\" alt=\"\u4e8b\u696d\u62e1\u5927\u306b\u4f34\u3044\u65b0\u3057\u3044\u9818\u57df\u306b\u4e00\u7dd2\u306b\u53d6\u308a\u7d44\u3093\u3067\u3044\u304f\u30e1\u30f3\u30d0\u30fc\u3092\u52df\u96c6\u3057\u307e\u3059\u3002\"  width=\"500\" height=\"180\"\/><br \/>\n\t\t\t\t<\/a>\n\t\t<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Ansible \u306e playbook \u3092\u4f7f\u3063\u3066 MariaDB 10.5 \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066 Mar [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":1356,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,84],"tags":[181,150,85],"class_list":["post-1588","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ansible","category-mysql","tag-almalinux","tag-ansible","tag-mariadb"],"_links":{"self":[{"href":"https:\/\/curecode.jp\/tech\/wp-json\/wp\/v2\/posts\/1588","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/curecode.jp\/tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/curecode.jp\/tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/curecode.jp\/tech\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/curecode.jp\/tech\/wp-json\/wp\/v2\/comments?post=1588"}],"version-history":[{"count":4,"href":"https:\/\/curecode.jp\/tech\/wp-json\/wp\/v2\/posts\/1588\/revisions"}],"predecessor-version":[{"id":1592,"href":"https:\/\/curecode.jp\/tech\/wp-json\/wp\/v2\/posts\/1588\/revisions\/1592"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/curecode.jp\/tech\/wp-json\/wp\/v2\/media\/1356"}],"wp:attachment":[{"href":"https:\/\/curecode.jp\/tech\/wp-json\/wp\/v2\/media?parent=1588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/curecode.jp\/tech\/wp-json\/wp\/v2\/categories?post=1588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/curecode.jp\/tech\/wp-json\/wp\/v2\/tags?post=1588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}