1.先查看系統(tǒng)上有沒有安裝了舊版本的MySQL铅乡，用下面的命令：
rpm -qa | grep mysql
如果有，用以下命令卸載
rpm -e --nodeps 上步顯示mysql名稱
安裝編譯mysql 需要的依賴包
yum install libevent* libtool* autoconf* libstd* ncurse* bison* openssl*
yum -y install gcc gcc-c++
2.安裝cmake蜀涨，mysql5.5之后需要用cmake支持編譯安裝,下載安裝cmake
wget http://www.cmake.org/files/v2.8/cmake-2.8.12.1.tar.gz
tar -xf cmake-2.8.12.1.tar.gz
cd cmake-2.8.12.1
./configure && make && make install
檢查cmake安裝好了沒
cmake --version
3.下載mysql
wget http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.14.tar.gz
tar xvf mysql-5.6.14.tar.gz
cd mysql-5.6.14
上面如果下載失敗，可以到這里下載：http://download.csdn.net/detail/terry_water/6973721
4.編譯安裝
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1-DWITH_INNOBASE_STORAGE_ENGINE=1-DWITH_MEMORY_STORAGE_ENGINE=1-DWITH_READLINE=1-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock -DMYSQL_TCP_PORT=3306-DENABLED_LOCAL_INFILE=1-DWITH_PARTITION_STORAGE_ENGINE=1-DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
make && make install
如果在上面的編譯報錯埃难，Could NOT find Curses (missing: CURSES_LIBRARY CURSES_INCLUDE_PATH)绊袋，則使用下面的編輯代碼：
cmake -DCURSES_LIBRARY=/usr/lib/libncurses.so -DCURSES_INCLUDE_PATH=/usr/include -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1-DWITH_INNOBASE_STORAGE_ENGINE=1-DWITH_MEMORY_STORAGE_ENGINE=1-DWITH_READLINE=1-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock -DMYSQL_TCP_PORT=3306-DENABLED_LOCAL_INFILE=1-DWITH_PARTITION_STORAGE_ENGINE=1-DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
要很長時間的等待，我虛擬機中安裝是雙核2G內(nèi)存璃岳，花了20分鐘左右的年缎。
另外還可能遇到下面的錯誤：
1.
yum install libevent* libtool* autoconf* libstd* ncurse* bison* openssl*
報錯：
libevent2-devel conflicts with libevent-devel-1.4.13-4.el6.x86_64
則執(zhí)行：
yum install libevent2 libtool* autoconf* libstd* ncurse* bison* openssl*
2.
查看 ls /usr/lib/libncurses.so
如果找不到，則
find / -name ‘libncurses.so’
我找到的文件如下：
/usr/lib64/libncurses.so
增加快捷方式
ln -s /usr/lib64/libncurses.so /usr/lib/libncurses.so
5.配置mysql
groupadd mysql
useradd -g mysql mysql
chown -R mysql:mysql /usr/local/mysql
初始化配置
cd /usr/local/mysql
scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
配置自啟動和啟動mysql
cp support-files/mysql.server /etc/init.d/mysql
chkconfig mysql on
service mysql start
配置PATH
vi /etc/profile
#在文件末尾添加
PATH=/usr/local/mysql/bin:$PATH
export PATH
#保存退出铃慷，生效配置
source /etc/profile
登陸mysql 并設(shè)置root密碼
mysql -uroot
mysql> SET PASSWORD =PASSWORD('123456');
設(shè)置mysql可以遠(yuǎn)程訪問
mysql> GRANT ALL PRIVILEGES ON *.* TO'root'@'%'IDENTIFIED BY'123456'WITH GRANT OPTION;
執(zhí)行下邊的命令单芜，使上邊的命令生效
flush privileges;
如果是遠(yuǎn)程，配置可以遠(yuǎn)程訪問犁柜，配置防火墻缓溅，允許3306端口
/sbin/iptables -I INPUT -p tcp --dport3306-j ACCEPT
/etc/rc.d/init.d/iptables save
6.數(shù)據(jù)庫定時備份：
mkdir /backup
chmod777-R /backup
vim /backup/mysql_backup.sh
寫入如下內(nèi)容：-p引號里面是數(shù)據(jù)庫的密碼，erp是備份的數(shù)據(jù)庫名字
#!/bin/bash
date=$(date +%Y%m%d)
/usr/local/mysql/bin/mysqldump -h localhost -uroot -p'Ddsd#$#2s$!s4343%$^&s'erp > /backup/databases-$date.sql
設(shè)置CRON赁温，定時備份：
crontab -e
0006* * * /bin/bash /backup/mysql_backup.sh
