https:\/\/go.dev\/doc\/tutorial\/database-access<\/a><\/p>\n\n\n\n\u6ce8\u610f\u5176\u4e2d\u589e\u52a0\u4e86 AllowNativePasswords: true \u7684\u914d\u7f6e\uff0c\u5426\u5219\u4f1a\u62a5\u9519 <\/p>\n\n\n\n
[mysql] 2022\/05\/26 14:46:43 connector.go:95: could not use requested auth plugin 'mysql_native_password': this user requires mysql native password authentication.\n2022\/05\/26 14:46:43 this user requires mysql native password authentication.<\/code><\/pre>\n\n\n\n<\/p>\n\n\n\n
package main\nimport (\n \"database\/sql\"\n \"fmt\"\n \"log\"\n \"os\"\n\n \"github.com\/go-sql-driver\/mysql\"\n)\nvar db *sql.DB\n\ntype TableT1 struct {\n ID int64\n NAME string\n}\n\nfunc main() {\n \/\/ Capture connection properties.\n cfg := mysql.Config{\n User: os.Getenv(\"DBUSER\"),\n Passwd: os.Getenv(\"DBPASS\"),\n Net: \"tcp\",\n Addr: \"192.168.56.1:5258\",\n DBName: \"testdb\",\n AllowNativePasswords: true<\/span>,\n }\n \/\/ Get a database handle.\n var err error\n db, err = sql.Open(\"mysql\", cfg.FormatDSN())\n if err != nil {\n log.Fatal(err)\n }\n\n pingErr := db.Ping()\n if pingErr != nil {\n log.Fatal(pingErr)\n }\n fmt.Println(\"Connected!\")\n \n tableT1s, err := selectTable(\"1\")\n if err != nil {\n log.Fatal(err)\n }\n fmt.Printf(\"Albums found: %v\\n\", tableT1s)\n\n}\n\nfunc selectTable(name string) ([]TableT1, error) {\n \/\/ An tableT1s slice to hold data from returned rows.\n var tableT1s []TableT1\n\n rows, err := db.Query(\"SELECT * FROM t1 WHERE id = ?\", name)\n if err != nil {\n return nil, fmt.Errorf(\"selectTable %q: %v\", name, err)\n }\n defer rows.Close()\n \/\/ Loop through rows, using Scan to assign column data to struct fields.\n for rows.Next() {\n var alb TableT1\n if err := rows.Scan(&alb.ID,&alb.NAME); err != nil {\n return nil, fmt.Errorf(\"selectTable %q: %v\", name, err)\n }\n tableT1s = append(tableT1s, alb)\n }\n if err := rows.Err(); err != nil {\n return nil, fmt.Errorf(\"selectTable %q: %v\", name, err)\n }\n return tableT1s, nil\n}<\/code><\/pre>\n\n\n\n<\/span>GBase 8a\u8868<\/span><\/h2>\n\n\n\n2\u4e2a\u5b57\u6bb5\u7684\u8868\uff0c\u6ca1\u6709\u91c7\u7528\u5b98\u7f51\u7684\u8868\u7ed3\u6784<\/p>\n\n\n\n
gbase> desc testdb.t1;\n+-------+--------------+------+-----+---------+-------+\n| Field | Type | Null | Key | Default | Extra |\n+-------+--------------+------+-----+---------+-------+\n| id | int(11) | YES | MUL | NULL | |\n| name | varchar(100) | YES | | NULL | |\n+-------+--------------+------+-----+---------+-------+\n2 rows in set (Elapsed: 00:00:00.00)\n\ngbase> select * from testdb.t1 where id=1;\n+------+---------+\n| id | name |\n+------+---------+\n| 1 | Name_10 |\n+------+---------+\n1 row in set (Elapsed: 00:00:00.01)\n<\/code><\/pre>\n\n\n\n<\/span>\u6267\u884c<\/span><\/h2>\n\n\n\nE:\\go\\hello>go run .\nConnected!\nAlbums found: [{1 Name_10}]\n\nE:\\go\\hello><\/code><\/pre>\n\n\n\n<\/p>","protected":false},"excerpt":{"rendered":"
\u622a\u81f3\u76ee\u524d(2022-05-26)\uff0cGBase 8a\u5c1a\u672a\u53d1\u5e03go\u8bed\u8a00\u7684\u9a71\u52a8\uff0c\u672c\u6587\u5c1d\u8bd5\u901a\u8fc7go-sql-driver\/mysql\u9a71\u52a8\u6765\u8bbf\u95eeGBase 8a\u6570\u636e\u5e93\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,1],"tags":[113],"class_list":["post-9493","post","type-post","status-publish","format-standard","hentry","category-gbase8a","category-1","tag-golang"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/9493","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=9493"}],"version-history":[{"count":13,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/9493\/revisions"}],"predecessor-version":[{"id":9506,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/9493\/revisions\/9506"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=9493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=9493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=9493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}