Need help connecting luasql to mysql data source

["Pete Kay" <petedao@...>]

Hi,

ser:/usr/local/etc# lua
Lua 5.1.3  Copyright (C) 1994-2008 Lua.org, PUC-Rio
> require "luasql.mysql"
> env = assert(luasql.mysql())
> 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)
stack traceback:
    [C]: in function 'assert'
    stdin:1: in main chunk
    [C]: ?
> 


Here is my data source:

ser:/usr/local/etc# cat odbc.ini
[fsdb]
Driver=MySQL
SERVER=192.168.1.104
PORT=3306
DATABASE=fs
Socket = /var/run/mysqld/mysqld.sock
ser:/usr/local/etc# 


My server's ip is 192.168.1.103  and db's ip is 192.168.1.104

Any help will be greatly appreciated.

Thanks,
Pete