CentOS 5 MySQL データベースサーバー構築

[root@centos-5 ~]# yum -y install mysql-server

[root@centos-5 ~]# cp /etc/my.cnf /etc/my.cnf.orig
[root@centos-5 ~]# vim /etc/my.cnf

[mysqld]
default-character-set = utf8
[mysql]
default-character-set = utf8

[root@centos-5 ~]# service mysqld start && chkconfig mysqld on
[root@centos-5 ~]# chkconfig mysqld --list

[root@centos-5 ~]# 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;