mysql主从同步配置.docx主host:.:.#下载mysqlwgethttp://dev./get/Downloads/MySQL---linux-i686-:/// #安装mysqltarxzfmysql--linux-i686---linux-i686-glibc23/usr/local/mysqlchown--Rmysqldatacpsupport-files/my-f/etc/fbin/mysqld_safe--user=mysql&cpsupport-files//=$PATH:/usr/local/mysql/bin/#加入环境变量分别更改主从root密码#mysqlmysql>=password('123456')whereuser="root"andhost="localhost";lprivileges on*.*******@'123456'; #>flushprivileges; #刷新权限表mysql>exit;在从服务器测试www1#mysql-uroot--pBLESWITHREADLOCK; (主库加锁)记录日志和偏移量mysql>showmasterstatus;mysqldump-p--all-database--lock-all-tables>db.******@:/root/.######### f############server-id=2master-host=-user=slavemaster-password=123456master-port=3306log-bin=mysql-bin-----------------------------------重启mysqllsof-i:3306|xargskill-9/usr/local/mysql/bin/mysqld
mysql主从同步配置 来自淘豆网www.taodocs.com转载请标明出处.