CentOS7 64位安装MySql教程Mysql主从配置安装说明

ゝ一世哀愁。 2023-07-12 14:23 6阅读 0赞

# **CentOS7 64位安装MySql教程** #

1.  先检查系统是否装有mysql

rpm -qa | grep mysql

1.   下载mysql的repo源

wget [http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm][http_repo.mysql.com_mysql-community-release-el7-5.noarch.rpm]

报错: -bash: wget: 未找到命令

安装插件  yum -y install wget

1.  安装mysql-community-release-el7-5.noarch.rpm包

sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm

1.  安装MySQL

sudo yum install mysql-server

1.  重置MySQL密码

mysql -u root

报错：

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

原因：原因是/var/lib/mysql的访问权限问题。

chown root /var/lib/mysql/

1.  重启MySQL服务

service mysqld restart

1.  接着登陆设置密码

mysql -u root

use mysql;

update user set password=password('123456') where user='root';

exit;

接着继续重启MySQL服务

service mysqld restart

1.  接着设置Root账户远程连接密码

mysql -u root -p

GRANT ALL PRIVILEGES ON \*.\* TO root@"%" IDENTIFIED BY "root";

重启服务器 service mysqld restart

1.  使用外网工具连接MySQL

关闭防火墙

systemctl stop firewalld.service

# **MySQL主从复制配置** #

## **主服务器节点 ** ##

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:414.8pt;"> vi /etc/my.cnf &nbsp;新增以下内容 ###服务器id server_id=1 ###开启日志文件 log-bin=mysql-bin &nbsp; </td> 
 </tr> 
 </tbody> 
</table>

重启mysql服务 service mysqld restart

验证是否已经配置成功

show variables like '%server\_id%';

能够查询对应配置文件中的server\_id 说明已经配置成功

show master status;

能够看到同步的文件，和行数 说明已经配置成功。

## **从服务器节点** ##

克隆服务器

<table style="margin-left:-.25pt;"> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:396.8pt;"> vi /etc/my.cnf ###从服务器server_id server_id=2&nbsp; ###日志文件同步方式 log-bin=mysql-bin ###同步数据库 binlog_do_db=test &nbsp;&nbsp; &nbsp; &nbsp; ###从服务器server_id server_id=3&nbsp; ###日志文件同步方式 log-bin=mysql-bin ###同步数据库 binlog_do_db=test &nbsp; </td> 
 </tr> 
 </tbody> 
</table>

重启mysql服务 service mysqld restart

验证是否已经配置成功

show variables like '%server\_id%';

能够查询对应配置文件中的server\_id 说明已经配置成功

从服务器同步主服务器配置

change master to master\_host='192.168.184.129',master\_user='root',master\_password='123456',

master\_log\_file='mysql-bin.000003',master\_log\_pos=216;开始同步

start slave

检查从服务器复制功能状态

SHOW SLAVE STATUS

Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work.

解决办法

因为服务器克隆的时候交UUID产生了重复 ，解决办法

Cat  /etc/my.cnf

cd /var/lib/mysql

rm -rf auto.cnf

重启服务器即可

service mysqld restart

Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from impossible position'

[http_repo.mysql.com_mysql-community-release-el7-5.noarch.rpm]: http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm