建设工程规划许可证在哪个网站查询,手机免费推广软件,怎么做网站监控平台,做网站前台用什么软件1#xff1a;设主库允许远程连接(注意#xff1a;设置账号密码必须使用的插件是mysql_native_password#xff0c;其他的会连接失败)
#切换到mysql这个数据库#xff0c;修改user表中的host#xff0c;使其可以实现远程连接
mysqluse mysql;
mysqlupdate user se…1设主库允许远程连接(注意设置账号密码必须使用的插件是mysql_native_password其他的会连接失败)
#切换到mysql这个数据库修改user表中的host使其可以实现远程连接
mysqluse mysql;
mysqlupdate user set host % where user root;
#改完之后一定要刷新信息
mysqlflush privileges;2主库开启bin-log日志在my.cnf的[mysqld]下添加
#修改主服务器Master
#修改配置文件
vim /etc/my.cnf
#主服务器唯一ID这个id可以随便修改只要不跟从服务器重复,注意连接是-,不是_
server-id1
#启用二进制日志
log-binmysql-bin2-1重启主库mysql
[rootlocalhost ~]# systemctl retart mysql2-2查看主库server 相关信息
mysql show global variables like %server%;
-----------------------------------------------------------------------
| Variable_name | Value |
-----------------------------------------------------------------------
| character_set_server | utf8mb4 |
| collation_server | utf8mb4_0900_ai_ci |
| innodb_dedicated_server | OFF |
| innodb_ft_server_stopword_table | |
| server_id | 1 |
| server_id_bits | 32 |
| server_uuid | b434ab49-df79-11ee-9c39-0242ac110002 |
-----------------------------------------------------------------------
7 rows in set (0.00 sec)mysql2-2查看主库是否开启bin-log日志
mysql show global variables like %log%;2-3查看主库的最新状态
mysql show master status;
-------------------------------------------------------------------------------
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
-------------------------------------------------------------------------------
| mysql-bin.000004 | 157 | | | |
-------------------------------------------------------------------------------
1 row in set (0.00 sec)mysql FLUSH LOGS;
Query OK, 0 rows affected (0.01 sec)mysql show master status;
-------------------------------------------------------------------------------
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
-------------------------------------------------------------------------------
| mysql-bin.000005 | 157 | | | |
-------------------------------------------------------------------------------
1 row in set (0.00 sec)mysql2-4查看全部的二进制文件可以选择一步一步恢复
mysql SHOW BINARY LOGS;
----------------------------------------
| Log_name | File_size | Encrypted |
----------------------------------------
| mysql-bin.000001 | 204 | No |
| mysql-bin.000002 | 204 | No |
| mysql-bin.000003 | 204 | No |
| mysql-bin.000004 | 204 | No |
| mysql-bin.000005 | 157 | No |
----------------------------------------
5 rows in set (0.00 sec)mysql
3从库开启bin-log日志在my.cnf的[mysqld]下添加
#修改从服务器slave
修改配置文件vim /etc/my.cnf
#从服务器唯一ID,注意连接是-,不是_
server-id2
#启用中继日志
relay-logmysql-relay3-1查看主库是否开启bin-log日志从库也是一样 4在主库创建一个账号slave密码123456并且授权连接
mysqlGRANT REPLICATION SLAVE ON *.* to slave% identified by 123456;4-1在从库指定主库(添加 主节点主机访问主节点的用户名及密码主节点二进制文件信息注意主节点的二进制文件一定要是二进制列表中的最后一个二进制文件。如果需要设置主主就是主库也执行如下的命令ip账号密码换成从库的)
mysql change master to master_host192.168.11.47,master_userroot,master_passwordroot,master_log_filemysql-bin.000005,master_log_pos157;
Query OK, 0 rows affected, 8 warnings (0.01 sec)4-2主主设置
mysql change master to master_host192.168.11.47,master_userroot,master_passwordroot,master_log_filemysql-bin.000005,master_auto_position1;
Query OK, 0 rows affected, 8 warnings (0.01 sec)## font colorred5检查从库复制功能状态注意Slave_IO_RunningSlave_SQL_Running两个线程必须为yes状态否则主从复制搭建不成功bash
show slave status \G;5-1先停止从库的复制功能
mysqlstop slave;5-2再启动从库的复制功能
mysqlstart slave;5-3再查看从库的状态
show slave status \G;
