MYSQL安装和升级

MYSQL安装：
安装大致步骤：
1、建议使用Linux-Gerneric版本
2、配置/etc/my.cnf
3、解压缩mysql-VERSION-linux-glibc2.5-x86_64.tar.gz
4、根据官方文档mysql进行安装
5、设置环境变量 PATH=$PATH:/${mysql_path}/mysql/bin

配置/etc/my.cnf
[client]
user=root
password=test_123456
socket=/tmp/mysql.sock
[mysqld]

########basic settings########

server-id = 11
port = 3306
user = mysql
bind_address = 10.156.236.252
autocommit = 0
character_set_server=utf8mb4
skip_name_resolve = 1
max_connections = 800
max_connect_errors = 1000
datadir = /usr/local/data #####
transaction_isolation = READ-COMMITTED
explicit_defaults_for_timestamp = 1
join_buffer_size = 134217728
tmp_table_size = 67108864
tmpdir = /tmp
max_allowed_packet = 16777216
sql_mode = “STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER”
interactive_timeout = 1800
wait_timeout = 1800
read_buffer_size = 16777216
read_rnd_buffer_size = 33554432
sort_buffer_size = 33554432
socket = /tmp/mysql.sock
########log settings########

log_error = /var/log/mysqld.log
slow_query_log = 1
slow_query_log_file = slow.log
log_queries_not_using_indexes = 1
log_slow_admin_statements = 1
log_slow_slave_statements = 1
log_throttle_queries_not_using_indexes = 10
expire_logs_days = 90
long_query_time = 2
min_examined_row_limit = 100
log_timestamps = SYSTEM

5.6安装步骤
1、cd /usr/local
2、tar -zxvf mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz
3、groupadd mysql
4、useradd -r -g mysql mysql
5、ln -s /usr/local/mysql-5.6.40-linux-glibc2.12-x86_64 mysql
6、cd mysql
7、chown -R mysql .
8、chgrp -R mysql .
9、scripts/mysql_install_db --user=mysql
10、chown -R root .
11、chown -R mysql data
12、bin/mysqld_safe --user=mysql &
13、cp support-files/mysql.server /etc/init.d/mysql.server

5.7安装步骤
1、cd /usr/local
2、tar -zxvf mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz
3、groupadd mysql
4、useradd -r -g mysql mysql
5、ln -s /usr/local/mysql-5.7.27-linux-glibc2.12-x86_64 mysql
6、cd mysql
7、mkdir mysql-files
8、chmod 770 mysql-files
9、chown -R mysql .
10、chgrp -R mysql .
11、bin/mysqld --initialize --user=mysql&
12、cp support-files/mysql.server /etc/init.d/mysql.server

配置环境变量
PATH=$PATH:/usr/local/mysql/bin

查看日志 /var/log/mysqld.log 安装是否成功，如果是5.7安装则还需查看root临时密码

mysql数据库服务处理
service mysql.server status --查看状态
service mysql.server start --启动
service mysql.server stop --关闭

MYSQL升级方法：
5.6–>5.7
升级大致步骤：
1、关闭数据库服务
2、备份系统表
3、更换软连接
4、开启数据库
5、升级系统表

service mysql.server stop

cd /usr/local
mkdir /usr/local/databak
cp -r /usr/local/data/mysql/ /usr/local/databak/mysql/

unlink mysql
ln -s /usr/local/mysql-5.7.27-linux-glibc2.12-x86_64 mysql

service mysql.server start

mysql_update -p -s