Centos 編譯安裝mysql 5.6.21,centos5.6.21
1.yum安裝各個依賴包
[root@WebServer ~]# yum -y install gcc gcc-devel gcc-c++ gcc-c++-devel autoconf* automake* zlib* libxml* ncurses-devel ncurses libgcrypt* libtool* cmake openssl openssl-devel bison bison-devel unzip
2.建立mysql安裝目錄和資料庫目錄
mkdir -p /opt/mysql/data
mkdir -p /opt/mysql/etc
mkdir -p /opt/mysql/log
3.更改mysql目錄的許可權為自己目前使用者(我的使用者名稱是mysql)
chown mysql.mysql /opt/mysql
chown mysql.mysql /opt/mysql/data -
4.解壓mysql-5.6.21.tar.gz源碼包
tar zxvf ~/下載/mysql-5.6.21.tar.gz -C /usr/local/src/
chown mysql.mysql /usr/share/src/mysql-5.6.21
hown mysql.mysql /usr/share/src/mysql-5.6.21/ -R
5.下載gmock-1.6.0.zip,解壓至源碼中的source_downloads目錄下
http://bbs.ithome.com/forum.php?mod=attachment&aid=NTk1MjYwfGNkYzNjZDM0fDE0MTM4NTU1MzR8MjA5NDI5Nnw2Mzg1NTA%3D
unzip ~/下載/gmock-1.6.0.zip
mv gmock-1.6.0 /usr/local/src/mysql-5.6.21/source_downloads/
cd /usr/local/src/mysql-5.6.21/source_downloads/gmock-1.6.0
./configure
make
cd ../../
6.編譯安裝
cmake \-DCMAKE_INSTALL_PREFIX=/opt/mysql \-DMYSQL_DATADIR=/opt/mysql/database \-DWITH_MYISAM_STORAGE_ENGINE=1 \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_MEMORY_STORAGE_ENGINE=1 \-DWITH_ARCHIVE_STORAGE_ENGINE=1 \-DWITH_PARTITION_STORAGE_ENGINE=1 \-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \-DWITH_READLINE=1 \-DENABLE_DOWNLOADS=1 \-DENABLED_LOCAL_INFILE=1 \-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \-DMYSQL_TCP_PORT=3306 \-DEXTRA_CHARSETS=all \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci
make
make install
7.建立設定檔
cp /opt/mysql/support-files/my-default.cnf /opt/mysql/etc/my.cnf
[root@master support-files]# cat /opt/mysql/etc/my.cnf
[mysqld]
datadir = /opt/mysql
datadir = /opt/mysql/data
#socket = /tmp/mysql.sock
socket = /opt/mysql/data/mysql.sock
#log = /opt/mysql/log/mysql.log
pid-file = /opt/mysql/data/mysql.pid
user = mysql
port = 3306
#tmpdir = /tmp
log-error = /opt/mysql/log/mysql.err
[client]
socket = /opt/mysql/data/mysql.sock
8.初始化資料庫
/opt/mysql/scripts/mysql_install_db --user=mysql --basedir=/opt/mysql --datadir=/opt/mysql/data
9.建立管理MySQL資料庫的shell指令碼
root@master support-files]# cp mysql.server /etc/init.d/mysql
[root@master support-files]# chmod +x /etc/init.d/mysql
[root@master support-files]# service mysql start
Starting MySQL.. [確定]
[root@master support-files]#
10.設定MySQL root使用者的密碼
/opt/msql/bin/mysqladmin -u root password 123123 #修改mysql資料庫的root賬戶密碼是123123
11.登入mysql
[root@master support-files]# mysql -uroot -p123123
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.21 Source distribution
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
歡迎大家訪問我的個人網站 萌萌的IT人