MySQL自动安装脚本分享

本篇内容介绍了“MySQL自动安装脚本分享”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！

环境要求：centos：6.8
                MySQL：5.7.20
                MySQL安装文件名：mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz
                MySQL源文件路径：/usr/local/src
                MYSQL脚本文件：/usr/local/src/install_mysql.sh

1、脚本如下：

1. #/bin/sh
   

2. #px 2017-11-29
   

3. #mysql install
   

4. #email:kitten-pan@163.com & 752684428
   

5. #version 2.0
   

6. #mysql-version mysql5.7.20
   

7. 
   

8. source_path=/usr/local/src
   

9. install_path=/usr/local/mysql
   

10. install_name=mysql-5.7.20-linux-glibc2.12-x86_64
    

11. 
    

12. ##检测本机环境
    

13. env_fun()
    

14. {
    

15. echo "============检测本机环境,please wait ..."
    

16. username=`cat /etc/passwd |grep mysql|cut -c 1-5`
    

17.     if [ "$username" = "mysql" ];then
    

18.         echo "MySQL account is exits..."
    

19.         return 10
    

20.     else
    

21.         echo "mysql account is not exits,ready add..."
    

22.         groupadd mysql
    

23.         useradd -r -s /sbin/nologin -g mysql mysql -d /usr/local/mysql
    

24.         return 12
    

25.     fi
    

26. }
    

27. 
    

28. ##判断MySQL是否安装
    

29. check_fun()
    

30. {
    

31. rpm_name=`rpm -aq |grep mysql-server`
    

32. echo $rpm_name
    

33.     if [ ! $rpm_name ];then
    

34.         echo "begin check the source install,please wait for a moment..."
    

35.             if [ -d $install_path ];then
    

36.                 echo "source install is exist,quit..."
    

37.                 exit 0
    

38.             else
    

39.                 echo "本机未安装MySQL,稍后为你安装..."
    

40.                 install_fun
    

41.                 op_fun
    

42.                 
    

43.             fi
    

44.     else
    

45.         echo -n "rpm MySQL已经安装，是否删除？[yes|no]"
    

46.         read select
    

47.             if [ $select = yes ];then
    

48.                 rpm -e $rpm_name --nodeps
    

49.                 rm -rf /var/log/mysqld.log
    

50.                 check_fun
    

51.             else
    

52.                 exit 0
    

53.             fi
    

54.     fi
    

55. }
    

56. 
    

57. ###安装MySQL
    

58. install_fun()
    

59. {
    

60. read  -p "Input a mysql version:" -t 30  mysql_version
    

61. read  -p "Input a mysql port:" -t 30  mysql_port
    

62. read  -p "Input a mysql_server_id:" -t 30 mysql_server_id
    

63. cd $source_path && echo "解压中,please waiting..."
    

64. tar -zxvf ${install_name}.tar.gz && mv $install_name $install_path
    

65. ##创建数据目录
    

66. mkdir -pv /data/mysqldata
    

67. ###给MySQL目录的MySQL账号权限
    

68. cd /usr/local && chown mysql.mysql mysql
    

69. chown -R mysql.mysql /data/mysqldata
    

70. cd $install_path && bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysqldata
    

71. 
    

72. cd support-files && cp -rf mysql.server /etc/init.d/mysqld
    

73. sed -i 's#datadir\=\/usr\/local\/mysql\/data#\datadir\=\/data\/mysqldata#g' /etc/init.d/mysqld
    

74. 
    

75. cat > /etc/my.cnf << EOF
    

76. [client]
    

77. port = 3309
    

78. socket = /tmp/mysql.sock
    

79. default-character-set = utf8
    

80. 
    

81. [mysqld]
    

82. ##mysql-version=5.7.20
    

83. port = 3309
    

84. socket = /tmp/mysql.sock
    

85. datadir = /data/mysqldata
    

86. basedir = /usr/local/mysql
    

87. pid-file = /data/mysqldata/mysqld.pid
    

88. user = mysql
    

89. server-id = 1
    

90. lower_case_table_names = 1
    

91. character-set-server = utf8
    

92. back_log = 300
    

93. max_connections = 1000
    

94. max_connect_errors = 6000
    

95. open_files_limit = 65535
    

96. table_open_cache = 128
    

97. max_allowed_packet = 4M
    

98. binlog_cache_size = 1M
    

99. max_heap_table_size = 8M
    

100. tmp_table_size = 16M
     

101. 
     

102. read_buffer_size = 2M
     

103. read_rnd_buffer_size = 8M
     

104. sort_buffer_size = 8M
     

105. join_buffer_size = 8M
     

106. key_buffer_size = 4M
     

107. 
     

108. thread_cache_size = 8
     

109. query_cache_type = 0
     

110. query_cache_size = 2M
     

111. query_cache_limit = 2M
     

112. 
     

113. ft_min_word_len = 4
     

114. 
     

115. log_bin = mysql-bin
     

116. binlog_format = row
     

117. expire_logs_days = 30
     

118. 
     

119. log-error=/data/mysqldata/mysqld.log
     

120. slow_query_log = 1
     

121. long_query_time = 1
     

122. slow_query_log_file = /data/mysqldata/mysql-slow.log
     

123. 
     

124. performance_schema = 0
     

125. explicit_defaults_for_timestamp
     

126. 
     

127. skip-external-locking
     

128. default-time_zone = '+8:00'
     

129. 
     

130. default_storage_engine = InnoDB
     

131. 
     

132. innodb_file_per_table = 1
     

133. innodb_data_file_path = ibdata1:300M:autoextend
     

134. innodb_open_files = 5000
     

135. innodb_buffer_pool_size = 2048M
     

136. innodb_write_io_threads = 4
     

137. innodb_read_io_threads = 8
     

138. innodb_thread_concurrency = 0
     

139. innodb_purge_threads = 1
     

140. innodb_flush_log_at_trx_commit = 2
     

141. innodb_log_buffer_size = 128M
     

142. innodb_log_file_size = 256M
     

143. innodb_log_files_in_group = 2
     

144. innodb_max_dirty_pages_pct = 90
     

145. innodb_lock_wait_timeout = 120
     

146. 
     

147. bulk_insert_buffer_size = 8M
     

148. myisam_sort_buffer_size = 8M
     

149. myisam_max_sort_file_size = 10G
     

150. myisam_repair_threads = 1
     

151. interactive_timeout = 28800
     

152. wait_timeout = 300
     

153. 
     

154. [mysqldump]
     

155. quick
     

156. max_allowed_packet = 16M
     

157. 
     

158. [myisamchk]
     

159. key_buffer_size = 8M
     

160. sort_buffer_size = 8M
     

161. read_buffer = 4M
     

162. write_buffer = 4M
     

163. 
     

164. EOF
     

165. echo "export PATH=/$PATH:/usr/local/mysql/bin">>/etc/profile
     

166. echo 'export MYSQL_PS1="(\u@\h:\p) [\d]>"' >> /etc/profile
     

167. source /etc/profile
     

168. 
     

169. service mysqld restart
     

170. }
     

171. 
     

172. op_fun()
     

173. {
     

174. chmod 755 /etc/init.d/mysqld
     

175. chkconfig --add mysqld
     

176. chkconfig --level 345 mysqld on
     

177. }
     

178. 
     

179. 
     

180. main(){
     

181. echo "###==================================================###"
     

182. echo "###welcome to make install mysql with this script###"
     

183. echo "###copyright 2013 by px###"
     

184. echo "###==================================================###"
     

185. sleep 5
     

186. env_fun
     

187. re=$?
     

188. if [ re = 10 ];then
     

189.     check_fun
     

190. else
     

191.     check_fun
     

192. fi
     

193. }
     

194. main
     

195. exit 0

2、执行自动安装脚本
    需要填写MySQL的版本信息、端口信息、serverid信息等

点击(此处)折叠或打开

1. sh install_mysql.sh
   

2. ###==================================================###
   

3. ###welcome to make install mysql with this script###
   

4. ###copyright 2013 by px###
   

5. ###==================================================###
   

6. ============检测本机环境,please wait ...
   

7. mysql account is not exits,ready add...
   

8. 
   

9. begin check the source install,please wait for a moment...
   

10. 本机未安装MySQL,稍后为你安装...
    

11. Input a mysql version:5.7.20
    

12. Input a mysql port:3309
    

13. Input a mysql_server_id:1
    

14. 解压中,please waiting...

3、自动安装完毕 启动

# service mysqld  restart
MySQL server PID file could not be found!                  [FAILED]
Starting MySQL.............                                          [  OK  ]

4、登入MySQL 修改密码

点击(此处)折叠或打开

1. [root@ct562 mysqldata]# mysql -uroot -p
   

2. Enter password:
   

3. Welcome to the MySQL monitor. Commands end with ; or \g.
   

4. Your MySQL connection id is 3
   

5. Server version: 5.7.20-log
   

6. 
   

7. Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
   

8. 
   

9. Oracle is a registered trademark of Oracle Corporation and/or its
   

10. affiliates. Other names may be trademarks of their respective
    

11. owners.
    

12. 
    

13. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    

14. 
    

15. (root@localhost:mysql.sock) [(none)]>
    

16. (root@localhost:mysql.sock) [(none)]>
    

17. (root@localhost:mysql.sock) [(none)]>
    

18. (root@localhost:mysql.sock) [(none)]>
    

19. (root@localhost:mysql.sock) [(none)]>
    

20. (root@localhost:mysql.sock) [(none)]>set password for root@'localhost' =PASSWORD('sysdba@321')

“MySQL自动安装脚本分享”的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注亿速云网站，小编将为大家输出更多高质量的实用文章！