mansurali901

系统数据:
  user()          当前用户
  database()      当前数据库
  version()       SQL版本号,最后为系统版本(nt-windows)
  @@datadir       数据库路径
连接型:
  concat()        concat(username,0x3a, password))
  group_concat()   select group_concat(DISTINCT file_priv, user) from mysql.user; //多个用户情况下, 查看load_file()权限
  concat_ws()     与上类似
编码:

mansurali901

# To install C/C++ Compilers, AutoConf and AutoMake
yum install gcc gcc-c++ autoconf automake -y

# Install Perl Compatible Regular Expressions Libraries (PCRE)
yum install pcre-devel -y

# Download Apache Source from Apache's Website
# http://httpd.apache.org/download.cgi
wget http://www.us.apache.org/dist/httpd/httpd-2.x.x.tar.gz

mansurali901

# Download and Install the Latest Updates for the OS
apt-get update && apt-get upgrade -y

# Set the Server Timezone to CST
echo "America/Chicago" > /etc/timezone
dpkg-reconfigure -f noninteractive tzdata

# Enable Ubuntu Firewall and allow SSH & MySQL Ports
ufw enable
ufw allow 22

mansurali901

# Download and Install the Latest Updates for the OS
apt-get update && apt-get upgrade -y

# Set the Server Timezone to CST
echo "America/Chicago" > /etc/timezone
dpkg-reconfigure -f noninteractive tzdata

# Enable Ubuntu Firewall and allow SSH & MySQL Ports
ufw enable
ufw allow 22

mansurali901

# Download and Install the Latest Updates for the OS
apt-get update && apt-get upgrade -y

# Set the Server Timezone to CST
echo "America/Chicago" > /etc/timezone
dpkg-reconfigure -f noninteractive tzdata

# Enable Ubuntu Firewall and allow SSH & MySQL Ports
ufw enable
ufw allow 22

mansurali901

# Download and Install the Latest Updates for the OS
apt-get update && apt-get upgrade -y

# Set the Server Timezone to CST
echo "America/Chicago" > /etc/timezone
dpkg-reconfigure -f noninteractive tzdata

# Enable Ubuntu Firewall and allow SSH & MySQL Ports
ufw enable
ufw allow 22

mansurali901

# Download and Install the Latest Updates for the OS
apt-get update && apt-get upgrade -y

# Set the Server Timezone to CST
echo "America/Chicago" > /etc/timezone
dpkg-reconfigure -f noninteractive tzdata

# Enable Ubuntu Firewall and allow SSH, HTTP & HTTPS Ports
ufw enable
ufw allow 22

mansurali901

# Download and Install the Latest Updates for the OS
apt-get update && apt-get upgrade -y

# Install essential packages
apt-get -y install \
    gcc g++ autoconf automake make sendmail git ruby zsh acl zip unzip \
    pkg-config gettext curl enchant \
    libpcre3-dev libssl-dev libxml2 libxml2-dev libcurl4-openssl-dev libenchant-dev libfreetype6 libfreetype6-dev libbz2-dev \
    libedit-dev libedit2 libtidy-dev libxslt1.1 libxslt1-dev libvpx-dev libxpm-dev libedit-dev libreadline-dev \
    libjpeg8-dev libmcrypt4 libmcrypt-dev libmhash-dev libmhash2 mcrypt libc-client2007e libc-client2007e-dev

mansurali901

#!/bin/bash
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin

# Temporary Path where the archive will be created and stored before uploading to S3
# Example: BACKUPPATH=/mnt
BACKUPPATH=/

# Amazon S3 Bucket name
# Example: S3BUCKET=production-database-backups
S3BUCKET=