MYSQL安装

一、准备工作


0、配置主机名：/etc/hosts


1、安装编译器：
yum install gcc gcc-c++ -y
yum install cmake -y


2、安装依赖库：
yum -y install bison libaio libaio-devel zlib zlib-devel ncurses-devel readline readline-devel gcc gcc-c++ cmake




一定要先保证这些依赖库都安装成功，才能进行下面的编译工作。
若cmake编译报错后，再去安装缺少的依赖库，再cmake还是会报错，需要重新解压源码包。


3、下载并解压：MySQL-5.6.32.tar.gz。
tar –zxvf MySQL-5.6.32.tar.gz
将生成的目录重命名为 mysqlinstall


4、添加用户
    groupadd mysql
    useradd -g mysql mysql
     
5、创建安装路径
    mkdir -p /home/mysql/
    mkdir -p /home/mysql/tmp/
    备注：
    数据安装在mysql/data
    Sork文件在mysql/tmp/mysql.sock




二安装MYSQL
1.进入到安装目录下
cd /home/mysqlinstall


2.CMAKE


cmake -DCMAKE_INSTALL_PREFIX=/home/mysql/ -DMYSQL_DATADIR=/home/mysql/data -DMYSQL_UNIX_ADDR=/home/mysql/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_EXAMPLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_ZLIB=bundled -DWITH_EMBEDDED_SERVER=1 -DWITH_DEBUG=0 -DENABLE_DOWNLOADS=1 -DWITH_FEDERATED_STORAGE_ENGINE=1


make


3.安装
make install


4、创建数据文件路径，赋管理权限：
    mkdir -p /home/mysql/data  
    chown -R mysql.mysql /home/mysql/data/*








5.初始化
cd /home/mysql/scripts


./mysql_install_db --basedir=/home/mysql --datadir=/home/mysql/data --user=mysql




6.修改配置文件:my.cnf
cd data/mysql
================================================================
[mysqld]
log_bin = master-bin
log_bin-index = master-bin.index
expire_logs_days = 30 
max_binlog_size = 50M
binlog_format = MIXED
log-bin-trust-function-creators = 1
sort_buffer_size = 8M
join_buffer_size = 256M
innodb_buffer_pool_size = 512M
read_rnd_buffer_size = 8M
slow_query_log = 1
long_query_time = 3
innodb_flush_log_at_trx_commit = 1
sync_binlog = 1
server_id = 1
port = 3306
basedir = /home/mysql/
datadir = /home/mysql/data/
socket = /home/mysql/mysql.sock
max_connections = 500
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
==========================================================


7.拷可执行文件
cp /home/mysql/bin/my* /usr/sbin








8.运行




mysqld_safe --defaults-file=/home/mysql/my.cnf 2>&1 > /home/mysql/mysqldsafe.log 






查看是否运行成功：
netstat -lntup|grep 3306


9、mysql客户端连接，默认密码为空。
    mysql -uroot -S /home/mysql/tmp/mysql.sock # my.cnf文件中指定的socket文件路径


    （配置密码后）mysql -uroot -pchiscdc -S /data/mysql/tmp/mysql.sock






10.添加密码


cd /home/mysql/bin/
mysqladmin -uroot -S /home/mysql/tmp/mysql.sock password "chiscdc"


11.停止
mysqladmin -uroot -pchiscdc -S /home/mysql/tmp/mysql.sock shutdown




12.授权


GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'chiscdc' WITH GRANT OPTION; 


mysql>FLUSH   PRIVILEGES  //修改生效
mysql>EXIT  //退出MySQL服务器
这样就可以在其它任何的主机上以root身份登录啦！


备注：用户信息保存在mysql数据库的user表里面  *.*是指为*库的*表授权


13.将MYSQLD变成一个服务，并添加到开机启动
cd support-files/
cp mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld
service mysqld start
chkconfig --add mysqld
chkconfig mysqld on
chkconfig --list mysqld


14.创建备份脚本，添加可执行权限 chmod 777 


#!/bin/bash
# Name:bakmysql.sh
# This is a ShellScript For Auto DB Backup and Delete old Backup
#
backupdir=/data/mysqlbackup
time=`date +%Y%m%d%H`
/data/mysql/bin/mysqldump -uroot -pchiscdc test1 | gzip > $backupdir/database$time.sql.gz
#
find $backupdir -name "name_*.sql.gz" -type f -mtime +30 -exec rm {} \; > /dev/null 2>&1


#


15.在ETC里面编辑crontab 在最后一行添加00 3 * * * root /usr/sbin/bakmysql.sh


每10分钟备份，是在分前面加/ 
/10 * * * root /usr/sbin/bakmysql.sh


16.重启定时运行服务  service crond restart