1.文件到/data/package/下
mkdir -p /data/packages/
mysql-5.6.34-linux-glibc2.5-x86_64.tar.gz
my56.cnf
2.删除自带的mysql
rpm -qa |grep mysql
rpm -e mysql-devel-5.1.73-7.el6.x86_64 --nodeps
rpm -e mysql-5.1.73-7.el6.x86_64 --nodeps
rpm -e mysql-libs-5.1.61-4.el6.x86_64 --nodeps
3.安装
yum -y install cmake make gcc gcc-c++ gd-devel ncurses-devel libaio libaio-devel bison autoconf curl-devel mlocate readline-devel readline flex
cd /data/packages/
tar -zxf mysql-5.6.34-linux-glibc2.5-x86_64.tar.gz -C /usr/local/
cd /usr/local/
ln -s mysql-5.6.34-linux-glibc2.5-x86_64 mysql
rm -rf mysql/data
--修改下 server_id
mv /data/packages/my56.cnf /etc/my.cnf
mkdir -p /data/mysql/{data,log,tmp}
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
chown -R mysql:mysql /data/mysql/data /data/mysql/log /data/mysql/tmp
chown -R mysql:mysql /usr/local/mysql-5.6.34-linux-glibc2.5-x86_64
chown mysql:root /etc/my.cnf
chmod 640 /etc/my.cnf
ln -s /data/mysql/data /usr/local/mysql/data
ln -s /data/mysql/log /usr/local/mysql/log
ln -s /data/mysql/tmp /usr/local/mysql/tmp
vim ~/.bash_profile
末行添加:
export PATH=$PATH:/usr/local/mysql/bin
source ~/.bash_profile
4.初始化
/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --defaults-file=/etc/my.cnf --user=mysql
5.启动
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
service mysqld start
chkconfig --add mysqld
6.进入mysql并删除多余的用户并创建新用户
mysql
delete from mysql.user where user!='root';
grant reload,process,lock tables,super,select,event,replication client,replication slave on *.* to 'slave-repl'@'10.6.%' identified by '8BhHY0vK7Al4btd';
update mysql.user set password=password('mjeY155vQdEE30rU2jhj') where user = 'root';
flush privileges;
------------------------ 5.7 安装 ----------------------------
0. 目录下所有文件夹所属的用户组、用户以及权限
chown -R mysql:mysql /opt/mysql
chmod -R 755 /opt/mysql
1. mysql5.7 安装时 进入 /opt/mysql/bin/
./mysqld --initialize --user=mysql --datadir=/opt/mysql/data --basedir=/opt/mysql --defaults-file=/etc/my.cnf
root@localhost: =kc?3vpEK=ju -- 编译安装并初始化mysql,务必记住数据库管理员临时密码
2. 启动服务
/opt/mysql/support-files/mysql.server start
-- 启动时可能报错
mkdir /var/log/mariadb
touch /var/log/mariadb/mariadb.log
# 用户组及用户
chown -R mysql:mysql /var/log/mariadb/
3. 添加软连接,并重启mysql 服务
//添加软连接
ln -s /opt/mysql/support-files/mysql.server /etc/init.d/mysql
ln -s /opt/mysql/bin/mysql /usr/bin/mysql
//重启mysql服务
service mysql restart
mysql -h192.168.1.10 -P3306 -uroot -pmima
4. 设置开机自启
//将服务文件拷贝到init.d下,并重命名为mysql
cp /opt/mysql/support-files/mysql.server /etc/init.d/mysqld
//赋予可执行权限
chmod +x /etc/init.d/mysqld
//添加服务
chkconfig --add mysqld
//显示服务列表
chkconfig --list
5. 开放3306端口,测试本地客户端是否连接成功
//开放3306端口命令
firewall-cmd --zone=public --add-port=3306/tcp --permanent
//配置立即生效
firewall-cmd --reload
---------- 开启binlog ------------
show variables like '%log_bin%';
1. 创建目录和设置权限组
mkdir /opt/mysql/log-bin
chown -R mysql:mysql /opt/mysql
chmod -R 755 /opt/mysql
2. 增加以下配置
log_bin=mysql_bin
expire_logs_days=7
binlog_format=Row
server-id=1
-- binlog 日志默认位置
查看是否生成了文件, 文件目录默认是在 /var/lib/mysql
下以mysql-bin.00000X等做名称, 而mysqld-bin.index则是记录了所有的log的文件名称;
-- # 第二个参数是binlog日志的基本文件名,后面会追加标识来表示每一个文件
-- log_bin_basename=/opt/mysql/log-bin/mysql-bin
-- # 第三个参数指定的是binlog文件的索引文件,这个文件管理了所有的binlog文件的目录
-- log_bin_index=/opt/mysql/log-bin/mysql-bin.index
--
-- # binlog日志格式,MySQL默认采用的是STATEMENT,建议使用MIXED
-- binlog_format = ROW
-- # 配置定时清理
-- expire_logs_days = 5
-- # 配置修改后的日志路径
-- log-bin=/opt/mysql/log-bin/mysql-bin
3. 重启MySQL
service mysql restart