CentOS 5.10 + MySQL5.5 + PostgreSQL8.1
Default install
--------------------------------------------------------------------------------
my.cnf
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8
default-storage-engine=INNODB
追加後 サービスより起動
--------------------------------------------------------------------------------
cat /root/.mysql_secret
cat: /root/.mysql_secret: そのようなファイルやディレクトリはありません

--------------------------------------------------------------------------------
mysql

set password=password('mysql_password');
Create Database testdb;
grant all privileges on *.* to usr1 identified by 'mysql_password';
FLUSH PRIVILEGES;

--------------------------------------------------------------------------------
PostgreSQL
su - postgres -c "/usr/bin/initdb"

サービスより起動
-------------------------------------------------------------------------
sudo su - postgres
# psql -d postgres
postgres=# ALTER USER postgres WITH PASSWORD 'postgrespassword';
postgres=# create database testdb;
\q
exit

-------------------------------------------------------------------------
gedit /var/lib/pgsql/data/postgresql.conf
listen_addresses = '*'
port = 5432
gedit /var/lib/pgsql/data/pg_hba.conf
host all all 0.0.0.0/0 trust
host all all 192.168.24.0/24 trust
service postgresql restart
-------------------------------------------------------------------------
select version();