1、安裝環境準備

# wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-6.repo

# yum install cmake -y
# yum install ncurses-devel -y
# useradd -s /sbin/nologin -M mysql

2、編譯環境準備

# mkdir /usr/local/mysql
# mkdir /software
# cd /software/

# tar -zxvf mysql-5.5.32.tar.gz        #上傳文件:mysql-5.5.32.tar.gz 到: /software 目錄
# cd mysql-5.5.32

# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

-DMYSQL_DATADIR=/usr/local/mysql/data \

-DMYSQL_UNIX_ADDR=/usr/local/mysql/tmp/mysql.sock \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii  \

-DENABLED_LOCAL_INFILE=ON \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_FEDERATED_STORAGE_ENGINE=1 \

-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \

-DWITHOUT_PARTITION_STORAGE_ENGINE=1 \

-DWITH_FAST_MUTEXES=1 \

-DWITH_ZLIB=bundled \

-DENABLED_LOCAL_INFILE=1 \

-DWITH_READLINE=1 \

-DWITH_EMBEDDED_SERVER=1 \

-DWITH_DEBUG=0

# make && make install

3、初始化MySQL數據庫

# /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql/ \

--datadir=/usr/local/mysql/data \

--user=mysql                             #初始化數據庫

# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

##修改文件:/etc/my.cnf ，因為我的MySQL安裝在/usr/local/mysql目錄下面 #[mysqld]
# datadir = /usr/local/mysql/data
# socket=/usr/local/mysql/tmp/mysql.sock

# sed -i 's/datadir=\/var\/lib\/mysql/datadir=\/usr\/local\/mysql\/data/g' /etc/my.cnf

# sed -i 's/socket=\/var\/lib\/mysql\/mysql.sock/socket=\/usr\/local\/mysql\/tmp\/mysql.sock/g' /etc/my.cnf

# chown -R mysql.mysql /usr/local/mysql

# /etc/init.d/mysqld start                                        #啟動數據庫服務

# /usr/local/mysql/bin/mysql

# cp /usr/local/mysql/bin/mysql /usr/local/sbin/                  #把mysql客戶端程序復制到/usr/local/sbin/目錄下面

# /usr/local/mysql/bin/mysqladmin -u root password '123456'       #更改root用戶密碼

# mysql -uroot –p123456

   >drop user ""@Lab-Srv-02;

   >drop user "root"@"::1";

   >drop user ""@"localhost";

另外有需要云服務器可以了解下創新互聯cdcxhl.cn，海內外云服務器15元起步，三天無理由+7*72小時售后在線，公司持有idc許可證，提供“云服務器、裸金屬服務器、高防服務器、香港服務器、美國服務器、虛擬主機、免備案服務器”等云主機租用服務以及企業上云的綜合解決方案，具有“安全穩定、簡單易用、服務可用性高、性價比高”等特點與優勢，專為企業上云打造定制，能夠滿足用戶豐富、多元化的應用場景需求。