[root@xuegod64 ~]#mkdir -p /usr/local/mysql/data
[root@xuegod64 ~]#groupadd mysql
[root@xuegod64 ~]#useradd -g mysql mysql
[root@xuegod64 ~]#chown -R mysql.mysql /usr/local/mysql/data/
[root@xuegod64 ~]#yum install -y gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* cmake
[root@xuegod64 ~]#tar -zxvf mysql-5.5.47.tar.gz
[root@xuegod64 ~]#cd mysql-5.5.47
[root@xuegod64 mysql-5.5.47]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql
[root@xuegod64 mysql-5.5.47]# make && make install
[root@xuegod64 mysql-5.5.47]# cp /usr/local/mysql/support-files/my-large.cnf /etc/my.cnf
[root@xuegod64 mysql-5.5.47]#cd /usr/local/mysql/
[root@xuegod64 mysql]# scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
[root@xuegod64 mysql]#cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@xuegod64 mysql]#chkconfig mysqld on
[root@xuegod64 mysql]# echo ‘export PATH=/usr/local/mysql/bin:$PATH‘ >> /etc/profile
[root@xuegod64 mysql]# source /etc/profile
[root@xuegod64 ]# /etc/init.d/mysql start
[root@xuegod64 ]# mysql -u root -p
Enter password: 默认无密码,直接回车
mysql>use mysql;
mysql> update user set password=password("123456"); //修改密码
mysql> update user set `host` = ‘%‘ where `user` = ‘root‘ limit 1; //修改可远程访问
mysql > exit //退出
[root@xuegod64 ]# /etc/init.d/mysqld restart