首先去官网查看mysql版本。才一个礼拜不到，我之前下载的是mysql5.7.23，现在在官网页面已然找不到了，只有5.7.24版本，不得不说更新真快。不过我下载的是mysql5.7.23，所以还是安装的是5.7.23
下载地址：https://www.mysql.com/downloads/
下载页面
-----------------------> 
下载下来后，比较坑的是。竟然没有源码编译安装的版本了，只有二进制版本。好吧，安装确实也比编译安装快了。。。。。
也是写了脚本来安装，自从shell脚本入门后，就要多尝试写脚本，加深印象。虽写的很low，希望之后装mysql8.0能复用
1 #!/usr/bin/bash
2 #lion
3 #2018-10-20
4 #install mysql
5
6 . common/color.sh
7 . common/download.conf
8
9 files_prefix=('mysql' 'python' 'vim')
10 soft_path=/soft
11 mysql_install_path=/usr/local/mysql
12 mysql_lib_path=/var/lib/mysql
13 cmake_package='cmake-3.12.3.tar.gz'
14 cmake_ver='cmake-3.12.3'
15 mysql_ver='mysql-5.7.23-linux-glibc2.12-x86_64'
16 mysql_file=$(ls | grep -i ${files_prefix[0]})
17 yum_list='sqlite-devel xz gcc automake zlib-devel openssl-devel epel-release git lsof ncurses-devel perl-Module-Build.noarc libaio'
18 yum_install()
19 {
20 for i in ${yum_list};do
21 yum -y install ${i}
22 done
23 }
24 check_package()
25 {
26 my=$(ls | grep -i ${files_prefix[0]})
27 py=$(ls | grep -i ${files_prefix[1]})
28 vm=$(ls | grep -i ${files_prefix[2]})
29}
30 Download_files()
31 {
32 Echo_blue "[+]Begin download install Package...."
33 [ ! -d "${soft_path}" ] && mkdir ${soft_path}
34 cd ${soft_path}
35 sleep 2
36 check_package
37 if [ -z ${my} ];then
38 wget -c ${Mysql_download}
39 if [ $? -eq 0 ] ;then
40 Echo_green "Mysql Package download sucessful!"
41 else
42 Echo_red "Download failure.Try it again"
43 exit 1
44 fi
45 else
46 Echo_red "The Package is existed"
47 fi
48 #[ ! -f ${cmake_package} ] && wget -c ${cmake_download}
49 }
50 Check_db()
51 {
52 Echo_yellow "[+]Check db is or not installed....."
53 sleep 1
54 if [ -z $(rpm -qa | grep mariadb) ]; then
55 Echo_white "No db is installed.Will install New DB"
56 else
57 Echo_gray "[+]Rmoving old db......."
58 sleep 1
59 rpm -e --nodeps $(rpm -qa | grep mariadb)
60 fi
61 }
62 add_user()
63 {
64 cat /etc/passwd | grep mysql &> /dev/null
65 [ $? -ne 0 ] && useradd mysql
66 }
67 add_path()
68 {
69 [ ! -d ${mysql_install_path} ] && mkdir ${mysql_install_path}
70 [ ! -d ${mysql_lib_path} ] && mkdir ${mysql_lib_path}
71 chown -R mysql:mysql ${mysql_lib_path}
72 }
73
74 tar_gz()
75 {
76 local FileName=$1
77 local DirName=$2
78 cd ${soft_path}
79 if [ ! -f ${FileName} ];then
80 Echo_red "The ${FileName} does not exist"
81 else
82 Echo_blue '[+]Begin uncompress files...'
83 tar zxvf ${FileName}
84 cd ${DirName}
85 fi
86 }
87 cmake_install()
88 {
89 tar_gz ${cmake_package} ${cmake_ver}
90 ./bootstrap
91 gmake -j `grep 'processor' /proc/cpuinfo | wc -l `
92 make install
93 }
94
95 tar_mysql()
96 {
97 tar_gz ${my} ${mysql_ver}
98 # cmake -DCMAKE_INSTALL_PREFIX=${mysql_install_path} -DMYSQL_DATADIR=${mysql_lib_path} -DSYSCONFDIR=/etc
99 # make;make install
100 mv * ${mysql_install_path}
101 cd ${soft_path} && rm -rf ${mysql_ver}
102 }
103
104 init_mysql()
105 {
106 Echo_blue 'mysql initialize'
107 [ -d ${mysql_lib_path} ] && cd ${mysql_lib_path} && rm -rf *
108 cd ${mysql_install_path}
109 ./bin/mysqld --initialize --user=mysql --datadir=${mysql_lib_path}
110 ./bin/mysql_ssl_rsa_setup --datadir=${mysql_lib_path}
111 }
112 set_start()
113 {
114 cd ${mysql_install_path}
115 cp support-files/mysql.server /etc/init.d/mysql
116 ln /usr/local/mysql/bin/mysql /usr/bin/mysql
117 }
118 db_install()
119 {
120 #yum_install
121 Download_files
122 Check_db
123 Echo_aqua "Begin install Mysql 5.7.23"
124 sleep 1
125 add_user
126 add_path
127 # cmake_install
128 tar_mysql
129 init_mysql
130 set_start
131 [ $? -eq 0 ] && Echo_green 'Mysql 5.7.23 initialize successful'
132 }
133 db_install 2>&1 | tee /root/mysql_install.log
Mysql_download='https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.23-linux-glibc2.12-x86_64.tar.gz'
Python_download='https://www.python.org/ftp/python/3.7.2/Python-3.7.1.tar.xz'
cmake_download='https://cmake.org/files/v3.12/cmake-3.12.3.tar.gz'
脚本运行效果
说明：mysql初始化后，会提供一个临时密码。需要记录下来
mysql 启动成功，但是进mysql的时候，报错
原因是my.cnf里[mysql] 和[client] 没有指定socket路径。很坑爹的是，我安装的这版连my.cnf也没有了。还是到网上下的模板
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL. [mysqld] # Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M # Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin # These are commonly set, remove the # and set as required.
basedir = /usr/local/mysql
datadir = /var/lib/mysql
port = 3306
# server_id = .....
socket = /tmp/mysqld.sock # Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER
explicit_defaults_for_timestamp=true [client]
default-character-set = utf8
socket = /tmp/mysqld.sock [mysql]
default-character-set = utf8
socket = /tmp/mysqld.sock
sql_mode没有指定的话，初始化的时候会有警告
开启查询缓存
explicit_defaults_for_timestamp=true
第一次进mysql，用临时密码进去后，会提示更改密码
mysql> SET PASSWORD = PASSWORD('123456') ;
Query OK, 0 rows affected, 1 warning (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
好像在8.0版本重设密码是，以后要实践一下
mysql> SET PASSWORD = '123456';
Query OK, 0 rows affected (0.01 sec)
至此简单的mysql就安装完毕。当然还有很多配置，需要在my.cnf中去配置。