Mysql-centos7安装5.6

cd /usr/local/src/ && rz -b
yum -y install gcc gcc-c++ cmake bison ncurses-devel

tar xzf mysql-5.6.38.tar.gz && cd mysql-5.6.38
cmake . \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/usr/local/mysql/data/ \
-DDEFAULT_CHARSET=utf8 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=big5,ascii,gb2312,gbk,utf8,latin1
make && make install

echo 'PATH=/usr/local/mysql/bin:$PATH:$HOME/bin' >> /etc/profile
echo "export PATH" >> /etc/profile
source /etc/profile

id -u mysql &>/dev/null || useradd mysql -M -s /sbin/nologin
mkdir -pv /backup/mysql_log/{log_bin,slow_log} /data/mysql_data /var/run/mysqld
chown -R mysql:root /backup/mysql_log /data/mysql_data /var/run/mysqld
chmod 750 /backup/mysql_log /data/mysql_data

# cp -f support-files/my-medium.cnf /etc/my.cnf
cat > /etc/my.cnf << 'EOF'
[client]
port               = 3306
socket             = /tmp/mysql.sock
default-character-set = utf8

[mysql]
prompt = "(\u@\h:)[\d]> "

[mysqld]
user = mysql
port = 3306
socket = /tmp/mysql.sock
datadir = /data/mysql_data/data

skip-external-locking
skip-name-resolve

##INNODB
innodb_buffer_pool_size = 4G
innodb_file_per_table = 1  
innodb_data_home_dir       = /data/mysql_data/data
innodb_data_file_path      = ibdata1:1G:autoextend
innodb_log_file_size       = 512M
innodb_log_buffer_size     = 32M


######slowquery
slow_query_log = 1
slow_query_log_file = /data/mysql_log/mysql-slow.log
log-queries-not-using-indexes = true
long_query_time  = 1

##### Replication Master Server (default)
##### binary logging is required for replication
log-bin = /backup/mysql_log/mysql-bin.bin
binlog_format = MIXED
max-binlog-size  = 1G
expire_logs_days = 5
binlog_cache_size = 32M
log_bin_trust_function_creators = 1


[mysqldump]
quick
max_allowed_packet = 32M


[isamchk]
key_buffer = 128M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M


[myisamchk]
key_buffer = 128M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout
EOF

# cd /usr/local/mysql3308 && ./scripts/mysql_install_db --defaults-file=/usr/local/mysql3308/my.cnf --user=mysql --datadir=/data2/mysql_data/3308/data
# cd /usr/local/mysql && /usr/local/mysql/scripts/mysql_install_db --user=mysql --datadir=/data/mysql_data/data

# centos7 也可以用/etc/init.d/mysqld进行管理，如果 init 管理脚本需要手动初始化数据库
# cd /usr/local/mysql && install -c -o root -g root -m 744 support-files/mysql.server /etc/init.d/mysqld
# chkconfig --level 345 mysqld on
# /etc/init.d/mysqld start

cat > /usr/local/mysql/bin/mysql-systemd-start << 'EOF'
#! /bin/bash
#

# Scripts to run by MySQL systemd service
# 
# Needed argument: pre | post
# 
# pre mode  :  try to run mysql_install_db and fix perms and SELinux contexts
# post mode :  ping server until answer is received
# 

get_option () {
    local section=$1
    local option=$2
    local default=$3
    ret=$(/usr/local/mysql/bin/my_print_defaults $section | grep '^--'${option}'=' | cut -d= -f2- | tail -n 1)
    [ -z "$ret" ] && ret=$default
    echo $ret
}

install_db () {    
    # Note: something different than datadir=/var/lib/mysql requires SELinux policy changes (in enforcing mode)
    datadir=$(get_option mysqld datadir "/var/lib/mysql")

    # Restore log, dir, perms and SELinux contexts
    if [ ! -d "$datadir" -a ! -h "$datadir" -a "x$(dirname "$datadir")" = "x/var/lib" ]; then
    install -d -m 0755 -omysql -gmysql "$datadir" || exit 1
    fi
    log=/var/log/mysqld.log
    [ -e $log ] || touch $log
    chmod 0640 $log
    chown mysql:mysql $log || exit 1
    if [ -x /usr/sbin/restorecon ]; then
        /usr/sbin/restorecon "$datadir"
        /usr/sbin/restorecon $log
        for dir in /var/lib/mysql-files ; do
            if [ -x /usr/sbin/semanage -a -d /var/lib/mysql -a -d $dir ] ; then
        /usr/sbin/semanage fcontext -a -e /var/lib/mysql $dir >/dev/null 2>&1
        /sbin/restorecon $dir
        fi
    done
    fi
    
    # If special mysql dir is in place, skip db install 
    [ -d "$datadir/mysql" ] && exit 0
    
    # Create initial db
    cd /usr/local/mysql;./scripts/mysql_install_db --datadir="$datadir" --user=mysql
    exit 0
}

pinger () {
    # Wait for ping to answer to signal startup completed,
    # might take a while in case of e.g. crash recovery
    # MySQL systemd service will timeout script if no answer
    datadir=$(get_option mysqld datadir "/var/lib/mysql")
    socket=$(get_option mysqld socket "$datadir/mysql.sock")
    case $socket in
        /*) adminsocket="$socket" ;;
        *) adminsocket="$datadir/$socket" ;;
    esac

    while /bin/true ; do
        sleep 1
        /usr/local/mysql/bin/mysqladmin --no-defaults --socket="$adminsocket" --user=UNKNOWN_MYSQL_USER ping >/dev/null 2>&1 && break
    done
    exit 0
}

# main
case $1 in
    "pre") install_db ;;
    "post") pinger ;;
esac

exit 0
EOF

# 设置执行权限
chmod 755 /usr/local/mysql/bin/mysql-systemd-start

cat > /usr/lib/systemd/system/mysqld.service << 'EOF'
[Unit]
[Unit]
Description=MySQL Community Server
After=network.target
After=syslog.target

[Install]
WantedBy=multi-user.target
Alias=mysql.service

[Service]
User=mysql
Group=mysql

# Execute pre and post scripts as root
PermissionsStartOnly=true

# Needed to create system tables etc.
ExecStartPre=/usr/local/mysql/bin/mysql-systemd-start pre

# Start main service
ExecStart=/usr/local/mysql/bin/mysqld_safe --basedir=/usr/local/mysql

# Don't signal startup success before a ping works
ExecStartPost=/usr/local/mysql/bin/mysql-systemd-start post

# Give up if ping don't get an answer
TimeoutSec=600

Restart=always
PrivateTmp=false
EOF

systemctl enable mysqld.service 
systemctl start mysqld.service 

netstat -ntlp|grep 3306 && mysql -uroot -h127.0.0.1 << 'EOF'
UPDATE mysql.user SET Password=PASSWORD('123456') WHERE User='root';
DELETE FROM mysql.user WHERE User='';
DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('127.0.0.1');
DELETE FROM mysql.db WHERE Db='test' OR Db='test\_%';
DROP DATABASE test;
FLUSH PRIVILEGES;
EOF

cat > ~/.my.cnf << 'EOF'
[client]
user="root"
password="123456"
default-character-set = "utf8"
host=127.0.0.1

[mysql]
prompt = "(\u@\h:)[\d]> "
default-character-set = "utf8"
EOF