node：0.6.17

mysql：5.5.21

os：lion 10.7.3

var
  //sys = require('sys'),
  mysql = require('/Users/mackjoner/tech/nodejs/node_modules/mysql-libmysqlclient'),
  conn,
  result,
  row,
  rows;

var
  host = "localhost",
  user = "test",
  password = "password",
  database = "db",
  test_table = "users";

conn = mysql.createConnectionSync();
conn.connectSync(host, user, password, database);

//sys.puts("Information:");
//sys.puts(sys.inspect(conn.getInfoSync()) + "\n");

if (!conn.connectedSync()) {
  //sys.puts("Connection error " + conn.connectErrno + ": " + conn.connectError);
  console.log("Connection error " + conn.connectErrno + ": " + conn.connectError);
  process.exit(1);
}

conn.query("SELECT * FROM " + test_table + ";", function (err, res) {
  if (err) {
    throw err;
  }
  
  res.fetchAll(function (err, rows) {
    if (err) {
      throw err;
    }
    
    //sys.puts("Rows in table '" + database + "." + test_table + "':");
    //sys.puts(sys.inspect(rows));
    console.log("Rows in table '" + database + "." + test_table + "':");
    
    // This isn't necessary since v1.2.0
    // See https://github.com/Sannis/node-mysql-libmysqlclient/issues#issue/60
    //res.freeSync();
  });
});

process.on('exit', function () {
  conn.closeSync();
});

提示信息

dyld: lazy symbol binding failed: Symbol not found: _mysql_init
  Referenced from: /Users/yangzhaojie/tech/nodejs/node_modules/mysql-libmysqlclient/build/Release/mysql_bindings.node
  Expected in: flat namespace

dyld: Symbol not found: _mysql_init
  Referenced from: /Users/yangzhaojie/tech/nodejs/node_modules/mysql-libmysqlclient/build/Release/mysql_bindings.node
  Expected in: flat namespace