OS\u306b\u306fAmazon Linux2023\u3092\u9078\u629e\u3057\u307e\u3057\u305f\u3002<\/p>\n
![\"\"](\"https:\/\/took.jp\/wp-content\/uploads\/2023\/07\/2a88d97b9e0270cec1cd9240aea97b29-300x271.jpg\")
<\/p>\n
![\"\"](\"https:\/\/took.jp\/wp-content\/uploads\/2023\/07\/37a765146b0e21d69587a63b337c87a9-300x242.png\")
<\/p>\n
<\/p>\n
\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u304c\u7acb\u3061\u4e0a\u304c\u3063\u305f\u306e\u3092\u78ba\u8a8d\u3057\u305f\u3089\u3001\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u9078\u629e\u3057\u3001\u30cd\u30c3\u30c8\u30ef\u30fc\u30ad\u30f3\u30b0\u30bf\u30d6\u3092\u958b\u304d\u3001\u9759\u7684IP\u3092\u30a2\u30bf\u30c3\u30c1\u3057\u307e\u3059\u3002<\/p>\n
![\"\"](\"https:\/\/took.jp\/wp-content\/uploads\/2023\/07\/bc1c39582b2a5e3c2fed13d2771581c9.png\")
<\/p>\n
<\/p>\n
Amazon Linux2023\u3078\u306emysql\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n
\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306b\u63a5\u7d9a\u3057\u3001\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n
sudo yum localinstall https:\/\/dev.mysql.com\/get\/mysql80-community-release-el9-1.noarch.rpm\r\n\r\nsudo yum install mysql-community-server<\/code><\/pre>\n <\/p>\n
\u3053\u306e\u72b6\u614b\u3067\u306f\u3001\u307e\u3060mysql\u306f\u7acb\u3061\u4e0a\u304c\u308a\u307e\u305b\u3093\u3002<\/p>\n
free -h\r\n\r\n total used free shared buff\/cache available\r\nMem: 407Mi 209Mi 109Mi 0.0Ki 88Mi 187Mi\r\nSwap: 0B 0B 0B<\/code><\/pre>\n <\/p>\n
mysql\u304c\u7acb\u3061\u4e0a\u304c\u3089\u306a\u3044\u539f\u56e0\u304c\u30e1\u30e2\u30ea\u4e0d\u8db3\u306b\u3088\u308b\u3082\u306e\u3060\u3068\u8003\u3048\u3089\u308c\u308b\u305f\u3081\u3001swap\u9818\u57df\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n
# swap\u30d5\u30a1\u30a4\u30eb\u306e\u4f5c\u6210\r\nsudo fallocate -l 1G \/swapfile\r\n\r\n# \u6a29\u9650\u306e\u8a2d\u5b9a\u3068\u30b9\u30ef\u30c3\u30d7\u9818\u57df\u5316\r\nsudo chmod 600 \/swapfile\r\n\r\nsudo mkswap \/swapfile\r\n\r\n# swap\u306e\u6c38\u7d9a\u5316\r\necho '\/swapfile none swap sw 0 0' | sudo tee -a \/etc\/fstab<\/code><\/pre>\n <\/p>\n
\u3053\u306e\u72b6\u614b\u3067\u3001mysql\u3092\u8d77\u52d5\u3057\u76f4\u3059\u3068\u6b63\u5e38\u306b\u8d77\u52d5\u3059\u308b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n
# \u8d77\u52d5\u72b6\u614b\u78ba\u8a8d\r\nsudo systemctl status mysqld\r\n\r\n# \u518d\u8d77\u52d5\r\nsudo systemctl restart mysqld<\/code><\/pre>\n <\/p>\n
mysql\u306b\u63a5\u7d9a\u3057\u307e\u3059\u3002<\/p>\n
\u307e\u305a\u3001\u521d\u671f\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n
sudo less \/var\/log\/mysqld.log<\/code><\/pre>\n <\/p>\n
\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u8a18\u8f09\u306e\u3042\u308b\u90e8\u5206\u304c\u30d1\u30b9\u30ef\u30fc\u30c9\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n
\uff08\u30d1\u30b9\u30ef\u30fc\u30c9\u90e8\u5206\u306f\u3001\u300cxxxxxxxxx\u300d\u3067\u30de\u30b9\u30af\u3057\u3066\u3044\u307e\u3059\uff09<\/p>\n
[Note] [MY-010454] [Server] A temporary password is generated for root@localhost: xxxxxxxxx<\/code><\/pre>\n <\/p>\n
mysql\u306b\u30a2\u30af\u30bb\u30b9\u3057\u307e\u3059\u3002<\/p>\n
mysql -u root -p\r\n\r\n# \u5148\u307b\u3069\u53d6\u5f97\u3057\u305f\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b\u3057\u307e\u3059\r\nEnter password: <\/code><\/pre>\n <\/p>\n
\u521d\u671f\u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u72b6\u614b\u3067\u3001\u64cd\u4f5c\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5909\u66f4\u3059\u308b\u3088\u3046\u6012\u3089\u308c\u308b\u305f\u3081\u3001\u8a2d\u5b9a\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n
\u521d\u671f\u72b6\u614b\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u30dd\u30ea\u30b7\u30fc\u306f\u4e0b\u8a18\u306e\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n
show variables like 'validate_password%';\r\n+-------------------------------------------------+--------+\r\n| Variable_name | Value |\r\n+-------------------------------------------------+--------+\r\n| validate_password.changed_characters_percentage | 0 |\r\n| validate_password.check_user_name | ON |\r\n| validate_password.dictionary_file | |\r\n| validate_password.length | 8 |\r\n| validate_password.mixed_case_count | 1 |\r\n| validate_password.number_count | 1 |\r\n| validate_password.policy | MEDIUM |\r\n| validate_password.special_char_count | 1 |\r\n+-------------------------------------------------+--------+<\/code><\/pre>\n <\/p>\n
\u4eca\u56de\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u30dd\u30ea\u30b7\u30fc\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u89e6\u308c\u307e\u305b\u3093\u304c\u3001\u8a18\u53f7\u3092\u542b\u307f\u3001\u5927\u6587\u5b57\u5c0f\u6587\u5b57\u3092\u542b\u307f\u3001\u6570\u5b57\u3092\u542b\u30808\u6587\u5b57\u4ee5\u4e0a\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3067\u3042\u308c\u3070\u3001\u554f\u984c\u306a\u3044\u3067\u3059\u3002<\/p>\n
\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u300c@Password123<\/strong>\u300d\u3068\u3057\u3001\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\nALTER USER 'root'@'localhost' IDENTIFIED BY '@Password123';<\/code><\/pre>\n <\/p>\n
\u6b21\u306b\u5916\u90e8\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3059\u308b\u969b\u306e\u30e6\u30fc\u30b6\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n
CREATE USER 'root'@'%' identified by '@Password123';\r\nGRANT ALL ON *.* TO 'root'@'%' WITH GRANT OPTION;\r\nFLUSH PRIVILEGES;<\/code><\/pre>\n <\/p>\n
\u3053\u308c\u3067\u8a2d\u5b9a\u306f\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n
<\/p>\n
DB\u3068\u306e\u758e\u901a\u78ba\u8a8d<\/h3>\n
lambda\u306e\u51e6\u7406\u306f\u4e0b\u8a18\u306e\u3088\u3046\u306b\u3057\u3001\u758e\u901a\u78ba\u8a8d\u3092\u3057\u307e\u3057\u305f\u3002<\/p>\n
\u63a5\u7d9a\u60c5\u5831\u306f\u81ea\u8eab\u306e\u3082\u306e\u306b\u7f6e\u304d\u63db\u3048\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n
<\/p>\n
package main\r\n\r\nimport (\r\n\t\"database\/sql\"\r\n\t\"fmt\"\r\n\t\"log\"\r\n\t\"strings\"\r\n\r\n\t\"github.com\/aws\/aws-lambda-go\/events\"\r\n\t\"github.com\/aws\/aws-lambda-go\/lambda\"\r\n\t_ \"github.com\/go-sql-driver\/mysql\"\r\n)\r\n\r\nfunc handler(r events.APIGatewayProxyRequest) (events.APIGatewayProxyResponse, error) {\r\n\thost := \"LightsailStaticIp\"\r\n\tdatabase := \"YourDatabase\"\r\n\tusername := \"YourUsername\"\r\n\tpassword := \"YoutPassword\"\r\n\r\n\tdataSource := fmt.Sprintf(\"%s:%s@(%s)\/%s?parseTime=true\", username, password, host, database)\r\n\tvar db *sql.DB\r\n\tvar err error\r\n\tdb, err = sql.Open(\"mysql\", dataSource)\r\n\tif err != nil {\r\n\t\tfmt.Println(err)\r\n\t}\r\n\r\n\trows, err := db.Query(\"show tables\")\r\n\tif err != nil {\r\n\t\tlog.Fatal(err)\r\n\t}\r\n\tdefer rows.Close()\r\n\r\n\tvar tableNames []string\r\n\tfor rows.Next() {\r\n\t\tvar tableName string\r\n\t\terr := rows.Scan(&tableName)\r\n\t\tif err != nil {\r\n\t\t\tlog.Fatal(err)\r\n\t\t}\r\n\t\ttableNames = append(tableNames, tableName)\r\n\t}\r\n\r\n\treturn events.APIGatewayProxyResponse{\r\n\t\tBody: strings.Join(tableNames, \",\"),\r\n\t\tStatusCode: 200,\r\n\t}, nil\r\n}\r\n\r\nfunc main() {\r\n\tlambda.Start(handler)\r\n}\r\n<\/code><\/pre>\n <\/p>\n","protected":false},"excerpt":{"rendered":"
lambda\u304b\u3089lightsail\u306emysql\u306b\u63a5\u7d9a\u3059\u308b \u76ee\u7684 golang\u3067sam\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u6210\u3057\u3066\u3044\u307e\u3059\u3002 lambda\u3092\u4f7f\u7528\u3057\u3001DB\u306bRDS\u3092\u63a1\u7528\u3059\u308b\u4e88\u5b9a\u3067\u3057\u305f\u304c\u3001\u500b\u4eba\u958b\u767a\u3067RDS\u3092\u4f7f\u7528\u3059\u308b\u306e\u306f\u304a\u8ca1\u5e03\u306b\u512a\u3057\u304f\u306a\u3044\u3067\u3059\u3002 \u691c\u8a3c\u74b0\u5883\u306b\u2026<\/p>\n","protected":false},"author":3,"featured_media":3071,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[72],"tags":[],"class_list":["post-3068","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-aws"],"_links":{"self":[{"href":"https:\/\/took.jp\/tech-blog\/wp-json\/wp\/v2\/posts\/3068","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/took.jp\/tech-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/took.jp\/tech-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/took.jp\/tech-blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/took.jp\/tech-blog\/wp-json\/wp\/v2\/comments?post=3068"}],"version-history":[{"count":0,"href":"https:\/\/took.jp\/tech-blog\/wp-json\/wp\/v2\/posts\/3068\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/took.jp\/tech-blog\/wp-json\/wp\/v2\/media\/3071"}],"wp:attachment":[{"href":"https:\/\/took.jp\/tech-blog\/wp-json\/wp\/v2\/media?parent=3068"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/took.jp\/tech-blog\/wp-json\/wp\/v2\/categories?post=3068"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/took.jp\/tech-blog\/wp-json\/wp\/v2\/tags?post=3068"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}