Lua programming ,error in establishing Database connection

Question

After writing the code to connect to database,lua returns an error as

Error in establishing connection to MySQL ,Can't connect to /var/lib/mysql/mysql.sock

I'm unable to locate the /var/lib/mysql/mysql.sock file (which I haven't created )

My Sock is /tmp/mysql.sock

Below is my code to connect to MySQL database.

mysql = require "luasql.mysql"

local env  = mysql.mysql()
local conn = env:connect('test','root','')
print(env,conn)

status,errorString = conn:execute([[CREATE TABLE sample2 (id INTEGER, name TEXT);]])
print(status,errorString )

score 0 · Accepted Answer · edited May 23 '17 at 12:23

0

as seen there: Luasql error: "LuaSQL: error connecting to database", the problem is because luasql defaults to using a default socket path when connecting to localhost without a port. so just set the mysql host and port in env:connect or specify the socket path.

EDIT: I believe your code should be:

env:connect('test','root','','localhost',3306) -- for tcp
-- or
env:connect('test','root','',':/tmp/mysql.sock') -- for socket

edited May 23 '17 at 12:23

Community

1
1

answered Jun 27 '14 at 14:45

nonchip

1,084
1
18
36

With LUA 5.2 on Ubuntu 14.04 I get an error "Unknown MySQL server host ':/tmp/mysql.sock'" for the socket version – Gene Vincent Feb 17 '16 at 22:46
well, does the socket exist in that path? – nonchip Feb 18 '16 at 08:50
Yes, the socket I speciefied does exist, but I think not all versions of LuaSQL support the setting of the socket this way. – Gene Vincent Feb 18 '16 at 11:27

Lua programming ,error in establishing Database connection

1 Answers1