Re: Need help connecting luasql to mysql data source

[Jan Schütze <JanS@...>]

Hello Pete,

>> db_conn = assert(env:connect("dbname=fsdb user=fs password='password'"))
>stdin:1: LuaSQL: Error connecting to database. MySQL: Access denied 
for user 'root'@'localhost' (using password: NO)


See the official luasql page [1], it says:
*|env:connect(sourcename[,username[,password[,hostname[,port]]]])|*

so calling this should do the trick:
env:connect("fsdb","fs","password'","192.168.1.104",3306)

Regards,
 Jan (DracoBlue)

[1] http://www.keplerproject.org/luasql/manual.html#mysql_extensions

--

http://dracoblue.net