Apache + lighttpd で Rails を動かす
http://centos.oss.sc/ruby/apache_lighttpd_rails/
mysql
rootユーザ(システムのrootユーザとは別)にパスワードを設定する
set password for root@localhost =password(xxx);
set password for
root@localhost.localdomain =password(xxx);
匿名ユーザ削除
delete from mysql.user where user = '';
testデータベース削除
drop database test;
[mysqld]
port = 3306
socket = /tmp/mysql.sock
default-character-set=utf8
character-set-server = utf8
collation-server = utf8_general_ci
default-collation = utf8_general_ci
default-table-type=InnoDB
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
myisam_sort_buffer_size = 8M
max_connections = 500
datadir=/var/lib/mysql
old_passwords=1
skip-name-resolve
[mysqldump]
quick
max_allowed_packet = 16M
default-character-set=utf8
[mysql]
no-auto-rehash
default-character-set=utf8
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
port =3306
socket = /tmp/mysql.sock
# /etc/rc.d/init.d/mysqld start ← MySQL起動
# chkconfig mysqld on ← MySQL自動起動設定
# chkconfig --list mysqld ← MySQL自動起動設定確認
ランレベル2~5のonを確認
[
本帖最后由 realcarlos 于 2007-12-22 16:43 编辑 ]