Need help connecting luasql to mysql data source
[
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: 2008年5月12日 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