一、安裝編譯工具及庫文件
yum -y install gcc gcc-c++ make autoconf libtool-ltdl-devel gd-devel freetype-devel libxml2-devel libjpeg-devel libpng-devel openssl-devel curl-devel bison patch unzip libmcrypt-devel libmhash-devel ncurses-devel sudo bzip2 flex libaio-devel
二、安裝cmake 編譯器
cd /usr/local/src
wget https://www.cmake.org/files/v3.1/cmake-3.1.1.tar.gz
tar zxvf cmake-3.1.1.tar.gz
cd cmake-3.1.1
./bootstrap
make && make install
三、編譯安裝
添加用戶
useradd -s /sbin/nologin mysql
建立所需目錄
mkdir -p /data/mysql/data
chown -R mysql:mysql /data/mysql
cd /usr/local/src/
wget https://mirrors.sohu.com/mysql/MySQL-5.5/mysql-5.5.54.tar.gz
tar xzvf mysql-5.5.54.tar.gz
cd mysql-5.5.54
cmake -DMYSQL_USER=mysql -DCMAKE_INSTALL_PREFIX=/usr/local/mysql5.5 -DINSTALL_DATADIR=/data/mysql/data -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1
make && make install
chown -R mysql:mysql /usr/local/mysql5.5/
mv /usr/local/src/mysql-5.5.54/support-files/my-large.cnf /etc/my.cnf
mv /usr/local/src/mysql-5.5.54/support-files/mysql.server /etc/init.d/mysqld
chmod a+x /etc/init.d/mysqld
開啟啟動
chkconfig –level 345 mysqld on
設置環境變量
echo "export PATH=/usr/local/mysql5.5/bin/:$PATH" >> /etc/profile
source /etc/profile
/usr/local/mysql5.5/scripts/mysql_install_db –user=mysql –defaults-file=/etc/my.cnf –basedir=/usr/local/mysql5.5 –datadir=/data/mysql/data
vim /etc/my.cnf
在[mysqld]下面加上
basedir=/usr/local/mysql5.5
datadir=/data/mysql/data
啟動:
service mysqld start
創建mysql管理員
/usr/local/mysql5.5/bin/mysqladmin -u root password 'root'
連接資料庫:
mysql -u root -proot