Movabletype\u306eDB\u3092Berkley DB\u304b\u3089MySQL\u306b\u79fb\u884c\u3059\u308b\u305f\u3081\u306b\u3001MySQL\u3092ports\u304b\u3089\u5165\u308c\u308b\u65b9\u6cd5\u3092\u66f8\u3044\u305f\u3002
\n\u77e5\u8b58\u4e0d\u8db3\u3067ports\u304b\u3089option\u3092\u4ed8\u3051\u3066\u5165\u308c\u306a\u3044\u3068database\u306e\u4f4d\u7f6e\u306a\u3069\u304c\u6307\u5b9a\u3067\u304d\u306a\u3044\u3068\u601d\u3063\u305f\u304b\u3089\u3067\u3059\u3002
\n\u3057\u304b\u3057\u3001Package\u304b\u3089\u3067\u3082\u81ea\u7531\u306b\u69cb\u7bc9\u3067\u304d\u308b\u3053\u305f\u304c\u89e3\u3063\u305f\u306e\u3067\u3001\u4ee5\u4e0b\u306b\u305d\u306e\u65b9\u6cd5\u3092\u66f8\u304f\u3002
\n\u3053\u308c\u306f\u697d\u3060\u3002
\n\u307e\u305a\u3001\/usr\/sbin\/sysinstall\uff08FreeBSD 6.0\u306e\u5834\u5408)\u3057\u3066package\u306edatabases\u3092\u9078\u3076\u3002
\n\u305d\u3057\u3066\u4e0b\u8a18\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3002
\n(1) mysql-client-4.1.13
\n(2) mysql-server-4.1.13
\n(3) p5-DBD-mysql41-3.0002
\n(4) p5-DBI-1.48
\n\u3042\u3068\u306f\u52dd\u3063\u3066\u306b\u4f9d\u5b58\u6027\u3092\u8003\u616e\u3057\u3066dependency\u3068\u3057\u3066\u5165\u308c\u3066\u304f\u308c\u308b\u3002
\n\u6b21\u306b\u3001\u4ee5\u4e0b\u306e\u4f5c\u696d\u3092\u3059\u308b
\n(1) \/usr\/local\/share\/mysql\u5185\u306b\u3042\u308bmy-medium.cnf\u3092my.cnf\u306e\u540d\u524d\u3067 \/etc\u306b\u30b3\u30d4\u30fc\u3002<\/p>\n
# cp \/usr\/local\/share\/mysql\/my-medium.cnf \/etc\/my.cnf<\/pre>\n(2) \/etc\/my.cnf \u306b\u3000datadir = \/usr\/db\/mysql \u306e1\u884c\u3092\u8ffd\u52a0<\/p>\n
[mysqld]\ndatadir = \/usr\/db\/mysql\u3000\u30fb\u30fb\u30fb\u3053\u306e\u884c\u3092\u8ffd\u52a0<\/font>\nport = 3306\nsocket = \/tmp\/mysql.sock\nskip-locking\nkey_buffer = 16M<\/pre>\n(3) \/usr\/local\/bin\u306b\u3042\u308bmysql_install_db\u3092\u4f7f\u3063\u3066db\u3092\u8a2d\u5b9a\u3057\u3001mysql\u306e\u30aa\u30fc\u30ca\u30fc\u3092mysql\u306b\u5909\u3048\u3066\u304a\u304f\u3002<\/p>\n
# mysql_install_db\n# chown -R mysql \/usr\/db\/mysql<\/pre>\n(4) \/usr\/local\/etc\/rc.d\u5185\u306b\u3042\u308bmysql-server.sh \u306f\u8907\u96d1\u3067\u3046\u307e\u304f\u52d5\u304b\u306a\u304b\u3063\u305f\u306e\u3067\u3001\/usr\/local\/shre\/mysql\u5185\u306b\u3042\u308b\u3000mysql.server \u3092\/usr\/local\/etc\/rc.d\u306b\u30b3\u30d4\u30fc\u3057mysql-server.sh\u306b\u540d\u524d\u3092\u5909\u3048\u307e\u3059\u3002<\/p>\n
# cd \/usr\/local\/etc\/rc.d\n# mv mysql-server.sh mysql-server.org\n# cp \/usr\/local\/share\/mysql.server .\/mysql-server.sh<\/pre>\n\u305d\u3057\u3066\u8d77\u52d5<\/p>\n
.\/mysql-server.sh start<\/p>\n
\u3044\u3088\u3044\u3088\u3001\u7ba1\u7406\u8005\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3067\u3059\u3002\u3000ports\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3068\u5c11\u3057\u9055\u3046\u3002<\/p>\n
# mysqladmin -u root password \u30d1\u30b9\u30ef\u30fc\u30c9<\/pre>\n\u3053\u308c\u3067\u3001mysql -u -p \u3067\u5165\u308c\u307e\u3059\u3002
\n\u305d\u3057\u3066\u3001\u533f\u540d\u30e6\u30fc\u30b6\u306e\u524a\u9664\u4ee5\u964d\u306f\u4ee5\u524d\u66f8\u3044\u305f\u624b\u9806\u3068\u540c\u3058\u3067\u3059\u304c\u3001\u8aac\u660e\u306f\u7701\u7565\u3057\u307e\u3059\u304c\u7e70\u308a\u8fd4\u3057\u66f8\u3044\u3066\u304a\u304d\u307e\u3059\u3002
\nBerkeley DB\u304b\u3089MySQL\u3078\u79fb\u884c(\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3057\u307e\u3057\u305f) <\/a>\u3068\u5408\u308f\u305b\u898b\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n# mysql -u root -p\nEnter password: \u8a2d\u5b9a\u3057\u305f\u30d1\u30b9\u30ef\u30fc\u30c9\nmysql> use mysql;\nmysql> delete from user where password=' ';\nmysql> flush privileges;\nmysql> exit\nBye\n# mysql -u root -p\nEnter password: \u30d1\u30b9\u30ef\u30fc\u30c9\nmysql> create database mtdb;\nQuery OK, 1 row affected (0.00 sec)\nmysql>\nmysql> use mysql;\nmysql> grant all privileges on mtdb.*\nto mtuser@localhost identified by '\u30d1\u30b9\u30ef\u30fc\u30c9';\nQuery OK, 0 rows affected (0.13 sec)\nmysql> flush privileges;\nmysql> exit\nBye\n<\/pre>\n\u3053\u308c\u3067\u3001Berkley DB\u304b\u3089MySQL\u306b\u79fb\u884c\u306e\u6e96\u5099\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
Movabletype\u306eDB\u3092Berkley DB\u304b\u3089MySQL\u306b\u79fb\u884c\u3059\u308b\u305f\u3081\u306b\u3001MySQL\u3092ports\u304b\u3089\u5165\u308c\u308b\u65b9\u6cd5\u3092\u66f8\u3044\u305f\u3002 \u77e5\u8b58\u4e0d\u8db3\u3067ports\u304b\u3089option\u3092\u4ed8\u3051\u3066\u5165\u308c\u306a\u3044\u3068database\u306e\u4f4d\u7f6e\u306a\u3069\u304c\u6307\u5b9a\u3067\u304d … Continue reading