mysql 5.7安装方法
1.解决依赖关系
1. 解决依赖关系
[root@locahost ~]# yum -y install ncurses-base
ncurses-devel
ncurses-libs
libtool-ltdl-devel libxm12 libxm12-devel zlib-devel xz-devel
pcre pcre-devel openssl openssl-devel gd gd-devel
perl perl-devel perl-ExtUtils-Embed
2.安装
2.安装mysql
[root@locahost ~]# tar -xf mysql-5.7.29-el7-x86_64.tar
[root@locahost ~]# tar -zxvf mysql-5.7.29-el7-x86_64.tar.gz
[root@locahost ~]# mv mysql-5.7.29-el7-x86_64 /usr/local/mysql
[root@locahost ~]# mkdir /usr/local/mysql/data
3.初始化
3.创建mysql系统用户
[root@locahost ~]# useradd -r mysql
[root@locahost ~]# chown -R mysql:mysql /usr/local/mysql/
4.初始化MySql数据库
[root@locahost ~]# /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data &> /tmp/1.txt
mysql的SSL认证
[root@locahost ~]# /usr/local/mysql/bin/mysql_ssl_rsa_setup --datadir=/usr/local/mysql/data/
优化mysql工具路径
[root@locahost ~]# echo "PATH=$PATH:/usr/local/mysql/bin" >>/etc/profile
[root@localhost ~]# source /etc/profile
5.设置Mysql启动文件
[root@locahost ~]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@locahost ~]# vim /etc/init.d/mysqld
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
[root@localhost ~]# chkconfig --add mysqld
[root@localhost ~]# chkconfig mysqld on
4.创建配置文件
vim /etc/my.cnf
[client]
port = 3306
socket = /usr/local/mysql/mysql.sock
[mysqld]
user = mysql
server-id = 1
port = 3306
socket = /usr/local/mysql/mysql.sock
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
log_error = /var/log/mysqld.log
pid-file = /usr/local/mysql/data/localhost.localdomain.pid
[root@localhost ~]# systemctl daemon-reload
[root@localhost ~]# systemctl start mysqld
5、提取初始码
[root@localhost ~]# less /tmp/1.txt | grep Note | awk ‘{print $NF}’
l80P5eS6Zj=/
主从
1、配置主mysql数据库
vim /etc/my.cnf
在[mysqld]区域添加:
server-id=1
log-bin=/usr/local/mysql/data/master-bin
log-slave-updates=true
主服务器授权,允许从服务器复制日志,用户是"slave"
mysql -u root -p123.com
mysql> grant replication slave on *.* to 'slave'@'192.168.10.%' identified by '123.com';
#授权给名叫 slave 的用户允许该用户通过 192.168.10. 网段下的所有服务器进行登录。并且密码是123.com。该用户在所有的库所有表中拥有 replication(复制权限) slave(从服务器权限)
#mysql> FLUSH PRIVILEGES;
mysql> SHOW GRANTS FOR 'slave@192.168.10.%'
mysql> SHOW MASTER STATUS;
二、mysql从
1、安装mysql数据库
2.配置从mysql数据库
vim /etc/my.cnf
添加:
server-id=2
relay-log=relay-log-bin 中继日志
relay-log-index=slave-relay-bin.index 中继日志索引文件
syst注意:主—从的ID不能相同。
2-1 授权从服务器访问用户权限
mysql -u root -p123.com
mysql> change master to 变更主服务器
master_user='slave', 指定用户(该用户为主服务器授权用户)
master_host='192.168.10.19' 指定主服务器IP地址
master_password='123.com', 指定用户的密码
master_log_file='mysql-bin.000003', 指定主服务器当前使用的二进制文件
master_log_pos=120; 指定二进制文件的偏移量
//主mysql服务器IP地址,在主服务器上创建的slave用户,密码,以及slave节点号
mysql> start slave; //开启复制
mysql> stop slave; //关闭复制
mysql> show slave status\G //查看复制状态