{"id":1407,"date":"2019-06-06T06:23:07","date_gmt":"2019-06-05T21:23:07","guid":{"rendered":"http:\/\/wp.ultimai.org\/wp\/?p=1407"},"modified":"2019-08-13T13:56:04","modified_gmt":"2019-08-13T04:56:04","slug":"post-1407","status":"publish","type":"post","link":"http:\/\/wp.ultimai.org\/?p=1407","title":{"rendered":"mode rewrite\u3068 Mysql\u30e6\u30fc\u30b6\u30fc\u6a29\u9650 wordpress"},"content":{"rendered":"
\n

WordPress\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h2>\n

\t \u79fb\u52d5 document root\u3078
\n\t<\/p>\n

\t
\n\t \u89e3\u51cd
\n\t<\/p>\n

mode rewrite\u3092\u6709\u52b9\u306b\u3059\u308b (\u306a\u3063\u3066\u306a\u304b\u3063\u305f\u3089)<\/h3>\n

\t\u2190\u3053\u3063\u3061\u304c\u672c\u5bb6<\/p>\n

\t\r\n\t\t  \r\n\t\t \r\n\t\t     <Directory \"\/var\/www\/html\">\r\n\t\t        Options Indexes FollowSymLinks\r\n\t\t        AllowOverride All\r\n\t\t        Require all granted\r\n\t\t     <\/Directory>\r\n\t\t \r\n\t\t<\/pre>\n
\t
\n\t<\/p>\n
\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306e\u4e00\u89a7\u8868\u793a\u3092\u6709\u52b9\u306b\u3059\u308b(\u306a\u3063\u3066\u306a\u304b\u3063\u305f\u3089)<\/h3>\n
\u5bfe\u8c61\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b .htaccess\u3092\u4f5c\u3063\u3066\u3053\u306e\u4e00\u884c\u3092\u66f8\u304f\r\n\t\tOptions Indexes FollowSymLinks\r\n\t\t<\/pre>\n
\u30e6\u30fc\u30b6\u540d\u306fApache\u3067\u306f\u306a\u3044 www-data\u3060<\/h3>\n
\t\t
\n\t\t<\/p>\n
\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u30d5\u30a1\u30a4\u30eb\u306e\u4e0a\u9650\u30b5\u30a4\u30ba\u3092\u5909\u66f4\u3059\u308b<\/h3>\n
\tinfo.php  phpinfo()\u3067\u30d5\u30a1\u30a4\u30eb\u306e\u6240\u5728\u304c\u78ba\u8a8d\u3067\u304d\u308b\r\n\t\t\r\n\t\t\t \r\n\t\t\t\/filesize\u3067\u691c\u7d22 Enter \u2192 N\u3067\u6b21\u306e\u5834\u6240\r\n\t\t\t  20M\u306b\r\n\t\t\tdisplay_errors On \u306b\u5909\u66f4(\u3057\u3066\u306a\u304b\u3063\u305f\u3089)\r\n\r\n\t\tEsc \u7de8\u96c6\u30e2\u30fc\u30c9\u306e\u7d42\u4e86\r\n\t\t\/memory_limit  \u3067\u691c\u7d22\r\n\t\tEnter\r\n\t\ti \u7de8\u96c6\u30e2\u30fc\u30c9\r\n\t\tmemory_limit = 512M \r\n\t\tEsc\r\n\t\t:wq   \u4fdd\u5b58\u7d42\u4e86\r\n\r\n\t\t<\/pre>\n
\tApache \u518d\u8d77\u52d5
\n\t\t<\/p>\n
\t\u3053\u308c\u3067 phpinfo() \u304c\u5b9f\u884c\u3067\u304d\u305f
\n\t\u3060\u3081\u306a\u3089 OS\u518d\u8d77\u52d5 windows \u306e\u518d\u8d77\u52d5
\n<\/section>\n
\n
MySQL \u30d0\u30fc\u30b8\u30e7\u30f3\u78ba\u8a8d<\/h3>\n
\t<\/p>\n
$ mysql --version  \u21925.7<\/pre>\n
MySQL\u3067mysqld.sock\u306e\u30a8\u30e9\u30fc\u304c\u51fa\u305f <\/a><\/h4>\n
\troot\u30e6\u30fc\u30b6\u30fc\u3058\u3083\u306a\u3044\u5834\u5408\u30de\u30f3\u30c9\u306f\u3059\u3079\u3066\u300csudo\u300d\u3067\u5b9f\u884c\u3057\u307e\u3059\u3002
\n\tmysql\u30b3\u30de\u30f3\u30c9\u3092sudo\u3092\u3064\u3051\u305a\u306b\u5b9f\u884c\u3059\u308b\u3068\u63a5\u7d9a\u30a8\u30e9\u30fc\u306b\u306a\u308a\u307e\u3059\u3002
\n\t<\/p>\n
\t#   \u2190root\u6a29\u9650\u306a\u3089\u3053\u308c <\/pre>\n
\t<\/p>\n
root\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3059\u308b<\/h3>\n
\tubuntu18 mysql5.7 root password \u8a2d\u5b9a<\/a> \u306e\u8a18\u4e8b\u53c2\u7167
\n\t\u3000<\/p>\n
\troot\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5fd8\u308c\u305f\u5834\u5408<\/a><\/p>\n
>MySQL\u3067\u30e6\u30fc\u30b6\u3092\u4f5c\u6210\u3057\u3001\u6a29\u9650\u3092\u8a2d\u5b9a\u3059\u308b\u65b9\u6cd5<\/h4>\n
\tDB\u3092\u4f5c\u3063\u3066,\u5168\u6a29\u9650\u3092”\u65e2\u5b58”tanaka\u30e6\u30fc\u30b6\u30fc\u306b\u8ffd\u52a0<\/p>\n
\t\r\n\t   CREATE USER 'tanaka'@'localhost' IDENTIFIED BY 'wert';\r\n\t   create database press;\r\n\t   grant all on press.* to tanaka@localhost identified by  'wert';\t\r\n\r\n\t\u30e6\u30fc\u30b6\u30fc\u78ba\u8a8d(\u3057\u305f\u3051\u308c\u3070)\r\n\t   SELECT Host, User FROM mysql.user;\r\n\ttanaka\u306e\u6a29\u9650\u3092\u78ba\u8a8d(\u3057\u305f\u3051\u308c\u3070)\r\n\t    SHOW GRANTS FOR tanaka@localhost;\r\n\r\n\troot\u306e\u5168\u6a29\u9650\u3092\u65e2\u5b58tanaka\u30e6\u30fc\u30b6\u30fc\u306b\u8ffd\u52a0 \u2190 local\u306a\u3089\u3084\u3063\u3066\u304a\u3051\r\n\tGRANT ALL PRIVILEGES ON *.* TO 'tanaka'@'localhost';\r\n\r\n\t<\/pre>\n
\t\u2192 adminer\u3067DB\u540d\u304c\u51fa\u3066\u3053\u306a\u3044 \u2192 Database – Refresh \u3059\u308b<\/em><\/p>\n<\/section>\n
\n
Apache\u306e\u5b9f\u884c\u30e6\u30fc\u30b6\u306e\u5909\u66f4\u65b9\u6cd5<\/h3>\n
\t\/etc\/apache2\/apache2.conf \u3092\u898b\u3066\u307f\u308b\u3068\u3001<\/p>\n
\r\n\t\t# These need to be set in \/etc\/apache2\/envvars\r\n\t\tUser ${APACHE_RUN_USER}\r\n\t\tGroup ${APACHE_RUN_GROUP}\r\n\t<\/pre>\n
\t\u3068\u3042\u308b\u306e\u3067\u3001
\n\t\/etc\/apache2\/envvars  \u3092\u958b\u3044\u3066\u3001
\n\t<\/p>\n
\r\n\t\texport APACHE_RUN_USER=tanaka\r\n\t\texport APACHE_RUN_GROUP=tanaka\r\n\t<\/pre>\n
\t\u306b\u304b\u3048\u308b
\n\t<\/p>\n
imageMagic \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n
 \u5f8c\u56de\u3057<\/p>\n
\tsudo apt-get install php-imagick\r\n\t\tsudo php -m | grep imagick\r\n\t\tsudo service apache2 restart\r\n\r\n\t\tapt install libmariadb-dev-compat\r\n\t\tapt install libmariadbclient-dev\r\n\r\n\t<\/pre>\n<\/section>\n","protected":false},"excerpt":{"rendered":"
WordPress\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb \u79fb\u52d5 docume […]<\/p>\n","protected":false},"author":2,"featured_media":719,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[37],"class_list":["post-1407","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux","tag-wsl"],"_links":{"self":[{"href":"http:\/\/wp.ultimai.org\/index.php?rest_route=\/wp\/v2\/posts\/1407","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/wp.ultimai.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/wp.ultimai.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/wp.ultimai.org\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/wp.ultimai.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1407"}],"version-history":[{"count":3,"href":"http:\/\/wp.ultimai.org\/index.php?rest_route=\/wp\/v2\/posts\/1407\/revisions"}],"predecessor-version":[{"id":1512,"href":"http:\/\/wp.ultimai.org\/index.php?rest_route=\/wp\/v2\/posts\/1407\/revisions\/1512"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/wp.ultimai.org\/index.php?rest_route=\/wp\/v2\/media\/719"}],"wp:attachment":[{"href":"http:\/\/wp.ultimai.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1407"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/wp.ultimai.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1407"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/wp.ultimai.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1407"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}