centos5.5中安装mysql5.5.3

1.挂载linux的光盘源

mount /dev/cdrom /media/
cd /etc/yum.repos.d/
rm -rf CentOS-Base.repo
vim CentOS-Media.repo

baseurl=file:///media
gpgcheck=0
enabled=1

2.安装编译mysql源码必需的程序

yum -y install gcc gcc-c++ autoconf libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs-devel krb5 krb5-devel libidn libidn-devel openssl openssl-devel openldap openldap-devel nss_ldap openldap-clients openldap-servers

3.编译安装mysql

./configure –prefix=/usr/local/mysql –without-debug –enable-thread-safe-client –with-pthread –enable-assembler –enable-profiling –with-mysqld-ldflags=-all-static –with-client-ldflags=-all-static –with-extra-charsets=all –with-plugins=all –with-mysqld-user=mysql –without-embedded-server –with-server-suffix=-community –with-unix-socket-path=/tmp/mysql.sock && make && make install

4.创建mysql用户

useradd mysql

5.设置mysql安装目录的权限给mysql用户

setfacl -m u:mysql:rwx -R /usr/local/mysql
setfacl -m d:u:mysql:rwx -R /usr/local/mysql

6.安装mysql和test数据库

/usr/local/mysql/bin/mysql_install_db –user=mysql

7.启动mysql服务

/usr/local/mysql/bin/mysqld_safe –user=mysql &

8.修改mysql的登陆密码为123

/usr/local/mysql/bin/mysqladmin -uroot password “123”

9.使用mysql用户登陆数据库

/usr/local/mysql/bin/mysql -uroot -p123

10.备份配置mysql的配置文件

cp /usr/local/mysql/share/mysql/my-medium.cnf /etc/my.cnf

11.配置mysql的配置文件

vi /etc/my.cnf

#修改客户端的连接字符集
default-character-set=utf8
#修改服务器和数据库字符集
character-set-server=utf8
#修改服务器校验字符集
collation-server=utf8_general_ci

12.重启mysql服务，让字符集生效

pkill mysqld
/usr/local/mysql/bin/mysqld_safe –user=mysql &