{"id":260,"date":"2025-10-17T16:50:30","date_gmt":"2025-10-17T08:50:30","guid":{"rendered":"https:\/\/www.youvii.site\/?p=260"},"modified":"2025-10-20T09:59:28","modified_gmt":"2025-10-20T01:59:28","slug":"shujukujichuer","status":"publish","type":"post","link":"https:\/\/www.youvii.site\/index.php\/archives\/shujukujichuer","title":{"rendered":"\u6570\u636e\u5e93\u57fa\u7840(\u4e8c)"},"content":{"rendered":"

\u6570\u636e\u5e93\u57fa\u7840\u4e8c<\/h1>\n

\u6b64\u6b21\u8df3\u8fc7\u6570\u636e\u5e93\u64cd\u4f5c\u8bed\u53e5<\/p>\n

\u6570\u636e\u5e93\u64cd\u4f5c\u89c1\u7b14\u8bb0\u5185SQL server\u57fa\u672c\u64cd\u4f5c\u9644\u4ef6<\/p>\n

Mysql\u5b89\u5168\u503c\u5b88\u5e38\u7528\u8bed\u53e5<\/font><\/strong><\/p>\n

1\u3001\u7528\u6237\u6743\u9650\u8bbe\u7f6e<\/font><\/p>\n

–Mysql\u4e2d\u7528\u6237\u662f\u5982\u4f55\u5b9a\u4e49\u7684<\/font><\/p>\n

\u7528\u6237\u540d@\u4e3b\u673a\u57df<\/font><\/p>\n

10.0.0.51<\/font><\/p>\n

10.0.0.%<\/font><\/p>\n

%<\/font><\/p>\n

10.0.0.0\/255.255.255.0<\/font><\/p>\n

Db01<\/font><\/p>\n

Localhost<\/font><\/p>\n

127.0.0.1<\/font><\/p>\n

–\u7528\u6237\u521b\u5efa <\/font><\/p>\n

create user xinjing@’%’ identified by ‘123’;<\/font><\/p>\n

–\u7528\u6237\u5220\u9664 <\/font><\/p>\n

drop user username;<\/font><\/p>\n

username\uff1a\u662f\u8981\u5220\u9664\u7684\u7528\u6237\u540d <\/font><\/p>\n

\u5982 drop user root@\u2018%\u2019<\/font><\/p>\n

Drop user \u2018\u2019@\u2018127.0.0.1\u2019 \u7528\u6237\u540d\u4e3a\u7a7a\u7684\u5220\u9664<\/font><\/p>\n

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

–\u6743\u9650\u7ea7\u522b\u4ecb\u7ecd<\/font><\/p>\n

\u5168\u5c40\u2014\u2014\u53ef\u4ee5\u7ba1\u7406\u6574\u4e2aMySQL<\/font><\/p>\n

\u5e93\u2014\u2014\u53ef\u4ee5\u7ba1\u7406\u6307\u5b9a\u7684\u6570\u636e\u5e93<\/font><\/p>\n

\u8868\u2014\u2014\u53ef\u4ee5\u7ba1\u7406\u6307\u5b9a\u6570\u636e\u5e93\u7684\u6307\u5b9a\u8868<\/font><\/p>\n

\u5b57\u6bb5\u2014\u2014\u53ef\u4ee5\u7ba1\u7406\u6307\u5b9a\u6570\u636e\u5e93\u7684\u6307\u5b9a\u8868\u7684\u6307\u5b9a\u5b57\u6bb5\u3001<\/font><\/p>\n

\u6743\u9650\u5b58\u50a8\u5728mysql\u5e93\u7684user, db, tables_priv, columns_priv, procs_priv\u8fd9\u51e0\u4e2a\u7cfb\u7edf\u8868 \u4e2d\uff0c\u5f85MySQL\u5b9e\u4f8b\u542f\u52a8\u540e\u5c31\u52a0\u8f7d\u5230\u5185\u5b58\u4e2d<\/font><\/p>\n

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

–\u67e5\u770b\u7528\u6237\u6743\u9650\u8d4b\u4e88\u60c5\u51b5<\/font><\/p>\n

show grants for xinjing@’%’<\/font><\/p>\n

–\u7528\u6237\u6388\u6743 <\/font><\/p>\n

grant all privileges on stu.* to \u2018xinjing\u2019@\u2019%\u2019 identified by \u2018123\u2019 with option;<\/font><\/p>\n

revoke all privileges on stu.* from ‘xinjing’@’%’; <\/font><\/p>\n

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

2\u3001\u5143\u6570\u636e\u67e5\u8be2<\/font><\/p>\n

Select version()\uff1b\u670d\u52a1\u5668\u7248\u672c\u4fe1\u606f<\/font><\/p>\n

Select database()\uff1b\u5f53\u524d\u6570\u636e\u5e93\u540d<\/font><\/p>\n

Select user():\u5f53\u524d\u7528\u6237\u540d<\/font><\/p>\n

Show status;\u670d\u52a1\u5668\u72b6\u6001<\/font><\/p>\n

Show variables;\u670d\u52a1\u5668\u914d\u7f6e\u53d8\u91cf<\/font><\/p>\n

Show global variables like \u2018%datadir%\u2018\uff1a\u770b\u6570\u636e\u6587\u4ef6\u5b58\u653e\u4f4d\u7f6e<\/font><\/p>\n

show global variables like ‘%datadir%’; <\/font><\/p>\n

select @@datadir; \u67e5\u8be2\u6570\u636e\u5e93\u7684\u8def\u5f84<\/font><\/p>\n

select @@basedir \u67e5\u8be2mysql\u7684\u5b89\u88c5\u8def\u5f84<\/font><\/p>\n

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

3\u3001union\u67e5\u8be2\u8be6\u89e3<\/font><\/p>\n

union\u67e5\u8be2\u5c31\u662f\u628a2\u6761\u6216\u8005\u591a\u6761sql\u8bed\u53e5\u7684\u67e5\u8be2\u7ed3\u679c\uff0c\u5408\u5e76\u6210\u4e00\u4e2a\u7ed3\u679c\u96c6\u3002<\/font><\/p>\n

sql1: N\u884c\uff0csql2: M\u884c\uff0csql1 union sql2 —> N+M\u884c<\/font><\/p>\n

\u8981\u6c42\u7ed3\u679c\u96c6\u4e2d\u7684\u5217\u6570\u4e00\u81f4\u5c31\u53ef\u4ee5.\uff08\u5982\u90fd\u662f2\u5217\u6216\u8005N\u5217\uff09<\/font><\/p>\n

union\u53d6\u51fa\u7684\u6700\u7ec8\u5217\u540d,\u4ee5\u7b2c1\u6761sql\u4e3a\u51c6<\/font><\/p>\n

union\u67e5\u8be2\u9ed8\u8ba4\u4f1a\u53bb\u91cd\uff0c\u5982\u679c\u4e0d\u60f3\u53bb\u91cd\u5c31\u7528union all<\/font><\/p>\n

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

4\u3001\u5206\u7ec4\u67e5\u8be2\u5c55\u793a<\/font><\/p>\n

GROUP_CONCAT() <\/font><\/p>\n

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

select sid,group_concat(cid),group_concat(cj order by cj desc SEPARATOR ‘ ‘) from score<\/font><\/p>\n

group by sid<\/font><\/p>\n

5\u3001\u5b57\u7b26\u4e32\u51fd\u6570<\/font><\/p>\n

\"1741862071468-fc972a14-d9d1-4170-b377-cfee412cb91f.png\"<\/p>\n

6\u3001mysql\u6570\u636e\u5e93\u5bfc\u5165\u5bfc\u51fa<\/font><\/p>\n

— \u8868\u6570\u636e\uff08\u8bb0\u5f55\uff09\u5bfc\u5165\u5bfc\u51fa<\/font><\/p>\n

— \u5bfc\u51fa\u4e3atxt\u6587\u4ef6<\/font><\/p>\n

select * from demo1 into outfile ‘\/temp\/utemp1data.txt’;<\/font><\/p>\n

use student;<\/font><\/p>\n

show VARIABLES like "secure_file_priv";<\/font><\/p>\n

–\u5bfc\u5165txt\u6587\u4ef6<\/font><\/p>\n

load data local infile ‘\/root\/utemp1data.txt’ into table temp;<\/font><\/p>\n

— mysqldump\u5bfc\u51fa<\/font><\/p>\n

— dump\u51fa\u8868utemp1<\/font><\/p>\n

— mysqldump -uroot -p student utemp1>utemp1.sql<\/font><\/p>\n

— dump\u51fa\u5e93student<\/font><\/p>\n

— mysqldump -uroot -p student>student.sql<\/font><\/p>\n

— dump\u6240\u6709\u7684\u6570\u636e\u5e93\u53ca\u6570\u636e\u5e93\u8868<\/font><\/p>\n

— mysqldump -u root -p –all-databases>mysqldatabases.sql; <\/font><\/p>\n

— mysql\u7684\u6570\u636e\u5e93\u5bfc\u5165"<"<\/font><\/p>\n

— \u65b0\u5efa\u4e00\u4e2a\u6570\u636e\u5e93<\/font><\/p>\n

create database dumpdemo1<\/font><\/p>\n

— \u56de\u5230mysql\u63a5\u53e3<\/font><\/p>\n

— mysql -u root -p654321 dumpdemo1<student.sql<\/font><\/p>\n

— \u8fdb\u5165mysql\u9a8c\u8bc1<\/font><\/p>\n

use dumpdemo1<\/font><\/p>\n

show tables;<\/font><\/p>\n

— mysql\u7684\u6570\u636e\u5e93\u5bfc\u5165 "source"<\/font><\/p>\n

mysql -u root -p<\/font><\/p>\n

create database sourcedumpdemo;<\/font><\/p>\n

source \/var\/lib\/mysql-files\/student.sql<\/font><\/p>\n

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

\u6570\u636e\u5e93\u6f0f\u626b\u5de5\u5177scuba\u4ecb\u7ecd<\/font><\/strong><\/p>\n

Scuba\u662f\u4e00\u6b3e\u6570\u636e\u5e93\u626b\u63cf\u8f6f\u4ef6<\/font><\/p>\n

\u626b\u63cf\u6570\u636e\u5e93\u6f0f\u6d1e,\u5bfb\u627e\u4e0d\u5b89\u5168\u7684\u56e0\u7d20,\u63d0\u5347\u6570\u636e\u5e93\u5b89\u5168\u7b49\u7ea7,\u53ca\u65f6\u89e3\u51b3\u6f0f\u6d1e\u95ee\u9898;<\/font><\/p>\n

\u652f\u6301Oracle,SQL Server,SAP Sybase,IBM DB2\u548cMySQL\u7b49\u6570\u636e\u5e93<\/font><\/p>\n

\u672c\u5730\u9700\u8981\u5b89\u88c5\u6709jdk\u548cmysql-connector-java-5.1.44-bin.jar\u5373\u53ef<\/font>
\n<\/font><\/p>\n

java -verison<\/font><\/p>\n

\"1741862071237-4ecc15f6-ff11-403e-a55a-80b7227c8793.png\"<\/p>\n

\"1741862071272-9e894c84-31c1-4306-b30e-1fb258aac3d1.png\"<\/p>\n

\u8fde\u63a5\u6570\u636e\u5e93<\/p>\n

\"1741862071258-959a7ccb-41af-4ced-b41b-8945761250c4.png\"<\/p>\n

\"1741862071461-d0e9258c-ed33-4908-aa91-e3ba72a96941.png\"<\/p>\n

\n

\u66f4\u65b0: 2025-04-11 20:55:50
\n\u539f\u6587: http:\/\/www.yuque.com\/yuhui.net\/network\/ro58o7w6myf7ym39<\/a><\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"

\u6570\u636e\u5e93\u57fa\u7840\u4e8c \u6b64\u6b21\u8df3\u8fc7\u6570\u636e\u5e93\u64cd\u4f5c\u8bed\u53e5 \u6570\u636e\u5e93\u64cd\u4f5c\u89c1\u7b14\u8bb0\u5185SQL server\u57fa\u672c\u64cd\u4f5c\u9644\u4ef6 Mysql\u5b89\u5168\u503c\u5b88\u5e38\u7528\u8bed\u53e5 1\u3001\u7528\u6237\u6743\u9650\u8bbe\u7f6e –Mysql\u4e2d\u7528\u6237\u662f\u5982\u4f55\u5b9a\u4e49\u7684 \u7528\u6237\u540d@\u4e3b\u673a\u57df 10.0.0.51 10.0.0.% % 10.0.0.0\/255.255.255.0 Db01 Localhost 127.0.0.1 –\u7528\u6237\u521b\u5efa create user xinjing@& […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[60],"class_list":["post-260","post","type-post","status-publish","format-standard","hentry","category-database","tag-shujuku"],"_links":{"self":[{"href":"https:\/\/www.youvii.site\/index.php\/wp-json\/wp\/v2\/posts\/260","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.youvii.site\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.youvii.site\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.youvii.site\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.youvii.site\/index.php\/wp-json\/wp\/v2\/comments?post=260"}],"version-history":[{"count":0,"href":"https:\/\/www.youvii.site\/index.php\/wp-json\/wp\/v2\/posts\/260\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.youvii.site\/index.php\/wp-json\/wp\/v2\/media?parent=260"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.youvii.site\/index.php\/wp-json\/wp\/v2\/categories?post=260"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.youvii.site\/index.php\/wp-json\/wp\/v2\/tags?post=260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}