Re: Need help connecting luasql to mysql data source

["Peter Cawley" <lua@...>]

Looks like you were using an ODBC type syntax, and thus would need
luasql.odbc. If you use luasql.mysql directly, then you'll need the
syntax given by Jan above.

2008/5/12 Jan Schütze <JanS@dracoblue.de>:
> 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
>
>