本文为大家分享了Linux环境下mysql5.6.24自动安装脚本代码，供大家参考，具体内容如下
说明：
一、本脚本仅供测试使用，若正式环境想要使用，需更改脚本的一些参数。
二、使用本脚本之前，需保证linux环境可以联网下载，若不能联网，则需要将下载好的mysql二进制包上传至linux中的/data目录下。
三、脚本使用是需一次输入三个参数：
1、需安装的mysql版本号，如：5.6.24
2、需安装的mysql端口设置，如：3306
3、mysql的server_id设置，如：1003306
使用步骤：
1、将下列脚本上传至linux环境中，我个人是以mysql_install.sh命名
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
#!/bin/bash #mysql_install by chen #Email：chenhz1218@gmail.com & 296966488@qq.com #version 2.0 #安装版本 5.6.20-5.6.25 #安装要求： #需要可以联网，若无网络，可以先创建/data目录，将安装包上传到/data目录下 #判断/data目录是否存在，若不存在则创建，并且下载mysql datamenu="/data"read -p "Input a mysql version:" -t 30 mysql_version read -p "Input a mysql port:" -t 30 mysql_port read -p "Input a mysql_server_id:" -t 30 mysql_server_id mysqlfile="$datamenu/mysql-$mysql_version-linux-glibc2.5-x86_64.tar.gz" if [ ! -d "$datamenu" ];then mkdir "$datamenu" wget -P /data http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-$mysql_version-linux-glibc2.5-x86_64.tar.gz elif [ ! -f "$mysqlfile" ];then wget -P /data http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-$mysql_version-linux-glibc2.5-x86_64.tar.gz fi #解压下载好的mysql cd /optmkdir mysql cd mysql tar zxvf $mysqlfile -C /opt/mysql #创建mysql用户 egrep "^mysql" /etc/group >& /dev/nullif [ $? -ne 0 ] then groupadd mysql fi #create user if not exists egrep "^mysql" /etc/passwd >& /dev/nullif [ $? -ne 0 ] then useradd -g mysql -s /sbin/nologin -d /usr/local/mysql mysql fi #创建mysql软连接，并授权给mysql用户 cd /usr/local/rm -rf /usr/local/mysqlln -s /opt/mysql/mysql-$mysql_version-linux-glibc2.5-x86_64 /usr/local/mysqlchown -R mysql:mysql /usr/local/mysqlchown -R mysql:mysql /usr/local/mysql/ #基于配置文件，创建mysql安装目录，并授权 mkdir -p /data/mysqlmkdir -p /data/mysql/mysql${mysql_port} cd /data/mysql/mysql${mysql_port}/ mkdir /data/mysql/mysql${mysql_port}/datamkdir /data/mysql/mysql${mysql_port}/logsmkdir /data/mysql/mysql${mysql_port}/tmpchown -R mysql:mysql /data/mysql/mysql${mysql_port} cat > /etc/my.cnf << EOF [client] port = ${mysql_port} socket = /tmp/mysql.sock # The MySQL server [mysqld] # Basic port = ${mysql_port} user = mysql basedir = /usr/local/mysqldatadir = /data/mysql/mysql${mysql_port}/datatmpdir = /data/mysql/mysql${mysql_port}/tmpsocket = /tmp/mysql.sock log-bin = /data/mysql/mysql${mysql_port}/logs/mysql-bin log-error = error.log slow-query-log-file = slow.log skip-external-locking skip-name-resolve log-slave-updates lower_case_table_names = 1 #忽略表名大小写 character_set_server = gbk innodb_file_per_table = 1 innodb_autoinc_lock_mode = 2 explicit_defaults_for_timestamp = truesql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES EOF #初始化mysql cd /usr/local/mysql./scripts/mysql_install_db --defaults-file=/etc/my.cnf #在/etc/init.d下创建mysql 启动脚本 cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql #添加环境变量，并使/etc/profile环境变量生效 echo "export PATH=$PATH:/usr/local/mysql/bin">>/etc/profile |
|
1
|
export PATH=$PATH:/usr/local/mysql/bin |
2、给脚本赋予可执行权限，
|
1
2
3
4
5
6
7
|
[root@zabbix-server ~]# rz -y z waiting to receive.**B0100000023be50 [root@zabbix-server ~]# ls anaconda-ks.cfg install.log install.log.syslog mysql_install.sh [root@zabbix-server ~]# chmod +x mysql_install.sh [root@zabbix-server ~]# ls -al|grep mysql_install.sh -rwxr-xr-x. 1 root root 3136 Jul 29 10:29 mysql_install.sh |
3、执行脚本，并输入三个参数，等待数据库安装
|
1
2
3
4
|
[root@MySQL ~]# ./mysql_install.sh Input a mysql version:5.6.24 Input a mysql port:3306 Input a mysql_server_id:1003306 |
4、启动数据库
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
[root@MySQL ~]# /etc/init.d/mysql start Starting MySQL.. [ OK ] [root@zabbix-server ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.24-log MySQL Community Server (GPL) Copyright (c) 2000, 2015, 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. mysql> show databases -> ; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | test | +--------------------+ 4 rows in set (0.00 sec) mysql> |
至此，linux下mysql安装已经完成，可以使用它做一些测试了。
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持服务器之家。
原文链接：https://blog.csdn.net/Snail1218/article/details/47124457
