{"id":57,"date":"2018-11-18T20:43:33","date_gmt":"2018-11-18T11:43:33","guid":{"rendered":"https:\/\/pocolog.bass-world.net\/tech\/?p=57"},"modified":"2018-11-18T20:43:33","modified_gmt":"2018-11-18T11:43:33","slug":"mediawiki-mysql-error","status":"publish","type":"post","link":"https:\/\/pocolog.bass-world.net\/tech\/2018\/mediawiki-mysql-error\/","title":{"rendered":"MediaWiki \u3067 Can&#8217;t contact the database server: Access denied for user &#8216;wikiuser&#8217;@&#8217;localhost&#8217; (using password: YES) (localhost))"},"content":{"rendered":"<p>\u3061\u3087\u3063\u3068 MediaWiki \u3092 Amazon EC2 Linux 2 \u3067\u3082\u52d5\u304b\u3057\u3066\u307f\u307e\u3057\u305f\u3002<br \/>\n\u305d\u3057\u305f\u3089<\/p>\n<blockquote><p><code>Can't contact the database server: Access denied for user 'wikiuser'@'localhost' (using password: NO) (localhost))<\/code><\/p><\/blockquote>\n<p>\u30b0\u30b0\u3063\u3066\u307f\u305f\u3068\u3053\u308d\u3001\u3069\u3046\u3082 mysql \u304c\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u4fdd\u5b58\u3059\u308b\u306e\u306b\u6614\u306e\u30cf\u30c3\u30b7\u30e5\u3068\u65b0\u3057\u3044\u30bf\u30a4\u30d7\u306e\u30cf\u30c3\u30b7\u30e5\u304c\u6df7\u3058\u3063\u3066\u3044\u3066\u3001\u305d\u308c\u3067\u30a8\u30e9\u30fc\u3092\u51fa\u3059\u3063\u307d\u3044\u3002<\/p>\n<p>\u305d\u3046\u3044\u3046\u308f\u3051\u3067\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u4ee5\u4e0b\u306e\u901a\u308a\u5909\u66f4\u3057\u307e\u3057\u305f\u3002<\/p>\n<blockquote><p><code>alter user wikiuser@localhost identified with mysql_native_password by 'mymediawikipassword';<\/code><\/p><\/blockquote>\n<p>\u305d\u3057\u305f\u3089\u7121\u4e8b\u306b Wiki \u304c\u8868\u793a\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3061\u3087\u3063\u3068 MediaWiki \u3092 Amazon EC2 Linux 2 \u3067\u3082\u52d5\u304b\u3057\u3066\u307f\u307e\u3057\u305f\u3002 \u305d\u3057\u305f\u3089 Can&#8217;t contact the database server: Access denied for user &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/pocolog.bass-world.net\/tech\/2018\/mediawiki-mysql-error\/\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;MediaWiki \u3067 Can&#8217;t contact the database server: Access denied for user &#8216;wikiuser&#8217;@&#8217;localhost&#8217; (using password: YES) (localhost))&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,10,12],"tags":[],"class_list":["post-57","post","type-post","status-publish","format-standard","hentry","category-amazon-aws","category-linux","category-php"],"_links":{"self":[{"href":"https:\/\/pocolog.bass-world.net\/tech\/wp-json\/wp\/v2\/posts\/57","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pocolog.bass-world.net\/tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pocolog.bass-world.net\/tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pocolog.bass-world.net\/tech\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pocolog.bass-world.net\/tech\/wp-json\/wp\/v2\/comments?post=57"}],"version-history":[{"count":0,"href":"https:\/\/pocolog.bass-world.net\/tech\/wp-json\/wp\/v2\/posts\/57\/revisions"}],"wp:attachment":[{"href":"https:\/\/pocolog.bass-world.net\/tech\/wp-json\/wp\/v2\/media?parent=57"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pocolog.bass-world.net\/tech\/wp-json\/wp\/v2\/categories?post=57"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pocolog.bass-world.net\/tech\/wp-json\/wp\/v2\/tags?post=57"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}