{"id":257,"date":"2021-01-19T19:00:39","date_gmt":"2021-01-19T10:00:39","guid":{"rendered":"https:\/\/www.wiseitservice.co.jp\/?p=257"},"modified":"2021-01-19T19:14:02","modified_gmt":"2021-01-19T10:14:02","slug":"mariadb%e3%81%aeroot%e3%83%91%e3%82%b9%e3%83%af%e3%83%bc%e3%83%89%e3%82%92%e5%86%8d%e8%a8%ad%e5%ae%9a%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/www.wiseitservice.co.jp\/?p=257","title":{"rendered":"MariaDB\u306eroot\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u518d\u8a2d\u5b9a\u3059\u308b"},"content":{"rendered":"\n

root\u30d1\u30b9\u30ef\u30fc\u30c9\u304c\u308f\u304b\u3089\u306a\u304f\u306a\u3063\u305f\u5834\u5408\u3001\u4ee5\u4e0b\u306e\u624b\u9806\u3067MariaDB\u3092\u30b5\u30fc\u30d3\u30b9\u3092\u30bb\u30fc\u30d5\u30e2\u30fc\u30c9\u3067\u8d77\u52d5\u3057\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u518d\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u304c\u51fa\u6765\u308b\u3002<\/p>\n\n\n\n

\u307e\u305a\u306f\u3001MariaDB\u306e\u30b5\u30fc\u30d3\u30b9\u3092\u505c\u6b62\u3057\u307e\u3059\u3002
# systemctl stop mariadb<\/strong><\/p>\n\n\n\n

\u6b21\u306b\u30bb\u30fc\u30d5\u30e2\u30fc\u30c9\u3067MariaDB\u3092\u8d77\u52d5\u3002
# mysqld_safe –skip-grant-tables &<\/strong>
210119 05:49:17 mysqld_safe Logging to ‘\/var\/log\/mariadb\/mariadb.log’.
210119 05:49:17 mysqld_safe Starting mysqld daemon with databases from \/var\/lib\/mysql<\/p>\n\n\n\n

\u5225\u306e\u30b7\u30a7\u30eb\u3067MariaDB\u306e\u30b3\u30f3\u30bd\u30fc\u30eb\u3092\u8d77\u52d5
# mysql<\/strong>
Welcome to the MariaDB monitor.\u00a0 Commands end with ; or \\g.
Your MariaDB connection id is 1
Server version: 5.5.68-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.<\/p>\n\n\n\n

\u7ba1\u7406\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u79fb\u52d5
MariaDB [(none)]> use mysql;<\/strong>
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed<\/p>\n\n\n\n

root\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u66f4\u65b0
MariaDB [mysql]> update user set password=PASSWORD(“\u65b0\u3057\u3044\u30d1\u30b9\u30ef\u30fc\u30c9”) where User=’root’;<\/strong>
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3\u00a0 Changed: 3\u00a0 Warnings: 0

MariaDB [mysql]> exit<\/strong>
Bye<\/p>\n\n\n\n

\u5143\u306e\u30b7\u30a7\u30eb\u3067\u8d77\u52d5\u3057\u3066\u3044\u308bMariaDB\u3092[Ctrl]+[C]\u3067\u505c\u6b62\u3059\u308b\u3002 \u5143\u306e\u753b\u9762\u304c\u7121\u3044\u5834\u5408\u306f\u300cps -ef | grep mysql\u300d\u306a\u3069\u3067mysql\u306e\u30d7\u30ed\u30bb\u30b9\u756a\u53f7\u3092\u7279\u5b9a\u3057kill\u3059\u308b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

root\u30d1\u30b9\u30ef\u30fc\u30c9\u304c\u308f\u304b\u3089\u306a\u304f\u306a\u3063\u305f\u5834\u5408\u3001\u4ee5\u4e0b\u306e\u624b\u9806\u3067MariaDB\u3092\u30b5\u30fc\u30d3\u30b9\u3092\u30bb\u30fc\u30d5\u30e2\u30fc\u30c9\u3067\u8d77\u52d5\u3057\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u518d\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u304c\u51fa\u6765\u308b\u3002 \u307e\u305a\u306f\u3001MariaDB\u306e\u30b5\u30fc\u30d3\u30b9\u3092\u505c\u6b62\u3057\u307e\u3059\u3002# systemctl stop m […]<\/p>\n","protected":false},"author":2,"featured_media":259,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[21,23,25,24],"class_list":["post-257","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tech","tag-linux","tag-mariadb","tag-password","tag-root"],"_links":{"self":[{"href":"https:\/\/www.wiseitservice.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/257","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wiseitservice.co.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wiseitservice.co.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wiseitservice.co.jp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wiseitservice.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=257"}],"version-history":[{"count":4,"href":"https:\/\/www.wiseitservice.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/257\/revisions"}],"predecessor-version":[{"id":263,"href":"https:\/\/www.wiseitservice.co.jp\/index.php?rest_route=\/wp\/v2\/posts\/257\/revisions\/263"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wiseitservice.co.jp\/index.php?rest_route=\/wp\/v2\/media\/259"}],"wp:attachment":[{"href":"https:\/\/www.wiseitservice.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=257"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wiseitservice.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=257"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wiseitservice.co.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}