{"id":48,"date":"2021-01-04T11:30:29","date_gmt":"2021-01-04T11:30:29","guid":{"rendered":"https:\/\/blog.gwlin.com\/?p=48"},"modified":"2023-03-29T18:59:54","modified_gmt":"2023-03-29T18:59:54","slug":"Linux\u8fd0\u7ef4\u5e38\u7528\u547d\u4ee4\uff08\u6301\u7eed\u66f4\u65b0\uff09","status":"publish","type":"post","link":"https:\/\/www.gwlin.com\/blog\/posts\/48","title":{"rendered":"Linux\u8fd0\u7ef4\u5e38\u7528\u547d\u4ee4\uff08\u6301\u7eed\u66f4\u65b0\uff09"},"content":{"rendered":"

Mysql\u76f8\u5173<\/p>\n

1\u3001\u521b\u5efa\u6570\u636e\u5e93<\/p>\n

CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;<\/code><\/pre>\n
2\u3001\u6dfb\u52a0\u7528\u6237<\/p>\n
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';<\/code><\/pre>\n
3\u3001\u7528\u6237\u6388\u6743<\/p>\n
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';<\/code><\/pre>\n
4\u3001\u4e34\u65f6\u53d6\u6d88 full group by<\/p>\n
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));<\/code><\/pre>\n
Git\u76f8\u5173<\/p>\n
1\u3001\u5ffd\u7565\u6587\u4ef6\u6743\u9650\u53d8\u5316<\/p>\n
# \u5355\u4e2a\u9879\u76ee\u8bbe\u7f6e\r\ngit config core.fileMode false\r\n# \u5168\u5c40\u8bbe\u7f6e\r\ngit config --global core.fileMode false<\/code><\/pre>\n
2\u3001\u9884\u89c8 git pull \u5c06\u66f4\u6539\u7684\u6587\u4ef6<\/p>\n
git fetch && git diff --name-only ..origin<\/code><\/pre>\n
Linux\u76f8\u5173<\/p>\n
1\u3001\u6dfb\u52a0\u7528\u6237\u5230\u7528\u6237\u7ec4<\/p>\n
usermod -a -G group user<\/code><\/pre>\n
2\u3001\u538b\u7f29zip\u6587\u4ef6\u5939<\/p>\n
 zip -r \u6587\u4ef6\u540d \u6587\u4ef6\u5939<\/code><\/pre>\n
3\u3001\u9012\u5f52\u4fee\u6539\u76ee\u5f55\u6743\u9650<\/p>\n
find <\u76ee\u5f55> -type d -exec chmod <755> {} \\;<\/code><\/pre>\n
4\u3001\u9012\u5f52\u4fee\u6539\u6587\u4ef6\u6743\u9650<\/p>\n
find <\u76ee\u5f55> -type f -exec chmod <644> {} \\;<\/code><\/pre>\n
5\u3001SCP\u4e0a\u4f20\u6587\u4ef6<\/p>\n
scp -P \u7aef\u53e3 \u672c\u5730\u8def\u5f84 \u7528\u6237@\u4e3b\u673a:\u8fdc\u7a0b\u7edd\u5bf9\u8def\u5f84<\/code><\/pre>\n
6\u3001SCP\u4e0b\u8f7d\u6587\u4ef6<\/p>\n
scp -P \u7aef\u53e3 \u7528\u6237@\u4e3b\u673a:\u8fdc\u7a0b\u7edd\u5bf9\u8def\u5f84 \u672c\u5730\u8def\u5f84<\/code><\/pre>\n
7\u3001ufw\u5141\u8bb8\u7aef\u53e3\u8303\u56f4<\/p>\n
<span class="hljs-attribute">ufw<\/span> <span class="hljs-literal">allow<\/span> <span class="hljs-number">1234<\/span>:<span class="hljs-number">5678<\/span>\/tcp<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
Mysql\u76f8\u5173 1\u3001\u521b\u5efa\u6570\u636e\u5e93 CREATE DATABASE mydatabase CHARACTER SE […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[179],"tags":[189],"class_list":["post-48","post","type-post","status-publish","format-standard","hentry","category-notes","tag-linux"],"_links":{"self":[{"href":"https:\/\/www.gwlin.com\/blog\/wp-json\/wp\/v2\/posts\/48","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gwlin.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gwlin.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gwlin.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gwlin.com\/blog\/wp-json\/wp\/v2\/comments?post=48"}],"version-history":[{"count":0,"href":"https:\/\/www.gwlin.com\/blog\/wp-json\/wp\/v2\/posts\/48\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gwlin.com\/blog\/wp-json\/wp\/v2\/media?parent=48"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gwlin.com\/blog\/wp-json\/wp\/v2\/categories?post=48"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gwlin.com\/blog\/wp-json\/wp\/v2\/tags?post=48"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}