上一篇是linux離線部署tomcat：
http://www.reibang.com/p/2b782accface
系統(tǒng)版本：LINUX centos release 6.5 2.6.32-431.el6.x86_64
MYSQL版本：MySQL-5.6.41-1.el6.x86_64
第一步 官網(wǎng)下載mysql rpm包
官網(wǎng)下載地址：https://dev.mysql.com/downloads/
1.點擊鏈接MySQL Community
1.1.png
2.點擊鏈接MySQL Community Server 5.6
1.2.png
3.選中與系統(tǒng)版本匹配的mysql版本
1.3.png
1.4.png
1.5.png
安裝前卸載之前的mysql服務(wù)屯吊，如果沒有mysql服務(wù)可以忽略該步驟
查看當前l(fā)inux系統(tǒng)中的mysql服務(wù)
[root@xx.xx.xx ~]# rpm -qa|grep -i mysql
MySQL-server-x.x.xx.x86_64
MySQL-client-x.x.xx..x86_64
卸載mysql服務(wù)
[root@xx.xx.xx ~]# rpm -e MySQL-server-x.x.xx.x86_64
[root@xx.xx.xx ~]# rpm -e MySQL-client-x.x.xx..x86_64
第二步 在linux安裝rpm
1.上傳并解壓mysql rpm
解壓并查看
[root@xx.xx.xx mysql]# tar -xzvf MySQL-5.6.41-1.el6.x86_64.rpm-bundle.tar
[root@xx.xx.xx mysql]# ll
-rw-r--r--. 1 7155 31415 18896876 Jun 18 15:14 MySQL-client-5.6.41-1.el6.x86_64.rpm
-rw-r--r--. 1 7155 31415 3391756 Jun 18 15:14 MySQL-devel-5.6.41-1.el6.x86_64.rpm
-rw-r--r--. 1 7155 31415 89948924 Jun 18 15:14 MySQL-embedded-5.6.41-1.el6.x86_64.rpm
-rw-r--r--. 1 7155 31415 57507364 Jun 18 15:15 MySQL-server-5.6.41-1.el6.x86_64.rpm
-rw-r--r--. 1 7155 31415 1965492 Jun 18 15:16 MySQL-shared-5.6.41-1.el6.x86_64.rpm
-rw-r--r--. 1 7155 31415 3969752 Jun 18 15:16 MySQL-shared-compat-5.6.41-1.el6.x86_64.rpm
-rw-r--r--. 1 7155 31415 51822464 Jun 18 15:16 MySQL-test-5.6.41-1.el6.x86_64.rpm
2.按順序安裝rpm
先安裝MySQL-server-5.6.41-1.el6.x86_64.rpm
[root@xx.xx.xx mysql]# rpm -ivh MySQL-server-5.6.41-1.el6.x86_64.rpm
出現(xiàn)安裝錯誤 需要依賴libaio.so.1()(64bit)
/usr/bin/perl is needed by MySQL-server-5.6.38-1.el6.x86_64
libaio.so.1()(64bit) is needed by MySQL-server-5.6.38-1.el6.x86_64
libaio.so.1(LIBAIO_0.1)(64bit) is needed by MySQL-server-5.6.38-1.el6.x86_64
libaio.so.1(LIBAIO_0.4)(64bit) is needed by MySQL-server-5.6.38-1.el6.x86_64
libnuma.so.1()(64bit) is needed by MySQL-server-5.6.38-1.el6.x86_64
libnuma.so.1(libnuma_1.1)(64bit) is needed by MySQL-server-5.6.38-1.el6.x86_64
libnuma.so.1(libnuma_1.2)(64bit) is needed by MySQL-server-5.6.38-1.el6.x86_64
安裝libaio rpm掰烟，如果還有錯誤 先查看gcc環(huán)境是否安裝
查看gcc是否安裝
可以通過 ：gcc -v ps -ef|grep gcc rpm -qa|grep -i gcc
[root@xx.xx.xx ~]# gcc -v
[root@xx.xx.xx ~]# ps -ef|grep gcc
[root@xx.xx.xx ~]# rpm -qa|grep -i gcc
如果查詢后為空 就需要重新添加gcc環(huán)境
安裝libaio rpm
[root@xx.xx.xx mysql]# rpm -ivh libaio-0.3.107-10.el6.x86_64.rpm
查看是否安裝完成
[root@xx.xx.xx mysql]# rpm -qa | grep libaio
libaio-0.3.107-10.el6.x86_64
離線部署mysql5.6 source 下載 密碼：fye2
再重新安裝MySQL-server-5.6.41-1.el6.x86_64.rpm
[root@xx.xx.xx mysql]# rpm -ivh MySQL-server-5.6.41-1.el6.x86_64.rpm --force --nodeps
安裝 MySQL-client-5.6.41-1.el6.x86_64.rpm
[root@xx.xx.xx mysql]# rpm -ivh MySQL-client-5.6.41-1.el6.x86_64.rpm
第三步 啟動mysql服務(wù)
啟動mysql服務(wù)
[root@ xx.xx.xx mysql] service mysql start
查看默認生成的隨機密碼
[root@centos6 ~]# cat /root/.mysql_secret
如果查詢?yōu)榭?不為空可以忽略此步驟
查詢?yōu)榭招枰匦鲁跏蓟瘮?shù)據(jù)庫
//根據(jù)自己系統(tǒng)的mysql目錄
//進入mysql/bin 執(zhí)行./mysql_install_db
[root@xx.x.xx /]# find -name *mysql*
//此處忽略不用的目錄
./var/lib/mysql-files
./var/lib/mysql
./var/lib/mysql/mysql
./var/lib/mysql/mysql.sock
./usr/bin/mysql_waitpid
./usr/bin/mysqlaccess.conf
./usr/bin/mysql_embedded
./usr/bin/mysql_config_editor
./usr/bin/mysqldumpslow
./usr/bin/mysql_tzinfo_to_sql
./usr/bin/mysql_fix_extensions
./usr/bin/mysql_find_rows
./usr/bin/mysqladmin
./usr/bin/msql2mysql
./usr/bin/mysql_convert_table_format
./usr/bin/mysqldump
./usr/bin/mysql_setpermission
./usr/bin/mysql_upgrade
./usr/bin/mysql_zap
./usr/bin/mysqlimport
./usr/bin/mysqlslap
./usr/bin/mysql
./usr/bin/mysql_secure_installation
./usr/bin/mysqlaccess
./usr/bin/mysql_plugin
./usr/bin/mysqlhotcopy
./usr/bin/mysqlbinlog
./usr/bin/mysql_install_db
./usr/bin/mysql_config
./usr/bin/mysqlshow
./usr/bin/mysqltest
./usr/bin/mysqld_multi
./usr/bin/mysqlbug
./usr/bin/mysqlcheck
./usr/bin/mysqld_safe
//刪除mysql/var下所有數(shù)據(jù)
[root@xx.x.xx /]# cd /var/lib/
[root@xx.x.xx /]# rm -rf mysql
//創(chuàng)建mysql目錄
[root@xx.x.xx /]# mkdir mysql
//進入bin目錄執(zhí)行初始化./mysql_install_db
[root@xx.x.xx /]# cd /usr/bin
[root@xx.x.xx /]# ./mysql_install_db
//進入 /var/lib/mysql 查看文件 應該創(chuàng)建了表的信息
[root@xx.x.xx mysql]# ll
total 503856
-rw-rw---- 1 mysql mysql 56 Aug 10 08:42 auto.cnf
-rw-rw---- 1 mysql mysql 415236096 Aug 10 09:54 ibdata1
-rw-rw---- 1 mysql mysql 50331648 Aug 10 09:54 ib_logfile0
-rw-rw---- 1 mysql mysql 50331648 Aug 10 09:54 ib_logfile1
drwx------ 2 mysql mysql 4096 Aug 10 08:40 mysql
srwxrwxrwx 1 mysql mysql 0 Aug 10 08:42 mysql.sock
drwx------ 2 mysql mysql 4096 Aug 10 08:40 performance_schema
drwx------ 2 mysql mysql 4096 Aug 10 08:40 test
//對mysql文件修改權(quán)限
[root@xx.x.xx mysql]# chown mysql:mysql -R .
第四步 登錄mysql 設(shè)置密碼并設(shè)置允許遠程連接
登錄mysql
[root@xx.x.xx mysql]# mysql -uroot -p
提示輸入新密碼
開啟遠程連接
mysql> grant all privileges on *.* to '用戶名稱' @'遠程連接的ip' identified by '遠程連接密碼';
mysql> flush privileges;
//還需要開啟Linux對外的3306端口
[root@xx.xx.xx ~]# vi /etc/sysconfig/iptables
//添加
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
//重啟服務(wù)
[root@xx.xx.xx ~]# /etc/init.d/iptables restart
//查看端口是否開放
[root@xx.xx.xx ~]# /sbin/iptables -L -n
-- The end --
