bits/mysql.bits at master · capbash/bits · GitHub

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
#!/bin/bash

#-----------
# VARIABLES
#-----------
# Known versions from https://dev.mysql.com/downloads/mysql/
#   5.5.62
#   5.6.42
#   5.7.24

MYSQL_VERSION=${MYSQL_VERSION-5.7.24}
MYSQL_USER=${MYSQL_USER-mysql}
MYSQL_DATADIR=${MYSQL_DATADIR-/usr/local/mysql/data}
MYSQL_ROOT_PASSWORD=${MYSQL_ROOT_PASSWORD-nicetry}

#-----------
# HELPERS
#-----------

set_env()
{
  KEY=$1
  VAL=$2
  echo "export $KEY=$VAL" >> $HOME/.bash_aliases
}

#-----------
# INSTALLER
#-----------

MYSQLMM_VERSION=$(echo "$MYSQL_VERSION" | sed "s/^\(.*\)\..*$/\1/")


TEMP_PASSWORD=$(echo "2018-11-06T14:39:37.001166Z 1 [Note] A temporary password is generated for root@localhost: 6umRpyd2st=Q" | sed "s/^.*localhost:\s*\(.*\)$/\1/") ; echo ""; echo $TEMP_PASSWORD


# apt-get update
# apt-get install -y libaio1

# groupadd $MYSQL_USER && \
#   useradd -g $MYSQL_USER $MYSQL_USER

# (mkdir -p /opt/mysql && \
#   cd /opt/mysql && \
#   wget https://dev.mysql.com/get/Downloads/MySQL-${MYSQLMM_VERSION}/mysql-${MYSQL_VERSION}-linux-glibc2.12-x86_64.tar.gz && \
#   tar -xvf mysql-${MYSQL_VERSION}-linux-glibc2.12-x86_64.tar.gz && \
#   ln -s /opt/mysql/mysql-${MYSQL_VERSION}-linux-glibc2.12-x86_64 /usr/local/mysql)

# set_env PATH "/opt/mysql/mysql-${MYSQL_VERSION}-linux-glibc2.12-x86_64/bin:\$PATH"
source $HOME/.bash_aliases

(cd /usr/local/mysql && \
  chown -R $MYSQL_USER:$MYSQL_USER * && \
  mysqld --initialize --user=$MYSQL_USER --datadir=$MYSQL_DATADIR && \
  chown -R root . && \
  chown -R mysql $MYSQL_DATADIR && \
  cp support-files/mysql.server /etc/init.d/mysql.server && \
  update-rc.d -f mysql.server defaults && \
  /etc/init.d/mysql.server start && \
  mysqladmin -u root password "${MYSQL_ROOT_PASSWORD}")

touch /opt/mysql.bits