{"id":799,"date":"2019-12-23T00:19:39","date_gmt":"2019-12-22T15:19:39","guid":{"rendered":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/?p=799"},"modified":"2022-07-17T09:08:14","modified_gmt":"2022-07-17T00:08:14","slug":"owncloud%e3%81%ae%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab%e6%99%82%e3%81%abmysql%e3%81%ae%e3%82%a8%e3%83%a9%e3%83%bc%e3%81%8c%e8%a1%a8%e7%a4%ba%e3%81%95%e3%82%8c%e3%81%a6%e5%87%a6","status":"publish","type":"post","link":"https:\/\/www7390uo.sakura.ne.jp\/wordpress\/archives\/799","title":{"rendered":"ownCloud\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6642\u306bMySQL\u306e\u30a8\u30e9\u30fc\u304c\u8868\u793a\u3055\u308c\u3066\u51e6\u7406\u304c\u3061\u3063\u3068\u3082\u9032\u307e\u306a\u3044"},"content":{"rendered":"\n

ownCloud: 10.3.2
MySQL: 8.0.18<\/p>\n\n\n\n

ownCloud\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u3053\u3046\u3044\u3046\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u53d7\u3051\u53d6\u308b\u3088\u3046\u306b\u306a\u3063\u305f\u3002<\/p>\n\n\n

\n
\"\"<\/a>
\u56f31. \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6642\u306e\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8<\/figcaption><\/figure>\n<\/div>\n\n\n

Error while trying to create admin user: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client <\/p><\/blockquote>\n\n\n\n

\u3069\u3046\u3082MySQL8\u7cfb\u304b\u3089\u306f\u8a8d\u8a3c\u30d7\u30e9\u30b0\u30a4\u30f3\u306bcaching_sha2_password<\/code>\u304c\u6a19\u6e96\u3067\u63a1\u7528\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u308a\u3001\u5f93\u6765\u304b\u3089\u306emysql_native_password<\/code>\u304b\u3089\u7f6e\u304d\u63db\u308f\u3063\u305f\u6a21\u69d8\u3067\u3042\u308b\u3002ownCloud 10.3.2\u306f\u3053\u306e\u6d41\u308c\u306b\u672a\u3060\u5bfe\u5fdc\u3057\u3066\u3044\u306a\u3044\u70ba\u306b\u30a8\u30e9\u30fc\u3068\u306a\u3063\u3066\u3044\u308b\u306e\u3067\u3042\u308b\u3002\u3053\u308c\u3092\u907f\u3051\u308b\u305f\u3081\u306b\u4e00\u5148\u305aMySQL\u63a5\u7d9a\u30e6\u30fc\u30b6\u306e\u8a8d\u8a3c\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u304b\u3064\u3066\u306emysql_native_password\u3078\u3068\u8a2d\u5b9a\u3057\u305f\u3002<\/p>\n\n\n\n

mysql> create user 'ocadmin'@'localhost' identified by 'p@ssw0rd';\nmysql> grant all on owncloud.* to 'ocadmin'@'localhost' with grant option;\nmysql> select user, plugin from mysql.user where user = 'ocadmin';\n+---------+-----------------------+\n| user    | plugin                |\n+---------+-----------------------+\n| ocadmin | caching_sha2_password<\/strong> |\n+---------+-----------------------+\n\nmysql> alter user 'ocadmin'@'localhost' identified with mysql_native_password by 'p@ssw0rd' ;\nmysql> select user, plugin from mysql.user where user = 'ocadmin';\n+---------+-----------------------+\n| user    | plugin                |\n+---------+-----------------------+\n| ocadmin | mysql_native_password<\/strong> |\n+---------+-----------------------+\n\nmysql> create database owncloud;<\/pre>\n\n\n\n
\u305d\u3046\u3057\u3066\u6539\u3081\u3066ownCloud\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u8a66\u307f\u308b\u3068\u6059\u7121\u304f\u5b8c\u4e86\u3057\u305f\u306e\u3067\u3088\u304b\u3063\u305f\u3002<\/p>\n\n\n
\n
\"\"<\/a>
\u56f32. \u30a8\u30e9\u30fc\u304c\u89e3\u6d88\u3055\u308c\u305f\u69d8\u5b50<\/figcaption><\/figure>\n<\/div>\n\n\n
\u53c2\u8003:<\/h3>\n