[Date Prev][Date Next][Thread Prev][Thread Next]
[Date Index]
[Thread Index]
- Subject: Need help connecting luasql to mysql data source
- From: "Pete Kay" <petedao@...>
- Date: Mon, 12 May 2008 10:32:09 +0800
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