CentOS服务器平台搭建mysql主从复制与读写分离的方法
<p>本文实例讲述了CentOS服务器搭建mysql主从复制与读写分离的方法。分享给大家供大家参考，具体如下：</p>
<p>
<strong>mysql 主从复制的优点:</strong></p>
<p>
① 如果主服务器出现问题， 可以快速切换到从服务器提供的服务，保证高可用性<br>
② 可以在从服务器上执行查询操作， 降低主服务器的访问压力<br>
③ 可以在从服务器上执行备份， 以避免备份期间影响主服务器的服务</p>
<p>
<strong>注意事项：</strong></p>
<p>
① server-id必须唯一，一般使用ip的后三位<br>
② 从库Slave_IO_Running:NO 可能原因:帐号无权限操作<br>
③ Can't execute the query because you have a conflicting read lock，解锁下即可 unlock tables;<br>
④ 一般只有更新不频繁的数据或者对实时性要求不高的数据可以通过从服务器查询， 实时性要求高的数据仍然需要从主数据库获得<br>
⑤ 修改完主从服务器的配置需要重启mysql：service mysqld restart</p>
<p>
主机A: 192.168.10.111<br>
从机B: 192.168.10.124</p>
<p>
请先分别安装mysql，版本需一致，装了即可跳过</p>
<p>
</p>
<div class="codetitle">
<span><u>复制代码</u></span> 代码如下:</div>
<div class="codebody" id="code7030">
yum install mysql mysql-server #输入y即可自动安装,直到安装完成</div>
<p>
</p>
<p>
<strong>1、先登录主机 A，在主服务器上，设置一个从数据库的账户，使用REPLICATION SLAVE（从复制）赋予权限</strong>，如：</p>
<div class="codetitle">
<span><u>复制代码</u></span> 代码如下:</div>
<div class="codebody" id="code98744">
mysql>GRANT REPLICATION SLAVE ON *.* TO 'backup'@'192.168.10.124' IDENTIFIED BY '123456'</div>
<p>
</p>
<p>
赋予从机权限，有多台从机，就执行多次。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_773720">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">mysql>flush </code><code class="sql keyword">privileges</code><code class="sql plain">;</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<strong>2、 打开主机A的my.cnf，输入如下：（修改主数据库的配置文件my.cnf，开启BINLOG，并设置server-id的值，修改之后必须重启mysql服务）</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_307746">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">server-</code><code class="bash functions">id</code> <code class="bash plain">= 1 </code><code class="bash comments">#主机标示，整数 </code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">log_bin = </code><code class="bash plain">/var/log/mysql/mysql-bin</code><code class="bash plain">.log </code><code class="bash comments">#确保此文件可写，开启bin-log </code>
</div>
<div class="line number3 index2 alt2">
<code class="bash functions">read</code><code class="bash plain">-only =0 </code><code class="bash comments">#主机，读写都可以 </code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">binlog-</code><code class="bash keyword">do</code><code class="bash plain">-</code><code class="bash functions">db</code> <code class="bash plain">=</code><code class="bash functions">test</code> <code class="bash comments">#需要备份数据，多个写多行 </code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">binlog-ignore-</code><code class="bash functions">db</code> <code class="bash plain">=mysql </code><code class="bash comments">#不需要备份的数据库，多个写多行 </code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
可以通过<code>mysql>show variables like 'log_%';</code> 验证二进制日志是否已经启动。 </p>
<p>
<strong>3、现在可以停止主数据的的更新操作，并生成主数据库的备份，我们可以通过mysqldump到处数据到从数据库，当然了，你也可以直接用cp命令将数据文件复制到从数据库去，注意在导出数据之前先对主数据库进行READ LOCK，以保证数据的一致性</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_828661">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">mysql> flush tables </code><code class="sql keyword">with</code> <code class="sql keyword">read</code> <code class="sql plain">lock;</code>
</div>
<div class="line number2 index1 alt1">
<code class="sql plain">Query OK, 0 </code><code class="sql keyword">rows</code> <code class="sql plain">affected (0.19 sec)</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
然后<code>mysqldump</code>导出数据：</p>
<div class="codetitle">
<span><u>复制代码</u></span> 代码如下:</div>
<div class="codebody" id="code76718">
mysqldump -h127.0.0.1 -p3306 -uroot -p test > /data/backup/test.sql</div>
<p>
</p>
<p>
<strong>4、得到主服务器当前二进制日志名和偏移量，这个操作的目的是为了在从数据库启动后，从这个点开始进行数据的恢复。</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_83283">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">mysql> show master status;</code>
</div>
<div class="line number2 index1 alt1">
<code class="sql plain">+</code><code class="sql comments">------------------+----------+--------------+------------------+</code>
</div>
<div class="line number3 index2 alt2">
<code class="sql plain">| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |</code>
</div>
<div class="line number4 index3 alt1">
<code class="sql plain">+</code><code class="sql comments">------------------+----------+--------------+------------------+</code>
</div>
<div class="line number5 index4 alt2">
<code class="sql plain">| mysql-bin.000007 | 517 | test | mysql |</code>
</div>
<div class="line number6 index5 alt1">
<code class="sql plain">+</code><code class="sql comments">------------------+----------+--------------+------------------+</code>
</div>
<div class="line number7 index6 alt2">
<code class="sql plain">1 row </code><code class="sql color1">in</code> <code class="sql keyword">set</code> <code class="sql plain">(0.00 sec)</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
最好在主数据库备份完毕，恢复写操作。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_147992">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">mysql> unlock tables;</code>
</div>
<div class="line number2 index1 alt1">
<code class="sql plain">Query OK, 0 </code><code class="sql keyword">rows</code> <code class="sql plain">affected (0.28 sec)</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<strong>5、将刚才主数据备份的test.sql复制到从数据库（navicat、phpmyadmin、命令行都可以），进行导入。</strong></p>
<p>
<strong>6、修改从数据库的my.cnf，增加server-id参数，指定复制使用的用户，主数据库服务器的ip，端口以及开始执行复制日志的文件和位置。打开从机B的my.cnf，输入（修改之后必须重启mysql服务）</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_437776">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">server-</code><code class="bash functions">id</code> <code class="bash plain">= 2 </code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">log_bin = </code><code class="bash plain">/var/log/mysql/mysql-bin</code><code class="bash plain">.log </code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">master-host =192.168.10.111 </code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">master-user =backup </code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">master-pass =123456 </code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain">master-port =3306 </code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">master-connect-retry=60 </code><code class="bash comments">#如果从服务器发现主服务器断掉，重新连接的时间差(秒) </code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain">replicate-</code><code class="bash keyword">do</code><code class="bash plain">-</code><code class="bash functions">db</code> <code class="bash plain">=</code><code class="bash functions">test</code> <code class="bash comments">#只复制某个库 </code>
</div>
<div class="line number9 index8 alt2">
<code class="bash plain">replicate-ignore-</code><code class="bash functions">db</code><code class="bash plain">=mysql </code><code class="bash comments">#不复制某个库 </code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<strong>7、在从服务器上,启动slave进程</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_781254">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">mysql> start slave;</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<strong>8、在从服务器进行show salve status验证</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_882673">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
<div class="line number12 index11 alt1">
12</div>
<div class="line number13 index12 alt2">
13</div>
<div class="line number14 index13 alt1">
14</div>
<div class="line number15 index14 alt2">
15</div>
<div class="line number16 index15 alt1">
16</div>
<div class="line number17 index16 alt2">
17</div>
<div class="line number18 index17 alt1">
18</div>
<div class="line number19 index18 alt2">
19</div>
<div class="line number20 index19 alt1">
20</div>
<div class="line number21 index20 alt2">
21</div>
<div class="line number22 index21 alt1">
22</div>
<div class="line number23 index22 alt2">
23</div>
<div class="line number24 index23 alt1">
24</div>
<div class="line number25 index24 alt2">
25</div>
<div class="line number26 index25 alt1">
26</div>
<div class="line number27 index26 alt2">
27</div>
<div class="line number28 index27 alt1">
28</div>
<div class="line number29 index28 alt2">
29</div>
<div class="line number30 index29 alt1">
30</div>
<div class="line number31 index30 alt2">
31</div>
<div class="line number32 index31 alt1">
32</div>
<div class="line number33 index32 alt2">
33</div>
<div class="line number34 index33 alt1">
34</div>
<div class="line number35 index34 alt2">
35</div>
<div class="line number36 index35 alt1">
36</div>
<div class="line number37 index36 alt2">
37</div>
<div class="line number38 index37 alt1">
38</div>
<div class="line number39 index38 alt2">
39</div>
<div class="line number40 index39 alt1">
40</div>
<div class="line number41 index40 alt2">
41</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">mysql> SHOW SLAVE STATUS\G </code>
</div>
<div class="line number2 index1 alt1">
<code class="sql plain">*************************** 1. row *************************** </code>
</div>
<div class="line number3 index2 alt2">
<code class="sql spaces"> </code><code class="sql plain">Slave_IO_State: Waiting </code><code class="sql keyword">for</code> <code class="sql plain">master </code><code class="sql keyword">to</code> <code class="sql plain">send event </code>
</div>
<div class="line number4 index3 alt1">
<code class="sql spaces"> </code><code class="sql plain">Master_Host: 192.168.10.111 </code>
</div>
<div class="line number5 index4 alt2">
<code class="sql spaces"> </code><code class="sql plain">Master_User: root </code>
</div>
<div class="line number6 index5 alt1">
<code class="sql spaces"> </code><code class="sql plain">Master_Port: 3306 </code>
</div>
<div class="line number7 index6 alt2">
<code class="sql spaces"> </code><code class="sql plain">Connect_Retry: 5 </code>
</div>
<div class="line number8 index7 alt1">
<code class="sql spaces"> </code><code class="sql plain">Master_Log_File: mysql-bin.000007 </code>
</div>
<div class="line number9 index8 alt2">
<code class="sql spaces"> </code><code class="sql plain">Read_Master_Log_Pos: 263 </code>
</div>
<div class="line number10 index9 alt1">
<code class="sql spaces"> </code><code class="sql plain">Relay_Log_File: mysqld-relay-bin.000002 </code>
</div>
<div class="line number11 index10 alt2">
<code class="sql spaces"> </code><code class="sql plain">Relay_Log_Pos: 408 </code>
</div>
<div class="line number12 index11 alt1">
<code class="sql spaces"> </code><code class="sql plain">Relay_Master_Log_File: mysql-bin.000007 </code>
</div>
<div class="line number13 index12 alt2">
<code class="sql spaces"> </code><code class="sql plain">Slave_IO_Running: Yes </code>
</div>
<div class="line number14 index13 alt1">
<code class="sql spaces"> </code><code class="sql plain">Slave_SQL_Running: Yes </code>
</div>
<div class="line number15 index14 alt2">
<code class="sql spaces"> </code><code class="sql plain">Replicate_Do_DB: test </code>
</div>
<div class="line number16 index15 alt1">
<code class="sql spaces"> </code><code class="sql plain">Replicate_Ignore_DB: mysql </code>
</div>
<div class="line number17 index16 alt2">
<code class="sql spaces"> </code><code class="sql plain">Replicate_Do_Table: </code>
</div>
<div class="line number18 index17 alt1">
<code class="sql spaces"> </code><code class="sql plain">Replicate_Ignore_Table: </code>
</div>
<div class="line number19 index18 alt2">
<code class="sql spaces"> </code><code class="sql plain">Replicate_Wild_Do_Table: </code>
</div>
<div class="line number20 index19 alt1">
<code class="sql spaces"> </code><code class="sql plain">Replicate_Wild_Ignore_Table: </code>
</div>
<div class="line number21 index20 alt2">
<code class="sql spaces"> </code><code class="sql plain">Last_Errno: 0 </code>
</div>
<div class="line number22 index21 alt1">
<code class="sql spaces"> </code><code class="sql plain">Last_Error: </code>
</div>
<div class="line number23 index22 alt2">
<code class="sql spaces"> </code><code class="sql plain">Skip_Counter: 0 </code>
</div>
<div class="line number24 index23 alt1">
<code class="sql spaces"> </code><code class="sql plain">Exec_Master_Log_Pos: 263 </code>
</div>
<div class="line number25 index24 alt2">
<code class="sql spaces"> </code><code class="sql plain">Relay_Log_Space: 564 </code>
</div>
<div class="line number26 index25 alt1">
<code class="sql spaces"> </code><code class="sql plain">Until_Condition: None </code>
</div>
<div class="line number27 index26 alt2">
<code class="sql spaces"> </code><code class="sql plain">Until_Log_File: </code>
</div>
<div class="line number28 index27 alt1">
<code class="sql spaces"> </code><code class="sql plain">Until_Log_Pos: 0 </code>
</div>
<div class="line number29 index28 alt2">
<code class="sql spaces"> </code><code class="sql plain">Master_SSL_Allowed: </code><code class="sql keyword">No</code>
</div>
<div class="line number30 index29 alt1">
<code class="sql spaces"> </code><code class="sql plain">Master_SSL_CA_File: </code>
</div>
<div class="line number31 index30 alt2">
<code class="sql spaces"> </code><code class="sql plain">Master_SSL_CA_Path: </code>
</div>
<div class="line number32 index31 alt1">
<code class="sql spaces"> </code><code class="sql plain">Master_SSL_Cert: </code>
</div>
<div class="line number33 index32 alt2">
<code class="sql spaces"> </code><code class="sql plain">Master_SSL_Cipher: </code>
</div>
<div class="line number34 index33 alt1">
<code class="sql spaces"> </code><code class="sql plain">Master_SSL_Key: </code>
</div>
<div class="line number35 index34 alt2">
<code class="sql spaces"> </code><code class="sql plain">Seconds_Behind_Master: 0 </code>
</div>
<div class="line number36 index35 alt1">
<code class="sql plain">Master_SSL_Verify_Server_Cert: </code><code class="sql keyword">No</code>
</div>
<div class="line number37 index36 alt2">
<code class="sql spaces"> </code><code class="sql plain">Last_IO_Errno: 0 </code>
</div>
<div class="line number38 index37 alt1">
<code class="sql spaces"> </code><code class="sql plain">Last_IO_Error: </code>
</div>
<div class="line number39 index38 alt2">
<code class="sql spaces"> </code><code class="sql plain">Last_SQL_Errno: 0 </code>
</div>
<div class="line number40 index39 alt1">
<code class="sql spaces"> </code><code class="sql plain">Last_SQL_Error: </code>
</div>
<div class="line number41 index40 alt2">
<code class="sql plain">1 row </code><code class="sql color1">in</code> <code class="sql keyword">set</code> <code class="sql plain">(0.00 sec) </code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<strong>提示</strong></p>
<p>
<span>Slave_IO_Running: Yes<br>
Slave_SQL_Running: Yes</span></p>
<p>
说明配置成功了</p>
<p>
<strong>9、测试主从服务器是否能同步</strong></p>
<p>
插入 修改 删除 增加字段 修改字段 增加表自己测试都可以</p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_425121">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
<div class="line number12 index11 alt1">
12</div>
<div class="line number13 index12 alt2">
13</div>
<div class="line number14 index13 alt1">
14</div>
<div class="line number15 index14 alt2">
15</div>
<div class="line number16 index15 alt1">
16</div>
<div class="line number17 index16 alt2">
17</div>
<div class="line number18 index17 alt1">
18</div>
<div class="line number19 index18 alt2">
19</div>
<div class="line number20 index19 alt1">
20</div>
<div class="line number21 index20 alt2">
21</div>
<div class="line number22 index21 alt1">
22</div>
<div class="line number23 index22 alt2">
23</div>
<div class="line number24 index23 alt1">
24</div>
<div class="line number25 index24 alt2">
25</div>
<div class="line number26 index25 alt1">
26</div>
<div class="line number27 index26 alt2">
27</div>
<div class="line number28 index27 alt1">
28</div>
<div class="line number29 index28 alt2">
29</div>
<div class="line number30 index29 alt1">
30</div>
<div class="line number31 index30 alt2">
31</div>
<div class="line number32 index31 alt1">
32</div>
<div class="line number33 index32 alt2">
33</div>
<div class="line number34 index33 alt1">
34</div>
<div class="line number35 index34 alt2">
35</div>
<div class="line number36 index35 alt1">
36</div>
<div class="line number37 index36 alt2">
37</div>
<div class="line number38 index37 alt1">
38</div>
<div class="line number39 index38 alt2">
39</div>
<div class="line number40 index39 alt1">
40</div>
<div class="line number41 index40 alt2">
41</div>
<div class="line number42 index41 alt1">
42</div>
<div class="line number43 index42 alt2">
43</div>
<div class="line number44 index43 alt1">
44</div>
<div class="line number45 index44 alt2">
45</div>
<div class="line number46 index45 alt1">
46</div>
<div class="line number47 index46 alt2">
47</div>
<div class="line number48 index47 alt1">
48</div>
<div class="line number49 index48 alt2">
49</div>
<div class="line number50 index49 alt1">
50</div>
<div class="line number51 index50 alt2">
51</div>
<div class="line number52 index51 alt1">
52</div>
<div class="line number53 index52 alt2">
53</div>
<div class="line number54 index53 alt1">
54</div>
<div class="line number55 index54 alt2">
55</div>
<div class="line number56 index55 alt1">
56</div>
<div class="line number57 index56 alt2">
57</div>
<div class="line number58 index57 alt1">
58</div>
<div class="line number59 index58 alt2">
59</div>
<div class="line number60 index59 alt1">
60</div>
<div class="line number61 index60 alt2">
61</div>
<div class="line number62 index61 alt1">
62</div>
<div class="line number63 index62 alt2">
63</div>
<div class="line number64 index63 alt1">
64</div>
<div class="line number65 index64 alt2">
65</div>
<div class="line number66 index65 alt1">
66</div>
<div class="line number67 index66 alt2">
67</div>
<div class="line number68 index67 alt1">
68</div>
<div class="line number69 index68 alt2">
69</div>
<div class="line number70 index69 alt1">
70</div>
<div class="line number71 index70 alt2">
71</div>
<div class="line number72 index71 alt1">
72</div>
<div class="line number73 index72 alt2">
73</div>
<div class="line number74 index73 alt1">
74</div>
<div class="line number75 index74 alt2">
75</div>
<div class="line number76 index75 alt1">
76</div>
<div class="line number77 index76 alt2">
77</div>
<div class="line number78 index77 alt1">
78</div>
<div class="line number79 index78 alt2">
79</div>
<div class="line number80 index79 alt1">
80</div>
<div class="line number81 index80 alt2">
81</div>
<div class="line number82 index81 alt1">
82</div>
<div class="line number83 index82 alt2">
83</div>
<div class="line number84 index83 alt1">
84</div>
<div class="line number85 index84 alt2">
85</div>
<div class="line number86 index85 alt1">
86</div>
<div class="line number87 index86 alt2">
87</div>
<div class="line number88 index87 alt1">
88</div>
<div class="line number89 index88 alt2">
89</div>
<div class="line number90 index89 alt1">
90</div>
<div class="line number91 index90 alt2">
91</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">$mysql -uroot -p123456 </code>
</div>
<div class="line number2 index1 alt1">
<code class="sql plain">mysql> </code><code class="sql keyword">create</code> <code class="sql keyword">database</code> <code class="sql plain">test; </code>
</div>
<div class="line number3 index2 alt2">
<code class="sql plain">mysql> </code><code class="sql keyword">create</code> <code class="sql keyword">table</code> <code class="sql color2">user</code><code class="sql plain">(id </code><code class="sql keyword">int</code><code class="sql plain">); </code>
</div>
<div class="line number4 index3 alt1">
<code class="sql plain">mysql> </code><code class="sql keyword">insert</code> <code class="sql keyword">into</code> <code class="sql color2">user</code> <code class="sql keyword">values</code><code class="sql plain">(1),(2),(3),(4),(5),(6); </code>
</div>
<div class="line number5 index4 alt2">
<code class="sql plain">Query OK, 2 </code><code class="sql keyword">rows</code> <code class="sql plain">affected (0.00 sec) </code>
</div>
<div class="line number6 index5 alt1">
<code class="sql plain">Records: 2 Duplicates: 0 Warnings: 0 </code>
</div>
<div class="line number7 index6 alt2">
<code class="sql plain">mysql> </code><code class="sql keyword">select</code> <code class="sql plain">* </code><code class="sql keyword">from</code> <code class="sql color2">user</code><code class="sql plain">; </code>
</div>
<div class="line number8 index7 alt1">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number9 index8 alt2">
<code class="sql plain">| id | </code>
</div>
<div class="line number10 index9 alt1">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number11 index10 alt2">
<code class="sql plain">| 1 | </code>
</div>
<div class="line number12 index11 alt1">
<code class="sql plain">| 2 | </code>
</div>
<div class="line number13 index12 alt2">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number14 index13 alt1">
<code class="sql plain">2rows </code><code class="sql color1">in</code> <code class="sql keyword">set</code> <code class="sql plain">(0.00 sec) </code>
</div>
<div class="line number15 index14 alt2">
<code class="sql plain">mysql> </code><code class="sql keyword">select</code> <code class="sql plain">* </code><code class="sql keyword">from</code> <code class="sql color2">user</code><code class="sql plain">; </code>
</div>
<div class="line number16 index15 alt1">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number17 index16 alt2">
<code class="sql plain">| id | </code>
</div>
<div class="line number18 index17 alt1">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number19 index18 alt2">
<code class="sql plain">| 1 | </code>
</div>
<div class="line number20 index19 alt1">
<code class="sql plain">| 2 | </code>
</div>
<div class="line number21 index20 alt2">
<code class="sql plain">| 3 | </code>
</div>
<div class="line number22 index21 alt1">
<code class="sql plain">| 4 | </code>
</div>
<div class="line number23 index22 alt2">
<code class="sql plain">| 5 | </code>
</div>
<div class="line number24 index23 alt1">
<code class="sql plain">| 6 | </code>
</div>
<div class="line number25 index24 alt2">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number26 index25 alt1">
<code class="sql plain">6 </code><code class="sql keyword">rows</code> <code class="sql color1">in</code> <code class="sql keyword">set</code> <code class="sql plain">(0.00 sec) </code>
</div>
<div class="line number27 index26 alt2">
<code class="sql plain">mysql> </code><code class="sql keyword">update</code> <code class="sql color2">user</code> <code class="sql keyword">set</code> <code class="sql plain">id=11 </code><code class="sql keyword">where</code> <code class="sql plain">id=1; </code>
</div>
<div class="line number28 index27 alt1">
<code class="sql plain">Query OK, 1 row affected (0.00 sec) </code>
</div>
<div class="line number29 index28 alt2">
<code class="sql keyword">Rows</code> <code class="sql plain">matched: 1 Changed: 1 Warnings: 0 </code>
</div>
<div class="line number30 index29 alt1">
<code class="sql plain">mysql> </code><code class="sql keyword">select</code> <code class="sql plain">* </code><code class="sql keyword">from</code> <code class="sql color2">user</code><code class="sql plain">; </code>
</div>
<div class="line number31 index30 alt2">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number32 index31 alt1">
<code class="sql plain">| id | </code>
</div>
<div class="line number33 index32 alt2">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number34 index33 alt1">
<code class="sql plain">| 11 | </code>
</div>
<div class="line number35 index34 alt2">
<code class="sql plain">| 2 | </code>
</div>
<div class="line number36 index35 alt1">
<code class="sql plain">| 3 | </code>
</div>
<div class="line number37 index36 alt2">
<code class="sql plain">| 4 | </code>
</div>
<div class="line number38 index37 alt1">
<code class="sql plain">| 5 | </code>
</div>
<div class="line number39 index38 alt2">
<code class="sql plain">| 6 | </code>
</div>
<div class="line number40 index39 alt1">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number41 index40 alt2">
<code class="sql plain">6 </code><code class="sql keyword">rows</code> <code class="sql color1">in</code> <code class="sql keyword">set</code> <code class="sql plain">(0.00 sec) </code>
</div>
<div class="line number42 index41 alt1">
<code class="sql plain">mysql> </code><code class="sql keyword">delete</code> <code class="sql keyword">from</code> <code class="sql color2">user</code> <code class="sql keyword">where</code> <code class="sql plain">id=2; </code>
</div>
<div class="line number43 index42 alt2">
<code class="sql plain">Query OK, 1 row affected (0.00 sec) </code>
</div>
<div class="line number44 index43 alt1">
<code class="sql plain">mysql> </code><code class="sql keyword">select</code> <code class="sql plain">* </code><code class="sql keyword">from</code> <code class="sql color2">user</code><code class="sql plain">; </code>
</div>
<div class="line number45 index44 alt2">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number46 index45 alt1">
<code class="sql plain">| id | </code>
</div>
<div class="line number47 index46 alt2">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number48 index47 alt1">
<code class="sql plain">| 11 | </code>
</div>
<div class="line number49 index48 alt2">
<code class="sql plain">| 3 | </code>
</div>
<div class="line number50 index49 alt1">
<code class="sql plain">| 4 | </code>
</div>
<div class="line number51 index50 alt2">
<code class="sql plain">| 5 | </code>
</div>
<div class="line number52 index51 alt1">
<code class="sql plain">| 6 | </code>
</div>
<div class="line number53 index52 alt2">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number54 index53 alt1">
<code class="sql plain">5 </code><code class="sql keyword">rows</code> <code class="sql color1">in</code> <code class="sql keyword">set</code> <code class="sql plain">(0.00 sec) </code>
</div>
<div class="line number55 index54 alt2">
<code class="sql plain">mysql> </code><code class="sql keyword">alter</code> <code class="sql keyword">table</code> <code class="sql color2">user</code> <code class="sql keyword">add</code> <code class="sql keyword">name</code> <code class="sql keyword">varchar</code><code class="sql plain">(50); </code>
</div>
<div class="line number56 index55 alt1">
<code class="sql plain">Query OK, 5 </code><code class="sql keyword">rows</code> <code class="sql plain">affected (0.01 sec) </code>
</div>
<div class="line number57 index56 alt2">
<code class="sql plain">Records: 5 Duplicates: 0 Warnings: 0 </code>
</div>
<div class="line number58 index57 alt1">
<code class="sql plain">mysql> </code><code class="sql keyword">select</code> <code class="sql plain">* </code><code class="sql keyword">from</code> <code class="sql color2">user</code><code class="sql plain">; </code>
</div>
<div class="line number59 index58 alt2">
<code class="sql plain">+</code><code class="sql comments">----+------+ </code>
</div>
<div class="line number60 index59 alt1">
<code class="sql plain">| id | </code><code class="sql keyword">name</code> <code class="sql plain">| </code>
</div>
<div class="line number61 index60 alt2">
<code class="sql plain">+</code><code class="sql comments">----+------+ </code>
</div>
<div class="line number62 index61 alt1">
<code class="sql plain">| 11 | </code><code class="sql color1">NULL</code> <code class="sql plain">| </code>
</div>
<div class="line number63 index62 alt2">
<code class="sql plain">| 3 | </code><code class="sql color1">NULL</code> <code class="sql plain">| </code>
</div>
<div class="line number64 index63 alt1">
<code class="sql plain">| 4 | </code><code class="sql color1">NULL</code> <code class="sql plain">| </code>
</div>
<div class="line number65 index64 alt2">
<code class="sql plain">| 5 | </code><code class="sql color1">NULL</code> <code class="sql plain">| </code>
</div>
<div class="line number66 index65 alt1">
<code class="sql plain">| 6 | </code><code class="sql color1">NULL</code> <code class="sql plain">| </code>
</div>
<div class="line number67 index66 alt2">
<code class="sql plain">+</code><code class="sql comments">----+------+ </code>
</div>
<div class="line number68 index67 alt1">
<code class="sql plain">5 </code><code class="sql keyword">rows</code> <code class="sql color1">in</code> <code class="sql keyword">set</code> <code class="sql plain">(0.00 sec) </code>
</div>
<div class="line number69 index68 alt2">
<code class="sql plain">mysql> </code><code class="sql keyword">ALTER</code> <code class="sql keyword">TABLE</code> <code class="sql color2">user</code> <code class="sql keyword">MODIFY</code> <code class="sql keyword">COLUMN</code> <code class="sql keyword">name</code> <code class="sql keyword">VARCHAR</code><code class="sql plain">(200); </code>
</div>
<div class="line number70 index69 alt1">
<code class="sql plain">Query OK, 5 </code><code class="sql keyword">rows</code> <code class="sql plain">affected (0.01 sec) </code>
</div>
<div class="line number71 index70 alt2">
<code class="sql plain">Records: 5 Duplicates: 0 Warnings: 0 </code>
</div>
<div class="line number72 index71 alt1">
<code class="sql plain">mysql> </code><code class="sql keyword">desc</code> <code class="sql color2">user</code><code class="sql plain">; </code>
</div>
<div class="line number73 index72 alt2">
<code class="sql plain">+</code><code class="sql comments">-------+--------------+------+-----+---------+-------+ </code>
</div>
<div class="line number74 index73 alt1">
<code class="sql plain">| Field | Type | </code><code class="sql color1">Null</code> <code class="sql plain">| </code><code class="sql keyword">Key</code> <code class="sql plain">| </code><code class="sql keyword">Default</code> <code class="sql plain">| Extra | </code>
</div>
<div class="line number75 index74 alt2">
<code class="sql plain">+</code><code class="sql comments">-------+--------------+------+-----+---------+-------+ </code>
</div>
<div class="line number76 index75 alt1">
<code class="sql plain">| id | </code><code class="sql keyword">int</code><code class="sql plain">(11) | </code><code class="sql keyword">NO</code> <code class="sql plain">| | </code><code class="sql color1">NULL</code> <code class="sql plain">| | </code>
</div>
<div class="line number77 index76 alt2">
<code class="sql plain">| </code><code class="sql keyword">name</code> <code class="sql plain">| </code><code class="sql keyword">varchar</code><code class="sql plain">(200) | YES | | </code><code class="sql color1">NULL</code> <code class="sql plain">| | </code>
</div>
<div class="line number78 index77 alt1">
<code class="sql plain">+</code><code class="sql comments">-------+--------------+------+-----+---------+-------+ </code>
</div>
<div class="line number79 index78 alt2">
<code class="sql plain">2 </code><code class="sql keyword">rows</code> <code class="sql color1">in</code> <code class="sql keyword">set</code> <code class="sql plain">(0.00 sec) </code>
</div>
<div class="line number80 index79 alt1">
<code class="sql plain">mysql> </code><code class="sql keyword">create</code> <code class="sql keyword">table</code> <code class="sql plain">user2(id </code><code class="sql keyword">int</code><code class="sql plain">); </code>
</div>
<div class="line number81 index80 alt2">
<code class="sql plain">Query OK, 0 </code><code class="sql keyword">rows</code> <code class="sql plain">affected (0.01 sec) </code>
</div>
<div class="line number82 index81 alt1">
<code class="sql plain">mysql> show tables; </code>
</div>
<div class="line number83 index82 alt2">
<code class="sql plain">+</code><code class="sql comments">----------------+ </code>
</div>
<div class="line number84 index83 alt1">
<code class="sql plain">| Tables_in_test | </code>
</div>
<div class="line number85 index84 alt2">
<code class="sql plain">+</code><code class="sql comments">----------------+ </code>
</div>
<div class="line number86 index85 alt1">
<code class="sql plain">| test | </code>
</div>
<div class="line number87 index86 alt2">
<code class="sql plain">| </code><code class="sql color2">user</code> <code class="sql plain">| </code>
</div>
<div class="line number88 index87 alt1">
<code class="sql plain">| user2 | </code>
</div>
<div class="line number89 index88 alt2">
<code class="sql plain">+</code><code class="sql comments">----------------+ </code>
</div>
<div class="line number90 index89 alt1">
<code class="sql plain">3 </code><code class="sql keyword">rows</code> <code class="sql color1">in</code> <code class="sql keyword">set</code> <code class="sql plain">(0.00 sec) </code>
</div>
<div class="line number91 index90 alt2">
<code class="sql plain">mysql> </code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
在从服务器查看是否同步过来 如果一致说明成功</p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_752355">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
<div class="line number12 index11 alt1">
12</div>
<div class="line number13 index12 alt2">
13</div>
<div class="line number14 index13 alt1">
14</div>
<div class="line number15 index14 alt2">
15</div>
<div class="line number16 index15 alt1">
16</div>
<div class="line number17 index16 alt2">
17</div>
<div class="line number18 index17 alt1">
18</div>
<div class="line number19 index18 alt2">
19</div>
<div class="line number20 index19 alt1">
20</div>
<div class="line number21 index20 alt2">
21</div>
<div class="line number22 index21 alt1">
22</div>
<div class="line number23 index22 alt2">
23</div>
<div class="line number24 index23 alt1">
24</div>
<div class="line number25 index24 alt2">
25</div>
<div class="line number26 index25 alt1">
26</div>
<div class="line number27 index26 alt2">
27</div>
<div class="line number28 index27 alt1">
28</div>
<div class="line number29 index28 alt2">
29</div>
<div class="line number30 index29 alt1">
30</div>
<div class="line number31 index30 alt2">
31</div>
<div class="line number32 index31 alt1">
32</div>
<div class="line number33 index32 alt2">
33</div>
<div class="line number34 index33 alt1">
34</div>
<div class="line number35 index34 alt2">
35</div>
<div class="line number36 index35 alt1">
36</div>
<div class="line number37 index36 alt2">
37</div>
<div class="line number38 index37 alt1">
38</div>
<div class="line number39 index38 alt2">
39</div>
<div class="line number40 index39 alt1">
40</div>
<div class="line number41 index40 alt2">
41</div>
<div class="line number42 index41 alt1">
42</div>
<div class="line number43 index42 alt2">
43</div>
<div class="line number44 index43 alt1">
44</div>
<div class="line number45 index44 alt2">
45</div>
<div class="line number46 index45 alt1">
46</div>
<div class="line number47 index46 alt2">
47</div>
<div class="line number48 index47 alt1">
48</div>
<div class="line number49 index48 alt2">
49</div>
<div class="line number50 index49 alt1">
50</div>
<div class="line number51 index50 alt2">
51</div>
<div class="line number52 index51 alt1">
52</div>
<div class="line number53 index52 alt2">
53</div>
<div class="line number54 index53 alt1">
54</div>
<div class="line number55 index54 alt2">
55</div>
<div class="line number56 index55 alt1">
56</div>
<div class="line number57 index56 alt2">
57</div>
<div class="line number58 index57 alt1">
58</div>
<div class="line number59 index58 alt2">
59</div>
<div class="line number60 index59 alt1">
60</div>
<div class="line number61 index60 alt2">
61</div>
<div class="line number62 index61 alt1">
62</div>
<div class="line number63 index62 alt2">
63</div>
<div class="line number64 index63 alt1">
64</div>
<div class="line number65 index64 alt2">
65</div>
<div class="line number66 index65 alt1">
66</div>
<div class="line number67 index66 alt2">
67</div>
<div class="line number68 index67 alt1">
68</div>
<div class="line number69 index68 alt2">
69</div>
<div class="line number70 index69 alt1">
70</div>
<div class="line number71 index70 alt2">
71</div>
<div class="line number72 index71 alt1">
72</div>
<div class="line number73 index72 alt2">
73</div>
<div class="line number74 index73 alt1">
74</div>
<div class="line number75 index74 alt2">
75</div>
<div class="line number76 index75 alt1">
76</div>
<div class="line number77 index76 alt2">
77</div>
<div class="line number78 index77 alt1">
78</div>
<div class="line number79 index78 alt2">
79</div>
<div class="line number80 index79 alt1">
80</div>
<div class="line number81 index80 alt2">
81</div>
<div class="line number82 index81 alt1">
82</div>
<div class="line number83 index82 alt2">
83</div>
<div class="line number84 index83 alt1">
84</div>
<div class="line number85 index84 alt2">
85</div>
<div class="line number86 index85 alt1">
86</div>
<div class="line number87 index86 alt2">
87</div>
<div class="line number88 index87 alt1">
88</div>
<div class="line number89 index88 alt2">
89</div>
<div class="line number90 index89 alt1">
90</div>
<div class="line number91 index90 alt2">
91</div>
<div class="line number92 index91 alt1">
92</div>
<div class="line number93 index92 alt2">
93</div>
<div class="line number94 index93 alt1">
94</div>
<div class="line number95 index94 alt2">
95</div>
<div class="line number96 index95 alt1">
96</div>
<div class="line number97 index96 alt2">
97</div>
<div class="line number98 index97 alt1">
98</div>
<div class="line number99 index98 alt2">
99</div>
<div class="line number100 index99 alt1">
100</div>
<div class="line number101 index100 alt2">
101</div>
<div class="line number102 index101 alt1">
102</div>
<div class="line number103 index102 alt2">
103</div>
<div class="line number104 index103 alt1">
104</div>
<div class="line number105 index104 alt2">
105</div>
<div class="line number106 index105 alt1">
106</div>
<div class="line number107 index106 alt2">
107</div>
<div class="line number108 index107 alt1">
108</div>
<div class="line number109 index108 alt2">
109</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">mysql> use test; </code>
</div>
<div class="line number2 index1 alt1">
<code class="sql keyword">Database</code> <code class="sql plain">changed </code>
</div>
<div class="line number3 index2 alt2">
<code class="sql plain">mysql> </code><code class="sql keyword">select</code> <code class="sql plain">* </code><code class="sql keyword">from</code> <code class="sql color2">user</code><code class="sql plain">; </code>
</div>
<div class="line number4 index3 alt1">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number5 index4 alt2">
<code class="sql plain">| id | </code>
</div>
<div class="line number6 index5 alt1">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number7 index6 alt2">
<code class="sql plain">| 1 | </code>
</div>
<div class="line number8 index7 alt1">
<code class="sql plain">| 2 | </code>
</div>
<div class="line number9 index8 alt2">
<code class="sql plain">| 3 | </code>
</div>
<div class="line number10 index9 alt1">
<code class="sql plain">| 4 | </code>
</div>
<div class="line number11 index10 alt2">
<code class="sql plain">| 5 | </code>
</div>
<div class="line number12 index11 alt1">
<code class="sql plain">| 6 | </code>
</div>
<div class="line number13 index12 alt2">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number14 index13 alt1">
<code class="sql plain">2 </code><code class="sql keyword">rows</code> <code class="sql color1">in</code> <code class="sql keyword">set</code> <code class="sql plain">(0.00 sec) </code>
</div>
<div class="line number15 index14 alt2">
<code class="sql plain">mysql> </code><code class="sql keyword">select</code> <code class="sql plain">* </code><code class="sql keyword">from</code> <code class="sql color2">user</code><code class="sql plain">; </code>
</div>
<div class="line number16 index15 alt1">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number17 index16 alt2">
<code class="sql plain">| id | </code>
</div>
<div class="line number18 index17 alt1">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number19 index18 alt2">
<code class="sql plain">| 1 | </code>
</div>
<div class="line number20 index19 alt1">
<code class="sql plain">| 2 | </code>
</div>
<div class="line number21 index20 alt2">
<code class="sql plain">| 3 | </code>
</div>
<div class="line number22 index21 alt1">
<code class="sql plain">| 4 | </code>
</div>
<div class="line number23 index22 alt2">
<code class="sql plain">| 5 | </code>
</div>
<div class="line number24 index23 alt1">
<code class="sql plain">| 6 | </code>
</div>
<div class="line number25 index24 alt2">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number26 index25 alt1">
<code class="sql plain">6 </code><code class="sql keyword">rows</code> <code class="sql color1">in</code> <code class="sql keyword">set</code> <code class="sql plain">(0.00 sec) </code>
</div>
<div class="line number27 index26 alt2">
<code class="sql plain">mysql> </code><code class="sql keyword">select</code> <code class="sql plain">* </code><code class="sql keyword">from</code> <code class="sql color2">user</code><code class="sql plain">; </code>
</div>
<div class="line number28 index27 alt1">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number29 index28 alt2">
<code class="sql plain">| id | </code>
</div>
<div class="line number30 index29 alt1">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number31 index30 alt2">
<code class="sql plain">| 11 | </code>
</div>
<div class="line number32 index31 alt1">
<code class="sql plain">| 2 | </code>
</div>
<div class="line number33 index32 alt2">
<code class="sql plain">| 3 | </code>
</div>
<div class="line number34 index33 alt1">
<code class="sql plain">| 4 | </code>
</div>
<div class="line number35 index34 alt2">
<code class="sql plain">| 5 | </code>
</div>
<div class="line number36 index35 alt1">
<code class="sql plain">| 6 | </code>
</div>
<div class="line number37 index36 alt2">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number38 index37 alt1">
<code class="sql plain">6 </code><code class="sql keyword">rows</code> <code class="sql color1">in</code> <code class="sql keyword">set</code> <code class="sql plain">(0.00 sec) </code>
</div>
<div class="line number39 index38 alt2">
<code class="sql plain">mysql> </code><code class="sql keyword">select</code> <code class="sql plain">* </code><code class="sql keyword">from</code> <code class="sql color2">user</code><code class="sql plain">; </code>
</div>
<div class="line number40 index39 alt1">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number41 index40 alt2">
<code class="sql plain">| id | </code>
</div>
<div class="line number42 index41 alt1">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number43 index42 alt2">
<code class="sql plain">| 11 | </code>
</div>
<div class="line number44 index43 alt1">
<code class="sql plain">| 3 | </code>
</div>
<div class="line number45 index44 alt2">
<code class="sql plain">| 4 | </code>
</div>
<div class="line number46 index45 alt1">
<code class="sql plain">| 5 | </code>
</div>
<div class="line number47 index46 alt2">
<code class="sql plain">| 6 | </code>
</div>
<div class="line number48 index47 alt1">
<code class="sql plain">+</code><code class="sql comments">----+ </code>
</div>
<div class="line number49 index48 alt2">
<code class="sql plain">5 </code><code class="sql keyword">rows</code> <code class="sql color1">in</code> <code class="sql keyword">set</code> <code class="sql plain">(0.00 sec) </code>
</div>
<div class="line number50 index49 alt1">
<code class="sql plain">mysql> </code><code class="sql keyword">select</code> <code class="sql plain">* </code><code class="sql keyword">from</code> <code class="sql color2">user</code><code class="sql plain">; </code>
</div>
<div class="line number51 index50 alt2">
<code class="sql plain">+</code><code class="sql comments">----+------+ </code>
</div>
<div class="line number52 index51 alt1">
<code class="sql plain">| id | </code><code class="sql keyword">name</code> <code class="sql plain">| </code>
</div>
<div class="line number53 index52 alt2">
<code class="sql plain">+</code><code class="sql comments">----+------+ </code>
</div>
<div class="line number54 index53 alt1">
<code class="sql plain">| 11 | </code><code class="sql color1">NULL</code> <code class="sql plain">| </code>
</div>
<div class="line number55 index54 alt2">
<code class="sql plain">| 3 | </code><code class="sql color1">NULL</code> <code class="sql plain">| </code>
</div>
<div class="line number56 index55 alt1">
<code class="sql plain">| 4 | </code><code class="sql color1">NULL</code> <code class="sql plain">| </code>
</div>
<div class="line number57 index56 alt2">
<code class="sql plain">| 5 | </code><code class="sql color1">NULL</code> <code class="sql plain">| </code>
</div>
<div class="line number58 index57 alt1">
<code class="sql plain">| 6 | </code><code class="sql color1">NULL</code> <code class="sql plain">| </code>
</div>
<div class="line number59 index58 alt2">
<code class="sql plain">+</code><code class="sql comments">----+------+ </code>
</div>
<div class="line number60 index59 alt1">
<code class="sql plain">5 </code><code class="sql keyword">rows</code> <code class="sql color1">in</code> <code class="sql keyword">set</code> <code class="sql plain">(0.00 sec) </code>
</div>
<div class="line number61 index60 alt2">
<code class="sql plain">mysql> </code><code class="sql keyword">desc</code> <code class="sql color2">user</code><code class="sql plain">; </code>
</div>
<div class="line number62 index61 alt1">
<code class="sql plain">+</code><code class="sql comments">-------+--------------+------+-----+---------+-------+ </code>
</div>
<div class="line number63 index62 alt2">
<code class="sql plain">| Field | Type | </code><code class="sql color1">Null</code> <code class="sql plain">| </code><code class="sql keyword">Key</code> <code class="sql plain">| </code><code class="sql keyword">Default</code> <code class="sql plain">| Extra | </code>
</div>
<div class="line number64 index63 alt1">
<code class="sql plain">+</code><code class="sql comments">-------+--------------+------+-----+---------+-------+ </code>
</div>
<div class="line number65 index64 alt2">
<code class="sql plain">| id | </code><code class="sql keyword">int</code><code class="sql plain">(11) | </code><code class="sql keyword">NO</code> <code class="sql plain">| | </code><code class="sql color1">NULL</code> <code class="sql plain">| | </code>
</div>
<div class="line number66 index65 alt1">
<code class="sql plain">| </code><code class="sql keyword">name</code> <code class="sql plain">| </code><code class="sql keyword">varchar</code><code class="sql plain">(200) | YES | | </code><code class="sql color1">NULL</code> <code class="sql plain">| | </code>
</div>
<div class="line number67 index66 alt2">
<code class="sql plain">+</code><code class="sql comments">-------+--------------+------+-----+---------+-------+ </code>
</div>
<div class="line number68 index67 alt1">
<code class="sql plain">2 </code><code class="sql keyword">rows</code> <code class="sql color1">in</code> <code class="sql keyword">set</code> <code class="sql plain">(0.00 sec) </code>
</div>
<div class="line number69 index68 alt2">
<code class="sql plain">mysql> show tables; </code>
</div>
<div class="line number70 index69 alt1">
<code class="sql plain">+</code><code class="sql comments">----------------+ </code>
</div>
<div class="line number71 index70 alt2">
<code class="sql plain">| Tables_in_test | </code>
</div>
<div class="line number72 index71 alt1">
<code class="sql plain">+</code><code class="sql comments">----------------+ </code>
</div>
<div class="line number73 index72 alt2">
<code class="sql plain">| test | </code>
</div>
<div class="line number74 index73 alt1">
<code class="sql plain">| </code><code class="sql color2">user</code> <code class="sql plain">| </code>
</div>
<div class="line number75 index74 alt2">
<code class="sql plain">| user2 | </code>
</div>
<div class="line number76 index75 alt1">
<code class="sql plain">+</code><code class="sql comments">----------------+ </code>
</div>
<div class="line number77 index76 alt2">
<code class="sql plain">3 </code><code class="sql keyword">rows</code> <code class="sql color1">in</code> <code class="sql keyword">set</code> <code class="sql plain">(0.00 sec) </code>
</div>
<div class="line number78 index77 alt1">
<code class="sql plain">mysql> </code>
</div>
<div class="line number79 index78 alt2">
<code class="sql plain">mysql binlog日志查看： </code>
</div>
<div class="line number80 index79 alt1">
<code class="sql plain">show binlog events\G; </code>
</div>
<div class="line number81 index80 alt2">
<code class="sql plain">*************************** 12. row *************************** </code>
</div>
<div class="line number82 index81 alt1">
<code class="sql spaces"> </code><code class="sql plain">Log_name: mysql-bin.000007 </code>
</div>
<div class="line number83 index82 alt2">
<code class="sql spaces"> </code><code class="sql plain">Pos: 985 </code>
</div>
<div class="line number84 index83 alt1">
<code class="sql spaces"> </code><code class="sql plain">Event_type: Query </code>
</div>
<div class="line number85 index84 alt2">
<code class="sql spaces"> </code><code class="sql plain">Server_id: 1 </code>
</div>
<div class="line number86 index85 alt1">
<code class="sql plain">End_log_pos: 1075 </code>
</div>
<div class="line number87 index86 alt2">
<code class="sql spaces"> </code><code class="sql plain">Info: use `test`; </code><code class="sql keyword">delete</code> <code class="sql keyword">from</code> <code class="sql color2">user</code> <code class="sql keyword">where</code> <code class="sql plain">id=2 </code>
</div>
<div class="line number88 index87 alt1">
<code class="sql plain">*************************** 13. row *************************** </code>
</div>
<div class="line number89 index88 alt2">
<code class="sql spaces"> </code><code class="sql plain">Log_name: mysql-bin.000007 </code>
</div>
<div class="line number90 index89 alt1">
<code class="sql spaces"> </code><code class="sql plain">Pos: 1075 </code>
</div>
<div class="line number91 index90 alt2">
<code class="sql spaces"> </code><code class="sql plain">Event_type: Query </code>
</div>
<div class="line number92 index91 alt1">
<code class="sql spaces"> </code><code class="sql plain">Server_id: 1 </code>
</div>
<div class="line number93 index92 alt2">
<code class="sql plain">End_log_pos: 1175 </code>
</div>
<div class="line number94 index93 alt1">
<code class="sql spaces"> </code><code class="sql plain">Info: use `test`; </code><code class="sql keyword">alter</code> <code class="sql keyword">table</code> <code class="sql color2">user</code> <code class="sql keyword">add</code> <code class="sql keyword">name</code> <code class="sql keyword">varchar</code><code class="sql plain">(50) </code>
</div>
<div class="line number95 index94 alt2">
<code class="sql plain">*************************** 14. row *************************** </code>
</div>
<div class="line number96 index95 alt1">
<code class="sql spaces"> </code><code class="sql plain">Log_name: mysql-bin.000007 </code>
</div>
<div class="line number97 index96 alt2">
<code class="sql spaces"> </code><code class="sql plain">Pos: 1175 </code>
</div>
<div class="line number98 index97 alt1">
<code class="sql spaces"> </code><code class="sql plain">Event_type: Query </code>
</div>
<div class="line number99 index98 alt2">
<code class="sql spaces"> </code><code class="sql plain">Server_id: 1 </code>
</div>
<div class="line number100 index99 alt1">
<code class="sql plain">End_log_pos: 1287 </code>
</div>
<div class="line number101 index100 alt2">
<code class="sql spaces"> </code><code class="sql plain">Info: use `test`; </code><code class="sql keyword">ALTER</code> <code class="sql keyword">TABLE</code> <code class="sql color2">user</code> <code class="sql keyword">MODIFY</code> <code class="sql keyword">COLUMN</code> <code class="sql keyword">name</code> <code class="sql keyword">VARCHAR</code><code class="sql plain">(200) </code>
</div>
<div class="line number102 index101 alt1">
<code class="sql plain">*************************** 15. row *************************** </code>
</div>
<div class="line number103 index102 alt2">
<code class="sql spaces"> </code><code class="sql plain">Log_name: mysql-bin.000007 </code>
</div>
<div class="line number104 index103 alt1">
<code class="sql spaces"> </code><code class="sql plain">Pos: 1287 </code>
</div>
<div class="line number105 index104 alt2">
<code class="sql spaces"> </code><code class="sql plain">Event_type: Query </code>
</div>
<div class="line number106 index105 alt1">
<code class="sql spaces"> </code><code class="sql plain">Server_id: 1 </code>
</div>
<div class="line number107 index106 alt2">
<code class="sql plain">End_log_pos: 1376 </code>
</div>
<div class="line number108 index107 alt1">
<code class="sql spaces"> </code><code class="sql plain">Info: use `test`; </code><code class="sql keyword">create</code> <code class="sql keyword">table</code> <code class="sql plain">user2(id </code><code class="sql keyword">int</code><code class="sql plain">) </code>
</div>
<div class="line number109 index108 alt2">
<code class="sql plain">15 </code><code class="sql keyword">rows</code> <code class="sql color1">in</code> <code class="sql keyword">set</code> <code class="sql plain">(0.00 sec) </code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
很早的时候搭建的了，走不少弯路，根据当时记录的写了下</p>
<p>
希望本文所述对大家CentOS服务器设置有所帮助。</p>
<p>
原文链接：https://blog.csdn.net/nuli888/article/details/51866388</p>
頁:
[1]