当前位置:Gxlcms > 数据库问题 > MYSQL-5.7.20的安装和主从配置(rpm安装包)

MYSQL-5.7.20的安装和主从配置(rpm安装包)

时间:2021-07-01 10:21:17 帮助过:5人阅读

install lrzsz -y

  再在本地下载,再上传 https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.20-1.el7.x86_64.rpm-bundle.tar

二,安装

  安装的过程如果和mariadb包有冲突,如果要有先卸载

  1.   rpm -qa|<span style="color: #0000ff;">grep</span> mariadb

  查看已安装的mariadb包

  1.   rpm -e --nodeps mariadb-libs-<span style="color: #800080;">5.5</span>.<span style="color: #800080;">44</span>-<span style="color: #800080;">2</span><span style="color: #000000;">.el7.centos.x86_64
  2.   rpm </span>-e --nodeps mariadb-<span style="color: #800080;">5.5</span>.<span style="color: #800080;">44</span>-<span style="color: #800080;">2</span><span style="color: #000000;">.el7.centos.x86_64
  3.   rpm </span>-e --nodeps mariadb-devel-<span style="color: #800080;">5.5</span>.<span style="color: #800080;">44</span>-<span style="color: #800080;">2</span>.el7.centos.x86_64

  依次先后安装

  1.   rpm -ivh mysql/mysql-community-common-<span style="color: #800080;">5.7</span>.<span style="color: #800080;">20</span>-<span style="color: #800080;">1</span><span style="color: #000000;">.el7.x86_64.rpm
  2.   rpm </span>-ivh mysql/mysql-community-libs-<span style="color: #800080;">5.7</span>.<span style="color: #800080;">20</span>-<span style="color: #800080;">1</span><span style="color: #000000;">.el7.x86_64.rpm
  3.   rpm </span>-ivh mysql/mysql-community-client-<span style="color: #800080;">5.7</span>.<span style="color: #800080;">20</span>-<span style="color: #800080;">1</span><span style="color: #000000;">.el7.x86_64.rpm
  4.   rpm </span>-ivh mysql/mysql-community-server-<span style="color: #800080;">5.7</span>.<span style="color: #800080;">20</span>-<span style="color: #800080;">1</span>.el7.x86_64.rpm

三,配置/etc/my.cnf 文件 

  1. <span style="color: #000000;">[mysqld]
  2. character</span>-set-server=<span style="color: #000000;">utf8
  3. [mysql]
  4. default</span>-character-set =<span style="color: #000000;"> utf8
  5. [mysql.server]
  6. default</span>-character-set =<span style="color: #000000;"> utf8
  7. [mysqld_safe]
  8. default</span>-character-set =<span style="color: #000000;"> utf8
  9. [client]
  10. default</span>-character-set = utf8
  1. <code class="hljs"><span class="zh-hans">  查看修改后的效果<br></span></code>
  1. SHOW VARIABLES LIKE <span style="color: #800000;">‘</span><span style="color: #800000;">character%</span><span style="color: #800000;">‘</span>;

四,初始化mysql

  1. mysqld --initialize --user=<span style="color: #000000;">mysql
  2. 如有必要指定路径可以加上下面的参数
  3. </span>--basedir=/usr/local/mysql --datadir=/data/mysql<br><br><em>root 用户随机密码保留在/var/log/mysqld.log 文件中</em>

五,启动mysql

  1. <span style="color: #000000;">systemctl start mysqld (启动mysql)
  2. systemctl restart mysqld (重启mysql)
  3. systemctl status mysqld (查看状态)</span>

六,修改root 初始密码

  1. mysql -u root -p (使用刚才的随机密码)

  或者 使用下面命令初始化mysql,则不需要密码登录

  1. mysqld --initialize-insecure --user=<span style="color: #000000;">mysql
  2. mysql </span>-u root --skip-<span style="color: #000000;">password
  3. alter user </span><span style="color: #800000;">‘</span><span style="color: #800000;">root</span><span style="color: #800000;">‘</span>@<span style="color: #800000;">‘</span><span style="color: #800000;">localhost</span><span style="color: #800000;">‘</span> identified by <span style="color: #800000;">‘</span><span style="color: #800000;">pwd456</span><span style="color: #800000;">‘</span>;

  如果无法登录,再修改/etc/my.cnf 文件 加入以下参数

  1. skip-grant-tables

  再 systemctl restart mysqld (重启mysql) 就可以无密码登录了,修改密码

  1. update user set authentication_string=password(<span style="color: #800000;">"</span><span style="color: #800000;">pwd456</span><span style="color: #800000;">"</span>) where user=<span style="color: #800000;">"</span><span style="color: #800000;">root</span><span style="color: #800000;">"</span><span style="color: #000000;">;
  2. flush privileges;</span>

七,配置主从

  1,修改master /etc/my.cnf 文件

  1. log-bin=mysql-<span style="color: #000000;">bin
  2. server</span>-<span style="color: #0000ff;">id</span>=<span style="color: #800080;">1</span>
  3. --------<span style="color: #000000;">下面可以忽略
  4. binlog</span>-ignore-db=<span style="color: #000000;">information_schema
  5. binlog</span>-ignore-db=<span style="color: #000000;">mysql
  6. </span>----------------------- 

  2,登录master

  1. GRANT FILE ON *.* TO replicate@<span style="color: #800000;">‘</span><span style="color: #800000;">xx.xx.xx.xx</span><span style="color: #800000;">‘</span> IDENTIFIED BY <span style="color: #800000;">‘</span><span style="color: #800000;">pwd123</span><span style="color: #800000;">‘</span><span style="color: #000000;">;
  2. GRANT REPLICATION SLAVE,RELOAD,SUPER ON </span>*.* TO replicate@<span style="color: #800000;">‘</span><span style="color: #800000;">xx.xx.xx.xx</span><span style="color: #800000;">‘</span> IDENTIFIED BY <span style="color: #800000;">‘</span><span style="color: #800000;">pwd123</span><span style="color: #800000;">‘</span><span style="color: #000000;">;
  3. 查看状态
  4. SHOW MASTER STATUS \G;</span>

  3,修改slave的配置 /etc/my.cnf 文件

  1. log-bin=mysql-<span style="color: #000000;">bin (非必须项,当slave需要同步的时候才必须)
  2. server</span>-<span style="color: #0000ff;">id</span>=<span style="color: #800080;">2</span><span style="color: #000000;">
  3. log_slave_updates </span>= <span style="color: #800080;">1</span><span style="color: #000000;">
  4. read_only </span>= <span style="color: #800080;">1</span><span style="color: #000000;">
  5. slave</span>-skip-errors =<span style="color: #000000;"> all
  6. slave</span>-net-timeout = <span style="color: #800080;">60</span>
  7. --------<span style="color: #000000;">下面可以忽略
  8. binlog</span>-ignore-db=<span style="color: #000000;">information_schema
  9. binlog</span>-ignore-db=<span style="color: #000000;">cluster
  10. binlog</span>-ignore-db=<span style="color: #000000;">mysql
  11. replicate</span>-<span style="color: #0000ff;">do</span>-db=<span style="color: #000000;">ufind_db
  12. replicate</span>-ignore-db=mysql

  4,修改同步选项, 重启slave

  1. change master to master_host=<span style="color: #800000;">‘</span><span style="color: #800000;">xx.xx.xx.01</span><span style="color: #800000;">‘</span>,master_user=<span style="color: #800000;">‘</span><span style="color: #800000;">replicate</span><span style="color: #800000;">‘</span>,master_password=<span style="color: #800000;">‘</span><span style="color: #800000;">pwd123</span><span style="color: #800000;">‘</span>,master_log_file=<span style="color: #800000;">‘</span><span style="color: #800000;">mysql-bin.000001</span><span style="color: #800000;">‘</span>, master_log_pos=<span style="color: #800080;">760</span>;

  查看 slave 状态

  1. <span style="color: #000000;">START SLAVE;
  2. SHOW SLAVE STATUS \G;</span>

  可以看到

  1. <span style="color: #000000;">Slave_IO_Running: Yes
  2. Slave_SQL_Running: Yes</span>

 

 

参考

mysql的安装 参考 https://jingyan.baidu.com/article/93f9803f010d8fe0e56f555e.html

 

MYSQL-5.7.20的安装和主从配置(rpm安装包)

标签:unity   roo   local   variable   改密码   emc   alter   for   log   

人气教程排行