https://www.cnblogs.com/phpstudy2015-6/p/6485819.html
mysql>START SLAVE ; #開啟復(fù)制
mysql 配置文件 server-id 必須不一樣
用戶可以登錄
mysql 遠程連接debian8中的mysql數(shù)據(jù)庫的硼一,報錯。
mysql -h IP -u root -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (111)
可能原因:
vi /etc/mysql/my.cnf
找到
[mysqld]
bind-address? ? ? ? ? ? = 127.0.0.1
注釋掉bind-address
重啟mysql
/etc/init.d/mysql restart
mysql2? 172.16.135.131
mysql? 172.16.135.132