{"id":1542,"date":"2016-12-15T21:38:13","date_gmt":"2016-12-15T13:38:13","guid":{"rendered":"http:\/\/cn.hostease.com\/xueyuan\/?p=1542"},"modified":"2025-01-06T19:46:35","modified_gmt":"2025-01-06T11:46:35","slug":"mysql%e6%97%a5%e5%bf%97%e5%ae%a1%e8%ae%a1-%e5%b8%ae%e4%bd%a0%e6%8f%aa%e5%87%ba%e5%86%85%e4%b8%aa%e5%b9%b2%e5%9d%8f%e4%ba%8b%e5%84%bf%e7%9a%84%e5%b0%8f%e5%ad%90","status":"publish","type":"post","link":"https:\/\/cn.hostease.com\/xueyuan\/jishu\/shujuku\/mysql%e6%97%a5%e5%bf%97%e5%ae%a1%e8%ae%a1-%e5%b8%ae%e4%bd%a0%e6%8f%aa%e5%87%ba%e5%86%85%e4%b8%aa%e5%b9%b2%e5%9d%8f%e4%ba%8b%e5%84%bf%e7%9a%84%e5%b0%8f%e5%ad%90\/","title":{"rendered":"MySQL\u65e5\u5fd7\u5ba1\u8ba1 \u5e2e\u4f60\u63ea\u51fa\u5185\u4e2a\u5e72\u574f\u4e8b\u513f\u7684\u5c0f\u5b50"},"content":{"rendered":"\n

MySQL\u65e5\u5fd7\u5ba1\u8ba1 \u5e2e\u4f60\u63ea\u51fa\u5185\u4e2a\u5e72\u574f\u4e8b\u7684\u5c0f\u5b50<\/h2>\n\n\n\n

\u7b80\u4ecb<\/h3>\n\n\n\n

Part1:<\/strong>\u5199\u5728\u6700\u524d<\/strong><\/p>\n\n\n\n

MySQL\u672c\u8eab\u5e76\u4e0d\u50cfMariaDB\u548cPercona\u4e00\u6837\u63d0\u4f9b\u5ba1\u8ba1\u529f\u80fd\uff0c\u4f46\u5982\u679c\u6211\u4eec\u60f3\u5bf9\u6570\u636e\u5e93\u8fdb\u884c\u5ba1\u8ba1\uff0c\u53bb\u770b\u662f\u8c01\u628a\u6211\u7684\u6570\u636e\u5e93\u6570\u636e\u7ed9\u5220\u4e86\uff0c\u8be5\u600e\u4e48\u529e\u5462\uff1f\u6211\u4eec\u4e3b\u8981\u5229\u7528init-connect\u53c2\u6570\uff0c\u8ba9\u6bcf\u4e2a\u767b\u5f55\u7684\u7528\u6237\u90fd\u8bb0\u5f55\u5230\u6211\u4eec\u7684\u6570\u636e\u5e93\u4e2d\uff0c\u5e76\u6293\u53d6\u5176connection_id()\uff0c\u518d\u6839\u636ebinlog\u5c31\u80fd\u591f\u627e\u51fa\u8c01\u5e72\u4e86\u90a3\u4e9b\u7834\u4e8b\u513f\u3002<\/p>\n\n\n\n

MariaDB\u5982\u4f55\u5ba1\u8ba1\uff0c\u53ef\u79fb\u6b65\uff1a<\/p>\n\n\n\n

\nhttps:\/\/suifu.blog.51cto.com\/9167728\/1857594\n<\/div><\/figure>\n\n\n\n

<\/p>\n\n\n\n

\u51c6\u5907<\/h3>\n\n\n\n

Part1:\u521b\u5efa\u6240\u9700\u5e93<\/strong><\/p>\n\n\n\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n<\/td>\n
\n
\n
[root@HE3 telegraf]<\/code># mysql -uroot -p<\/code><\/div>\n
Enter password: <\/code><\/div>\n
Welcome to the MySQL monitor.  Commands end with ; or \\g.<\/code><\/div>\n
Your MySQL connection <\/code>id<\/code> is 859<\/code><\/div>\n
Server version: 5.7.16-log MySQL Community Server (GPL)<\/code><\/div>\n
Copyright (c) 2000, 2016, Oracle and<\/code>\/or<\/code> its affiliates. All rights reserved.<\/code><\/div>\n
Oracle is a registered trademark of Oracle Corporation and<\/code>\/or<\/code> its<\/code><\/div>\n
affiliates. Other names may be trademarks of their respective<\/code><\/div>\n
owners.<\/code><\/div>\n
Type <\/code>'help;'<\/code> or <\/code>'\\h'<\/code> for<\/code> help. Type <\/code>'\\c'<\/code> to <\/code>clear<\/code> the current input statement.<\/code><\/div>\n
 <\/div>\n
mysql> create database auditdb;<\/code><\/div>\n
Query OK, 1 row affected (0.00 sec)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n\n\n\n

Part2:\u521b\u5efa\u6240\u9700\u8868<\/strong><\/p>\n\n\n\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n<\/td>\n
\n
\n
[root@HE3 ~]<\/code># mysql -uroot -p<\/code><\/div>\n
Enter password: <\/code><\/div>\n
Welcome to the MySQL monitor.  Commands end with ; or \\g.<\/code><\/div>\n
Your MySQL connection <\/code>id<\/code> is 266<\/code><\/div>\n
Server version: 5.7.16-log MySQL Community Server (GPL)<\/code><\/div>\n
Copyright (c) 2000, 2016, Oracle and<\/code>\/or<\/code> its affiliates. All rights reserved.<\/code><\/div>\n
Oracle is a registered trademark of Oracle Corporation and<\/code>\/or<\/code> its<\/code><\/div>\n
affiliates. Other names may be trademarks of their respective<\/code><\/div>\n
owners.<\/code><\/div>\n
Type <\/code>'help;'<\/code> or <\/code>'\\h'<\/code> for<\/code> help. Type <\/code>'\\c'<\/code> to <\/code>clear<\/code> the current input statement.<\/code><\/div>\n
 <\/div>\n
mysql> use auditdb;<\/code><\/div>\n
Database changed<\/code><\/div>\n
 <\/div>\n
mysql> CREATE TABLE accesslog (<\/code><\/div>\n
    <\/code>-> ID INT (10) UNSIGNED NOT NULL PRIMARY KEY auto_increment,<\/code><\/div>\n
    <\/code>-> ConnectionID INT (10) UNSIGNED,<\/code><\/div>\n
    <\/code>-> ConnUser VARCHAR (30) NOT NULL DEFAULT <\/code>''<\/code>,<\/code><\/div>\n
    <\/code>-> MatchUser VARCHAR (30) NOT NULL DEFAULT <\/code>''<\/code>,<\/code><\/div>\n
    <\/code>-> LoginTime datetime<\/code><\/div>\n
    <\/code>-> );<\/code><\/div>\n
Query OK, 0 rows affected (0.02 sec)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n\n\n\n

Part3:\u5728my.cnf\u4e2d\u6dfb\u52a0<\/strong><\/p>\n\n\n\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
init-connect=<\/code>'Insert into auditdb.accesslog(ConnectionID ,ConnUser ,MatchUser ,LoginTime)values(connection_id(),user(),current_user(),now());'<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n\n\n\n

\u5e76\u91cd\u542f\u6570\u636e\u5e93<\/p>\n\n\n\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n<\/td>\n
\n
\n
[root@HE3 ~]<\/code># \/etc\/init.d\/mysqld restart<\/code><\/div>\n
Shutting down MySQL.... SUCCESS! <\/code><\/div>\n
Starting MySQL. SUCCESS!<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n\n\n\n

\u6d4b\u8bd5<\/h3>\n\n\n\n

Part1:\u73af\u5883<\/strong><\/p>\n\n\n\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n<\/td>\n
\n
\n
[root@HE3 ~]<\/code># mysql -uroot -p<\/code><\/div>\n
Enter password: <\/code><\/div>\n
Welcome to the MySQL monitor.  Commands end with ; or \\g.<\/code><\/div>\n
Your MySQL connection <\/code>id<\/code> is 266<\/code><\/div>\n
Server version: 5.7.16-log MySQL Community Server (GPL)<\/code><\/div>\n
Copyright (c) 2000, 2016, Oracle and<\/code>\/or<\/code> its affiliates. All rights reserved.<\/code><\/div>\n
Oracle is a registered trademark of Oracle Corporation and<\/code>\/or<\/code> its<\/code><\/div>\n
affiliates. Other names may be trademarks of their respective<\/code><\/div>\n
owners.<\/code><\/div>\n
Type <\/code>'help;'<\/code> or <\/code>'\\h'<\/code> for<\/code> help. Type <\/code>'\\c'<\/code> to <\/code>clear<\/code> the current input statement.<\/code><\/div>\n
 <\/div>\n
mysql> use auditdb;<\/code><\/div>\n
 <\/div>\n
mysql> use helei;<\/code><\/div>\n
Database changed<\/code><\/div>\n
 <\/div>\n
mysql> <\/code>select<\/code> * from t1;<\/code><\/div>\n
+----+<\/code><\/div>\n
| <\/code>id<\/code> |<\/code><\/div>\n
+----+<\/code><\/div>\n
|  2 |<\/code><\/div>\n
|  3 |<\/code><\/div>\n
|  4 |<\/code><\/div>\n
|  5 |<\/code><\/div>\n
|  6 |<\/code><\/div>\n
|  7 |<\/code><\/div>\n
|  8 |<\/code><\/div>\n
|  9 |<\/code><\/div>\n
+----+<\/code><\/div>\n
8 rows <\/code>in<\/code> set<\/code> (0.00 sec)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n\n\n\n

Part2:\u7528\u4e0d\u540c\u7528\u6237\u767b\u5f55\u64cd\u4f5c<\/strong><\/p>\n\n\n\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n
42<\/div>\n
43<\/div>\n
44<\/div>\n
45<\/div>\n
46<\/div>\n
47<\/div>\n
48<\/div>\n
49<\/div>\n
50<\/div>\n
51<\/div>\n
52<\/div>\n
53<\/div>\n
54<\/div>\n
55<\/div>\n
56<\/div>\n
57<\/div>\n
58<\/div>\n
59<\/div>\n
60<\/div>\n
61<\/div>\n
62<\/div>\n
63<\/div>\n
64<\/div>\n
65<\/div>\n<\/td>\n
\n
\n
[root@HE3 telegraf]<\/code># mysql -uhelei -pMANAGER<\/code><\/div>\n
mysql: [Warning] Using a password on the <\/code>command<\/code> line interface can be insecure.<\/code><\/div>\n
Welcome to the MySQL monitor.  Commands end with ; or \\g.<\/code><\/div>\n
Your MySQL connection <\/code>id<\/code> is 185<\/code><\/div>\n
Server version: 5.7.16-log MySQL Community Server (GPL)<\/code><\/div>\n
Copyright (c) 2000, 2016, Oracle and<\/code>\/or<\/code> its affiliates. All rights reserved.<\/code><\/div>\n
Oracle is a registered trademark of Oracle Corporation and<\/code>\/or<\/code> its<\/code><\/div>\n
affiliates. Other names may be trademarks of their respective<\/code><\/div>\n
owners.<\/code><\/div>\n
Type <\/code>'help;'<\/code> or <\/code>'\\h'<\/code> for<\/code> help. Type <\/code>'\\c'<\/code> to <\/code>clear<\/code> the current input statement.<\/code><\/div>\n
 <\/div>\n
mysql> use helei;<\/code><\/div>\n
Database changed<\/code><\/div>\n
 <\/div>\n
mysql> <\/code>select<\/code> * from t1;<\/code><\/div>\n
+----+<\/code><\/div>\n
| <\/code>id<\/code> |<\/code><\/div>\n
+----+<\/code><\/div>\n
|  2 |<\/code><\/div>\n
|  3 |<\/code><\/div>\n
|  4 |<\/code><\/div>\n
|  5 |<\/code><\/div>\n
|  6 |<\/code><\/div>\n
|  7 |<\/code><\/div>\n
|  8 |<\/code><\/div>\n
|  9 |<\/code><\/div>\n
+----+<\/code><\/div>\n
8 rows <\/code>in<\/code> set<\/code> (0.00 sec)<\/code><\/div>\n
 <\/div>\n
mysql> delete from t1 where <\/code>id<\/code> = 2;<\/code><\/div>\n
Query OK, 1 row affected (0.00 sec)<\/code><\/div>\n
 <\/div>\n
mysql> delete from t1 where <\/code>id<\/code> = 4;<\/code><\/div>\n
Query OK, 1 row affected (0.00 sec)<\/code><\/div>\n
 <\/div>\n
 <\/div>\n
[root@HE3 telegraf]<\/code># mysql -uyuhao -pMANAGER<\/code><\/div>\n
mysql: [Warning] Using a password on the <\/code>command<\/code> line interface can be insecure.<\/code><\/div>\n
Welcome to the MySQL monitor.  Commands end with ; or \\g.<\/code><\/div>\n
Your MySQL connection <\/code>id<\/code> is 185<\/code><\/div>\n
Server version: 5.7.16-log MySQL Community Server (GPL)<\/code><\/div>\n
Copyright (c) 2000, 2016, Oracle and<\/code>\/or<\/code> its affiliates. All rights reserved.<\/code><\/div>\n
Oracle is a registered trademark of Oracle Corporation and<\/code>\/or<\/code> its<\/code><\/div>\n
affiliates. Other names may be trademarks of their respective<\/code><\/div>\n
owners.<\/code><\/div>\n
Type <\/code>'help;'<\/code> or <\/code>'\\h'<\/code> for<\/code> help. Type <\/code>'\\c'<\/code> to <\/code>clear<\/code> the current input statement.<\/code><\/div>\n
 <\/div>\n
mysql> use helei;<\/code><\/div>\n
Database changed<\/code><\/div>\n
 <\/div>\n
mysql> <\/code>select<\/code> * from t1;<\/code><\/div>\n
+----+<\/code><\/div>\n
| <\/code>id<\/code> |<\/code><\/div>\n
+----+<\/code><\/div>\n
|  3 |<\/code><\/div>\n
|  5 |<\/code><\/div>\n
|  6 |<\/code><\/div>\n
|  7 |<\/code><\/div>\n
|  8 |<\/code><\/div>\n
|  9 |<\/code><\/div>\n
+----+<\/code><\/div>\n
8 rows <\/code>in<\/code> set<\/code> (0.00 sec)<\/code><\/div>\n
 <\/div>\n
mysql> delete from t1 where <\/code>id<\/code> = 3;<\/code><\/div>\n
Query OK, 1 row affected (0.00 sec)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n\n\n\n

Part3:<\/strong>\u67e5\u770b\u7528\u6237ID<\/strong><\/p>\n\n\n\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n<\/td>\n
\n
\n
mysql> <\/code>select<\/code> * from accesslog;<\/code><\/div>\n
+----+--------------+-----------------+-----------+---------------------+<\/code><\/div>\n
| ID | ConnectionID | ConnUser        | MatchUser | LoginTime           |<\/code><\/div>\n
+----+--------------+-----------------+-----------+---------------------+<\/code><\/div>\n
|  1 |           10 | helei@localhost | helei@%   | 2016-12-08 19:07:49 |<\/code><\/div>\n
|  2 |           19 | helei@localhost | helei@%   | 2016-12-08 19:08:44 |<\/code><\/div>\n
|  3 |          125 | helei@localhost | helei@%   | 2016-12-08 19:24:46 |<\/code><\/div>\n
|  4 |          128 | yuhao@localhost | yuhao@%   | 2016-12-08 19:25:01 |<\/code><\/div>\n
|  5 |          182 | helei@localhost | helei@%   | 2016-12-08 19:33:02 |<\/code><\/div>\n
|  6 |          185 | yuhao@localhost | yuhao@%   | 2016-12-08 19:33:20 |<\/code><\/div>\n
+----+--------------+-----------------+-----------+---------------------+<\/code><\/div>\n
6 rows <\/code>in<\/code> set<\/code> (0.00 sec)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n\n\n\n

Part4:<\/strong>binlog\u65e5\u5fd7\u5bf9\u6bd4<\/strong><\/p>\n\n\n\n

\u8fd9\u91cc\u53ef\u4ee5\u770b\u5230t1\u8868\u7684id=2\u548cid=4\u5217\u662f\u7531thread_id=182\u7528\u6237\u5220\u6389\u7684\uff0c\u4e5f\u5c31\u662fhelei\u7528\u6237<\/p>\n\n\n\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n<\/td>\n
\n
\n
#161208 19:33:39 server id 1250  end_log_pos 5275 CRC32 0x2ae798a9      Query   thread_id=182   exec_time=0     error_code=0<\/code><\/div>\n
SET TIMESTAMP=1481254419\/*!*\/;<\/code><\/div>\n
BEGIN<\/code><\/div>\n
\/*!*\/;<\/code><\/div>\n
# at 5275<\/code><\/div>\n
#161208 19:33:39 server id 1250  end_log_pos 5324 CRC32 0x2cf42817      Rows_query<\/code><\/div>\n
# delete from t1 where id=2<\/code><\/div>\n
#161208 19:34:07 server id 1250  end_log_pos 5885 CRC32 0x947106d4      Query   thread_id=182   exec_time=0     error_code=0<\/code><\/div>\n
SET TIMESTAMP=1481254447\/*!*\/;<\/code><\/div>\n
BEGIN<\/code><\/div>\n
\/*!*\/;<\/code><\/div>\n
# at 5885<\/code><\/div>\n
#161208 19:34:07 server id 1250  end_log_pos 5934 CRC32 0xfe1eb7fc      Rows_query<\/code><\/div>\n
# delete from t1 where id=4<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n\n\n\n

\u8fd9\u91cc\u53ef\u4ee5\u770b\u5230t1\u8868\u7684id=3\u5217\u662f\u7531thread_id=185\u7528\u6237\u5220\u6389\u7684\uff0c\u4e5f\u5c31\u662fyuhao\u7528\u6237<\/p>\n\n\n\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n<\/td>\n
\n
\n
#161208 19:33:49 server id 1250  end_log_pos 5579 CRC32 0x5f8d9879      Query   thread_id=185   exec_time=0     error_code=0<\/code><\/div>\n
SET TIMESTAMP=1481254429\/*!*\/;<\/code><\/div>\n
BEGIN<\/code><\/div>\n
\/*!*\/;<\/code><\/div>\n
# at 5579<\/code><\/div>\n
#161208 19:33:49 server id 1250  end_log_pos 5630 CRC32 0x71feeadc      Rows_query<\/code><\/div>\n
# delete from t1 where id = 3<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n\n\n\n

\u53c2\u8003\u8d44\u6599\uff1a<\/p>\n\n\n\n

\nhttps:\/\/dbspace.blog.51cto.com\/6873717\/1881053\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"

MySQL\u65e5\u5fd7\u5ba1\u8ba1 \u5e2e\u4f60\u63ea\u51fa\u5185\u4e2a\u5e72\u574f\u4e8b\u7684\u5c0f\u5b50 \u7b80\u4ecb Part1:\u5199\u5728\u6700\u524d MySQL\u672c\u8eab\u5e76\u4e0d\u50cfMariaDB\u548c … \u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[10],"tags":[45,493],"class_list":["post-1542","post","type-post","status-publish","format-standard","hentry","category-shujuku","tag-mysql","tag-493"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1542","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/comments?post=1542"}],"version-history":[{"count":2,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1542\/revisions"}],"predecessor-version":[{"id":8959,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1542\/revisions\/8959"}],"wp:attachment":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/media?parent=1542"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/categories?post=1542"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/tags?post=1542"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}