大侠好,小弟MySQL Replication,
master主机为 192.168.29.11,
Slave机为 192.168.29.22
对于slave机的ip地址
[root@localhost etc]# ifconfig
eth0 Link encap:Ethernet HWaddr 00:0C:29:7A:2E:50
inet addr:192.168.29.133 Bcast:192.168.29.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fe7a:2e50/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:10142 errors:0 dropped:0 overruns:0 frame:0
TX packets:8992 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:1015522 (991.7 KiB) TX bytes:1193399 (1.1 MiB)
Interrupt:67 Base address:0x2000 eth0:0 Link encap:Ethernet HWaddr 00:0C:29:7A:2E:50
inet addr:192.168.29.22 Bcast:192.168.29.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
Interrupt:67 Base address:0x2000 lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:1832 errors:0 dropped:0 overruns:0 frame:0
TX packets:1832 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:4048561 (3.8 MiB) TX bytes:4048561 (3.8 MiB)用slave连接master出错:
[root@localhost etc]# mysql -h 192.168.29.11 -uccc -pccc
ERROR 1130 (HY000): Host '192.168.29.133' is not allowed to connect to this MySQL server
master主机为 192.168.29.11,
Slave机为 192.168.29.22
对于slave机的ip地址
[root@localhost etc]# ifconfig
eth0 Link encap:Ethernet HWaddr 00:0C:29:7A:2E:50
inet addr:192.168.29.133 Bcast:192.168.29.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fe7a:2e50/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:10142 errors:0 dropped:0 overruns:0 frame:0
TX packets:8992 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:1015522 (991.7 KiB) TX bytes:1193399 (1.1 MiB)
Interrupt:67 Base address:0x2000 eth0:0 Link encap:Ethernet HWaddr 00:0C:29:7A:2E:50
inet addr:192.168.29.22 Bcast:192.168.29.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
Interrupt:67 Base address:0x2000 lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:1832 errors:0 dropped:0 overruns:0 frame:0
TX packets:1832 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:4048561 (3.8 MiB) TX bytes:4048561 (3.8 MiB)用slave连接master出错:
[root@localhost etc]# mysql -h 192.168.29.11 -uccc -pccc
ERROR 1130 (HY000): Host '192.168.29.133' is not allowed to connect to this MySQL server
解决方案 »
- SQL语句写法:让某字段相同的条目只显示一条
- mysql6数据同步用触发器可行吗
- 怎么在事務的表連接中只鎖定其中一張表
- mysql的显示问题
- Mysql问题:Connection refused: connect
- 'mysql' 不是内部或外部命令,也不是可运行的程序?怎么办?
- 关于mysql用户登陆的入门问题
- 输了半天密码,都进不去,结果没输密码却进去了,咋回事
- 创建表的时候里面有一个字段的类型是LongBlob请问插入sql语句应该如何写
- 如何在树形结构找到某个节点的根节点
- 关于 ado 的 recordsetPtr 使用
- xampp 用phpmyadmin在页面上修改密码后,无法登陆,密码没问题
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
#peizhitongbu
master-host=192.168.29.11
master-user=ccc
master-password=ccc
master-port=3306
server-id=2
master-connect-retry=60
replicate-do-db=c
log-slave-updatesbind-address=0.0.0.0eth0:0 什么意思呀?谢谢!
看看用户是否正确,授权是否正确。或者直接:
grant all on *.* to 'ccc'@'%' inentified by 'ccc';
ERROR 1130 (HY000): Host '192.168.29.133' is not allowed to connect to this MySQL server这个说的很明显啊,29.133这个机器不被允许连接。