linux下mysql的安装步骤，

安装前检查是否支持 c 及c++ 

yum install gcc gcc-c++

出现：checking for termcap functions library... configure: error: No curses/termcap library found 错误

安装 ： yum install ncurses-devel

groupadd mysql　创建一个组

useradd -g mysql mysql　创建一个用户

tar xvzf  mysql-5.0.45.tar.gz
     cd mysql-5.0.45
     ./configure --prefix=/usr/local/mysql /
                 --with-charset=utf8 /
                 --with-extra-charsets=sjis,ujis --with-extra-charsets=all
     make
     make install

最重要的是权限的设置，否则mysql.sock会出错的．

# chown -R root /usr/local/mysql
# chown -R mysql /usr/local/mysql/var
# chgrp -R mysql /usr/local/mysql
# cp support-files/my-medium.cnf /etc/my.cnf
# /usr/local/mysql/bin/safe_mysqld --user=mysql & 

进入mysql
SHOW CHARACTER SET;查看当前安装的所有字符集

 alter database da_name default character set 'charset'.

create database test default character set 'sjis';