CentOS 5 MySQL データベースサーバー構築 – my.cnf と初期設定

yum -y install mysql-server

cat > /etc/my.cnf <<'EOF'
[mysqld]
default-character-set = utf8
[mysql]
default-character-set = utf8
EOF

service mysqld start && chkconfig mysqld on
chkconfig mysqld --list

mysql -u root

mysql> select user,host,password from mysql.user;

mysql> set password for root@localhost=password('password');
mysql> set password for root@'centos-5'=password('password');
mysql> set password for root@'127.0.0.1'=password('password');

mysql> delete from mysql.user where user='';

mysql> show databases;

mysql> drop database test;

mysql> quit;