{"id":143,"date":"2007-01-15T16:57:00","date_gmt":"2007-01-15T07:57:00","guid":{"rendered":"http:\/\/popi.jp\/wp\/?p=143"},"modified":"2007-01-15T16:57:00","modified_gmt":"2007-01-15T07:57:00","slug":"","status":"publish","type":"post","link":"https:\/\/popi.jp\/wp\/?p=143","title":{"rendered":"solaris10\u306emysql\u3092\u8d77\u52d5"},"content":{"rendered":"

\u305a\u3044\u3076\u3093\u524d\u306b\u8a2d\u5b9a\u3057\u305f\u5185\u5bb9\u3060\u3051\u3069\u3069\u3046\u3084\u3089\u30e1\u30e2\u3063\u3066\u3044\u306a\u304b\u3063\u305f\u3088\u3046\u306a\u306e\u3067\u3001\u601d\u3044\u51fa\u3057\u306a\u304c\u3089\u30e1\u30e2\u30e1\u30e2\u3002
\n\/etc\/sfw\/mysql\u306b\u4ee5\u4e0b\u306e\u30d5\u30a1\u30a4\u30eb\u304c\u3042\u308b\u3002<\/p>\n

\n# ls -l \/etc\/sfw\/mysql\/
\n\u5408\u8a08 16
\n-r–r–r– 1 root bin 1556 6\u6708 21\u65e5 2005\u5e74 README.solaris.mysql
\n-rwxr–r– 1 root sys 5668 11\u6708 8\u65e5 00:45 mysql.server\n<\/div>\n

\u307e\u305a\u306fREADME\u3092\u8aad\u3080\u3002
\n\u305d\u306e\u901a\u308a\u306b\u3084\u308c\u3070\u52d5\u304d\u307e\u3059\u3002(\u305f\u3057\u304b)
\nDB\u306e\u4f5c\u6210\u5834\u6240\u304c\/var\/mysql\u306a\u306e\u304c\u5acc\u306a\u306e\u3067\u3001\u3046\u3061\u3067\u306f\/export\/DB\u306b\u3057\u3066\u307e\u3059\u3002
\n\u3067\u3082\u3081\u3093\u3069\u304f\u3055\u3044\u304b\u3089\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u307e\u307e\u8aac\u660e\u3002<\/p>\n

\n# \/usr\/sfw\/bin\/mysql_install_db
\n# groupadd mysql
\n# useradd -g mysql mysql
\n(\u3053\u306e\u307e\u307e\u6253\u3064\u3068UID:GID\u304c\u5927\u304d\u3044\u306e\u3067\u9069\u5f53\u306b\u82e5\u3044\u756a\u53f7\u3092\u6307\u5b9a\u3057\u3068\u304d\u307e\u3057\u3087\u3046)
\n# chgrp -R mysql \/var\/mysql
\n# chmod -R 770 \/var\/mysql
\n# installf SUNWmysqlr \/var\/mysql d 770 root mysql
\n# cp \/usr\/sfw\/share\/mysql\/my-medium.cnf \/var\/mysql\/my.cnf
\n# \/usr\/sfw\/sbin\/mysqld_safe –user=mysql &
\n# ln \/etc\/sfw\/mysql\/mysql.server \/etc\/rc3.d\/S99mysql
\n# ln \/etc\/sfw\/mysql\/mysql.server \/etc\/rc0.d\/K00mysql
\n# ln \/etc\/sfw\/mysql\/mysql.server \/etc\/rc1.d\/K00mysql
\n# ln \/etc\/sfw\/mysql\/mysql.server \/etc\/rc2.d\/K00mysql
\n# ln \/etc\/sfw\/mysql\/mysql.server \/etc\/rcS.d\/K00mysql\n<\/div>\n

root\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u5909\u66f4<\/p>\n

\n# \/usr\/sfw\/bin\/mysqladmin -u root password '\u3071\u3059\u308f\u30fc\u3069'\n<\/div>\n

DB\u30e6\u30fc\u30b6\u306e\u4f5c\u6210<\/p>\n

\n# \/usr\/sfw\/bin\/mysql -u root mysql -p
\nEnter password:
\nmysql> grant all privileges on *.* to identified by '\u305d\u306e\u30d1\u30b9\u30ef\u30fc\u30c9';
\nmysql> flush privileges;
\nmysql> exit\n<\/div>\n

\u3042\u3068\u306fPHPMyAdmin\u3068\u304b\u5165\u308c\u3066\u3044\u3058\u308a\u307e\u3057\u3087\u3046\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u305a\u3044\u3076\u3093\u524d\u306b\u8a2d\u5b9a\u3057\u305f\u5185\u5bb9\u3060\u3051\u3069\u3069\u3046\u3084\u3089\u30e1\u30e2\u3063\u3066\u3044\u306a\u304b\u3063\u305f\u3088\u3046\u306a\u306e\u3067\u3001\u601d\u3044\u51fa\u3057\u306a\u304c\u3089\u30e1\u30e2\u30e1\u30e2\u3002 \/etc\/sfw\/mysql\u306b\u4ee5\u4e0b\u306e\u30d5\u30a1\u30a4\u30eb\u304c\u3042\u308b\u3002 # ls -l \/etc\/sfw\/mysql\/ \u5408\u8a08 16 -r&#82 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":""},"categories":[6],"tags":[17,24],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/popi.jp\/wp\/index.php?rest_route=\/wp\/v2\/posts\/143"}],"collection":[{"href":"https:\/\/popi.jp\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/popi.jp\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/popi.jp\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/popi.jp\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=143"}],"version-history":[{"count":0,"href":"https:\/\/popi.jp\/wp\/index.php?rest_route=\/wp\/v2\/posts\/143\/revisions"}],"wp:attachment":[{"href":"https:\/\/popi.jp\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/popi.jp\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/popi.jp\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}