1.如何允许登录远程的mysql server
GRANT ALL PRIVILEGES ON *.* TO 'hello'@'192.168.74.227'IDENTIFIED BY 'hello' WITH GRANT OPTION;
flush privileges;mysql> grant 权限1,权限2,…权限n on 数据库名称.表名称 to 用户名@用户地址 identified by ‘连接口令’;
权限1,权限2,…权限n代表select,insert,update,delete,create,drop,index,alter,grant,references,reload,shutdown,process,file等14个权限。
当权限1,权限2,…权限n被all privileges或者all代替，表示赋予用户全部权限。
当数据库名称.表名称被*.*代替，表示赋予用户操作服务器上所有数据库所有表的权限。
用户地址可以是localhost，也可以是ip地址、机器名字、域名。也可以用’%'表示从任何地址连接。
‘连接口令’不能为空，否则创建失败。
2.如何配置mysql的master&slave
准备工作，有两个linux主机
master:192.168.74.225 centos6.4 32位 mysql5.5
slave:192.168.74.227 centos6.4 32位 mysql5.5
master 的用户名是root，无密码
slave 的用户名是root，无密码
slave登录master进行同步的账号是rep
1.允许slave登录master
GRANT ALL PRIVILEGES ON *.* TO 'hello'@'192.168.74.227'IDENTIFIED BY 'hello' WITH GRANT OPTION;
flush privileges;
mysql> select host,user from user;
+----------------+-------+
| host | user |
+----------------+-------+
| 127.0.0.1 | root |
| 192.168.74.227 | hello |
| 192.168.74.227 | rep |
| ::1 | root |
| Master.Mysql | |
| Master.Mysql | root |
| localhost | |
| localhost | root |
+----------------+-------+
8 rows in set (0.00 sec)| 192.168.74.227 | hello |2.配置master的my.cnf
[mysqld]
#master configure
server-id = 1
log-bin=mysql-bin
binlog-do-db=master
binlog-ignore-db=mysql
#master configure
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sockmaser的id应该是1，说明log目录，同步的数据库，不允许同步的数据库
然后在Master上增加一个账号专门用于同步，如下：GRANT REPLICATION SLAVE ON *.* TO rep@192.168.74.227 IDENTIFIED BY 'hello';
如果想要在Slave上有权限执行"LOAD TABLE FROM MASTER" 或 "LOAD DATA FROM MASTER"语句的话，必须授予全局的 FILE 和 SELECT 权限：
GRANT FILE,SELECT,REPLICATION SLAVE ON *.* TO rep@192.168.74.227 IDENTIFIED BY 'hello';
接下来备份Master上的数据，首先执行如下SQL语句：
FLUSH TABLES WITH READ LOCK;
然后把同步的数据tar打包，然后scp到227那台机器上，解压，注意权限问题
整个步骤完成之后，执行
UNLOCK TABLES
3.配置slave
[mysqld]
#configure master-slave
server-id=2
#master-host=192.168.74.225
#master-user=rep
#master-password=hello
replicate-ignore-db=mysql
replicate-do-db=master
#configure master-slave同步的数据库是master，不允许同步的是mysql
启动slave的数据库登录然后执行
mysql -h192.168.74.225 -urep -phello
SHOW GRANTS;mysql> SHOW GRANTS;
+-------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for rep@192.168.74.227 |
+-------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT SELECT, FILE, REPLICATION SLAVE ON *.* TO 'rep'@'192.168.74.227' IDENTIFIED BY PASSWORD '*6B4F89A54E2D27ECD7E8DA05B4AB8FD9D1D8B119' |
+-------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)执行这个语句
告诉slave主数据库一些信息
CHANGE MASTER TO MASTER_HOST='192.168.74.225',MASTER_USER='rep',MASTER_PASSWORD='hello',MASTER_LOG_FILE='mysql-bin.000001',MASTER_LOG_POS=0;
mysql> SHOW SLAVE STATUS\G
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: 192.168.74.225
Master_User: rep
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000001
Read_Master_Log_Pos: 4
Relay_Log_File: mysqld-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: mysql-bin.000001
Slave_IO_Running: No
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 4
Relay_Log_Space: 107
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 0
1 row in set (0.00 sec)
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
mysql> SHOW SLAVE STATUS\G
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: 192.168.74.225
Master_User: rep
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000001
Read_Master_Log_Pos: 4
Relay_Log_File: mysqld-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: mysql-bin.000001
Slave_IO_Running: Connecting
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 4
Relay_Log_Space: 107
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 1045
Last_IO_Error: error connecting to master 'rep@192.168.74.225:3306' - retry-time: 60 retries: 86400
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 0
1 row in set (0.00 sec)这样应该就可以了
测试一下：
在master执行下面的语句：
mysql> use master;
Database changed
mysql> CREATE TABLE stu(id VARCHAR(10), name VARCHAR(20));
Query OK, 0 rows affected (0.01 sec)
mysql> insert into table stu(id,name) values(10,"xluren");
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table stu(id,name) values(10,"xluren")' at line 1
mysql> insert into stu(id,name) values(10,"xluren");
Query OK, 1 row affected (0.00 sec)在slave测试一下：
[root@Slave mysql]# mysql -h 127.0.0.1 -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.5.33 MySQL Community Server (GPL) by Remi
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| master |
| mysql |
| test |
| url |
+--------------------+
5 rows in set (0.00 sec)
mysql> use maser;
ERROR 1049 (42000): Unknown database 'maser'
mysql> use master;
Database changed
mysql> show tables;
+------------------+
| Tables_in_master |
+------------------+
| stu |
+------------------+
1 row in set (0.01 sec)
mysql> select * from stu;
+------+--------+
| id | name |
+------+--------+
| 10 | xluren |
+------+--------+
1 row in set (0.00 sec)
mysql> 整个的过程就是这样的
晚上再从新搭建一次，看看整个过程是否通顺。
再次测试了下，绝对的好用，添加一个slave的步骤是怎样的？
1.去master添加一条slave，
GRANT REPLICATION SLAVE ON *.* TO slave2@192.168.74.230 IDENTIFIED BY 'hello';
2.赋予各种权限
GRANT FILE,SELECT,REPLICATION SLAVE ON *.* TO slave2@192.168.74.230 IDENTIFIED BY 'hello';
3.锁定，禁止写
FLUSH TABLES WITH READ LOCK;
4.mysqldump 备份数据库
5.到230那台机器上，把数据库导进来
6.show master status;
mysql> show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000003 | 1563 | master | mysql |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)同步的file是mysql-bin.000003
7.配置slave2的my.cnf
[mysqld]
#configure master-slave
server-id=3
#master-host=192.168.74.225
#master-user=rep
#master-password=hello
replicate-ignore-db=mysql
replicate-do-db=master
##configure master-slave 8.测试链接情况
mysql -h 192.168.74.225 -u slave2 -phello
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 706
Server version: 5.5.33-log MySQL Community Server (GPL) by Remi
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.mysql> show grants;
+----------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for slave2@192.168.74.230 |
+----------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT SELECT, FILE, REPLICATION SLAVE ON *.* TO 'slave2'@'192.168.74.230' IDENTIFIED BY PASSWORD '*6B4F89A54E2D27ECD7E8DA05B4AB8FD9D1D8B119' |
+----------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)9.告诉slave2，同步的mysql server
mysql> CHANGE MASTER TO MASTER_HOST='192.168.74.225',MASTER_USER='slave2',MASTER_PASSWORD='hello',MASTER_LOG_FILE='mysql-bin.000003',MASTER_LOG_POS=0;
ERROR 1198 (HY000): This operation cannot be performed with a running slave; run STOP SLAVE first
mysql> stop Slave;
Query OK, 0 rows affected (0.04 sec)
mysql> CHANGE MASTER TO MASTER_HOST='192.168.74.225',MASTER_USER='slave2',MASTER_PASSWORD='hello',MASTER_LOG_FILE='mysql-bin.000003',MASTER_LOG_POS=0;
Query OK, 0 rows affected (0.01 sec)
mysql> SHOW SLAVE STATUS\G ;
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: 192.168.74.225
Master_User: slave2
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000003
Read_Master_Log_Pos: 4
Relay_Log_File: mysqld-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: mysql-bin.000003
Slave_IO_Running: No
Slave_SQL_Running: No
Replicate_Do_DB: master
Replicate_Ignore_DB: mysql
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 4
Relay_Log_Space: 107
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 1045
Last_IO_Error: error connecting to master 'slave3@192.168.74.225:3306' - retry-time: 60 retries: 86400
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 0
1 row in set (0.00 sec)
ERROR:
No query specified
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
mysql> SHOW SLAVE STATUS\G ;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.74.225
Master_User: slave2
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000003
Read_Master_Log_Pos: 1563
Relay_Log_File: mysqld-relay-bin.000002
Relay_Log_Pos: 1709
Relay_Master_Log_File: mysql-bin.000003
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: master
Replicate_Ignore_DB: mysql
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 1563
Relay_Log_Space: 1866
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1
1 row in set (0.00 sec)
ERROR:
No query specified10.master解锁
mysql> UNLOCK TABLES
-> ;
Query OK, 0 rows affected (0.00 sec)
Master端
mysql> use master;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> insert into stu(id,name) values(2015,"usa or google");
Query OK, 1 row affected (0.03 sec)
mysql> 12.slave1端验证
mysql> select * from stu;
+------+--------+
| id | name |
+------+--------+
| 10 | xluren |
| 100 | hello |
| 2013 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
+------+--------+
9 rows in set (0.00 sec)
mysql> select * from stu;
+------+---------------+
| id | name |
+------+---------------+
| 10 | xluren |
| 100 | hello |
| 2013 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2015 | usa or google |
+------+---------------+
11 rows in set (0.00 sec)
mysql> 13.slave2验证下
[root@Slave2 hello]# mysql -h 127.0.0.1 -uroot
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 5.5.33 MySQL Community Server (GPL) by Remi
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use master;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select * from stu;
+------+--------+
| id | name |
+------+--------+
| 10 | xluren |
| 100 | hello |
| 2013 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
+------+--------+
10 rows in set (0.01 sec)
mysql> select * from stu;
+------+---------------+
| id | name |
+------+---------------+
| 10 | xluren |
| 100 | hello |
| 2013 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2014 | lurenx |
| 2015 | usa or google |
+------+---------------+
18 rows in set (0.00 sec)
mysql> 简单的总结
1.chkconfig关闭主从服务器的iptables
2.chkconfig设置mysqld开机自动运行
3.配置/etc/my.cnf
4.在主服务器上
mysql> GRANT REPLICATION SLAVE ON *.* TO slave@192.168.74.236 IDENTIFIED BY 'hello';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT FILE,SELECT,REPLICATION SLAVE ON *.* TO slave@192.168.74.236 IDENTIFIED BY 'hello';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH TABLES WITH READ LOCK;
Query OK, 0 rows affected (0.00 sec)5.备份数据库信息，利用tar压缩，scp到从服务器上，利用tar解压，然后使用相同的用户名密码登录，完成数据的备份
6.在主服务器执行mysql> UNLOCK TABLES; 取消锁定，完成数据库的备份工作
7.重启主从服务器的数据库，然后执行
mysql> SHOW SLAVE STATUS\G
Empty set (0.00 sec)
mysql> SHOW MAster STATUS\G
*************************** 1. row ***************************
File: mysql-bin.000001
Position: 106
Binlog_Do_DB: webdb
Binlog_Ignore_DB: mysql
1 row in set (0.00 sec)8.在从服务器上执行
[root@Slave mysql]# mysql -h 127.0.0.1 -u root -phello
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.69 Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> CHANGE MASTER TO MASTER_HOST='192.168.74.235',MASTER_USER='slave',MASTER_PASSWORD='hello',MASTER_LOG_FILE='mysql-bin.000001';
Query OK, 0 rows affected (0.02 sec)
mysql> show SLAVE status;
+----------------+----------------+-------------+-------------+---------------+------------------+---------------------+-------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+-------------------------------+---------------+---------------+----------------+----------------+
| Slave_IO_State | Master_Host | Master_User | Master_Port | Connect_Retry | Master_Log_File | Read_Master_Log_Pos | Relay_Log_File | Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_Do_DB | Replicate_Ignore_DB | Replicate_Do_Table | Replicate_Ignore_Table | Replicate_Wild_Do_Table | Replicate_Wild_Ignore_Table | Last_Errno | Last_Error | Skip_Counter | Exec_Master_Log_Pos | Relay_Log_Space | Until_Condition | Until_Log_File | Until_Log_Pos | Master_SSL_Allowed | Master_SSL_CA_File | Master_SSL_CA_Path | Master_SSL_Cert | Master_SSL_Cipher | Master_SSL_Key | Seconds_Behind_Master | Master_SSL_Verify_Server_Cert | Last_IO_Errno | Last_IO_Error | Last_SQL_Errno | Last_SQL_Error |
+----------------+----------------+-------------+-------------+---------------+------------------+---------------------+-------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+-------------------------------+---------------+---------------+----------------+----------------+
| | 192.168.74.235 | slave | 3306 | 60 | mysql-bin.000001 | 4 | mysqld-relay-bin.000001 | 4 | mysql-bin.000001 | No | No | webdb | mysql | | | | | 0 | | 0 | 4 | 106 | None | | 0 | No | | | | | | NULL | No | 0 | | 0 | |
+----------------+----------------+-------------+-------------+---------------+------------------+---------------------+-------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+-------------------------------+---------------+---------------+----------------+----------------+
1 row in set (0.00 sec)
mysql> show SLAVE status\G;
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: 192.168.74.235
Master_User: slave
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000001
Read_Master_Log_Pos: 4
Relay_Log_File: mysqld-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: mysql-bin.000001
Slave_IO_Running: No
Slave_SQL_Running: No
Replicate_Do_DB: webdb
Replicate_Ignore_DB: mysql
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 4
Relay_Log_Space: 106
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
1 row in set (0.00 sec)
ERROR:
No query specified
mysql> START SLAVE;
Query OK, 0 rows affected (0.00 sec)
mysql> show SLAVE status\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.74.235
Master_User: slave
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000001
Read_Master_Log_Pos: 106
Relay_Log_File: mysqld-relay-bin.000002
Relay_Log_Pos: 251
Relay_Master_Log_File: mysql-bin.000001
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: webdb
Replicate_Ignore_DB: mysql
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 106
Relay_Log_Space: 407
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
1 row in set (0.00 sec)
ERROR:
No query specified经过几次的配置，越来越明确方法，也越来越快了。
1242
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
