--1.為mysql新建組和用戶
| # useradd -M -s /sbin/nologin mysql |
--2.安裝需要的庫，編譯器
| # yum install ncurses-devel openssl-devel cmake -y |
--3.解壓
| # tar zxvf mysql-5.6.35.tar.gz# cd mysql-5.6.35 |
--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_TCP_PORT=3306 /-DENABLED_LOCAL_INFILE=1 /-DWITH_PARTITION_STORAGE_ENGINE=1 /-DEXTRA_CHARSETS=all /-DDEFAULT_CHARSET=utf8 /-DDEFAULT_COLLATION=utf8_general_ci /-DMYSQL_USER=mysql /-DWITH_DEBUG=0 /-DWITH_SSL=system# make# make install |
--5.拷貝模版，作為配置文件
| # cp support-files/my-default.cnf /etc/my.cnf |
--6.設置mysql權限
| # chown -R mysql.mysql /usr/local/mysql/ |
--7.初始化mysql數據庫
| # /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql# chown -R root /usr/local/mysql/# chown -R mysql /usr/local/mysql/data/ |
--8.設置mysql開機自啟動
| # cp support-files/mysql.server /etc/init.d/mysqld# chmod +x /etc/init.d/mysqld# chkconfig mysqld on |
--9.測試并運行mysql
| #service mysqld start |
--10.修改mysql管理員密碼
| #/usr/local/mysql/bin/mysqladmin -u root password '要設置的密碼' |
--11.使用用戶登錄mysql
| # /usr/local/mysql/bin/mysql -u root -p |
--12.加入環境變量
| # echo 'PATH=/usr/local/mysql/bin/:$PATH' >>/etc/profile# source /etc/profile |
CentOS 6.5最小化編譯安裝mysql 5.5.35配置多實例
1、關閉防火墻
| 1234567 [root@mysql ~]# service iptables stopiptables: Setting chains to policy ACCEPT: filter [ OK ]iptables: Flushing firewall rules: [ OK ]iptables: Unloading modules: [ OK ][root@mysql ~]# chkconfig iptables off[root@mysql ~]# chkconfig iptables --listiptables 0:off 1:off 2:off 3:off 4:off 5:off 6:off |
2、關閉selinux
| 12 [root@mysql ~]# setenforce 0[root@mysql ~]# vim /etc/sysconfig/selinux |
修改下面這一行；
| SELINUX=disabled12 [root@mysql ~]# getenforce Permissive |
3、安裝mysql依賴包及編譯工具；
| 1234 [root@mysql ~]# yum install libaio-devel -y[root@mysql ~]# yum install -y ncurses-devel[root@mysql ~]# yum install -y gcc gcc-c++ [root@mysql ~]# yum install -y cmake |
