nginx访问连接mysql数据库

最新推荐文章于 2024-09-24 15:20:43 发布

guo_yang

最新推荐文章于 2024-09-24 15:20:43 发布

阅读量6.7k

点赞数

本文链接：https://blog.csdn.net/guo_yang/article/details/82186313

版权

本文展示了如何在Nginx配置中利用Lua模块直接连接到MySQL数据库进行查询操作。通过设置数据库连接参数，如主机、端口、用户名、密码和数据库名，成功建立连接后执行SQL查询，并将结果编码为JSON返回。

摘要由CSDN通过智能技术生成

location /test {
?????? content_by_lua '
?????????? local mysql = require "resty.mysql"
?????????? local db, err = mysql:new()
?????????? if not db then
?????????????? ngx.say("failed to instantiate mysql: ", err)
?????????????? return
?????????? end

?????????? db:set_timeout(10000) -- 1 sec

?????????? local ok, err, errno, sqlstate = db:connect{
?????????????? host = "192.168.106.66",
?????????????? port = 3306,
?????????????? database = "greenskin",
?????????????? user = "cms",
?????????????? password = "greenskin",
?????????????? max_packet_size = 1024 * 1024 }

?????????? if not ok then
?????????????? ngx.say("failed to connect: ", err, ": ", errno, " ", sqlstate)
?????????????? return
?????????? end