mysql安装

mysql安装脚本

#!/bin/bash

wget http://downloads.mysql.com/archives/get/file/mysql-5.6.27-linux-glibc2.5-x86_64.tar.gz
cp mysql-5.6.27-linux-glibc2.5-x86_64.tar.gz /usr/local/
cd /usr/local
tar -xvf mysql-5.6.27-linux-glibc2.5-x86_64.tar.gz
groupadd mysql
useradd -g mysql mysql
mv mysql-5.6.27-linux-glibc2.5-x86_64 mysql
cd /usr/local/mysql
chown -R mysql:mysql ./
./scripts/mysql_install_db --user=mysql
chown -R root:root ./
chown -R mysql:mysql data
./support-files/mysql.server start
/usr/local/mysql/support-files/mysql.server restart
./bin/mysqladmin -u root -h localhost.localdomain password 'root'

第一次安装应该会失败
替换配置文件

[mysqld]
#skip-grant-tables
datadir=/var/lib/mysql
socket=/tmp/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
#mysql配置
max_connections=500
max_connect_errors=6000
open_files_limit=65535
table_open_cache=128
max_allowed_packet=512M
binlog_cache_size=1M

max_heap_table_size=64M
#临时表大小
tmp_table_size=128M
#读入缓冲区大小
read_buffer_size=128M
#查询缓冲
query_cache_size=128M

#慢日志
slow_query_log=1
long_query_time=1.5
slow_query_log_file=/data/mysql/mysql-slow.log

log-bin=/var/lib/mysql/mysql-bin
server-id=17
binlog-format=ROW #选择row模式


[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

执行重启命令
/usr/local/mysql/support-files/mysql.server restart

/usr/local/mysql/bin/mysql -uroot