使用node.js连接mysql数据库,提示dyld: Symbol not found: _mysql_init - CNode技术社区

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

markup

配置环境变量

export DYLD_LIBRARY_PATH=/usr/local/mysql/lib/

搜了一下, 很多人都碰上这个问题啊, 共同点是: MacOS X 系统上安装MySQL

一下为原文: 大概意思是,你可能装了跟CPU的bit不一致的MySQL版本. 比如你的Mac是64-bit的,你却装了一个32-bit的MySQL... 希望能给你一点帮助... Hi,

Sorry to hear you’re having troubles, but from a quick google it seems like you’re not the only one: http://www.perlmonks.org/?node_id=793727 http://stackoverflow.com/questions/13342...ow-leopard

The general problem seems to be a 32-bit / 64-bit mismatch between MySQL and Perl...

Okay, as you’re installing the 10.6 package of MySQL i’m guessing you’re on Snow Leopard? Does your mac have a 64-bit processor in it (see here for details)?

Then, once you have established whether you should be running 32-bit or 64-bit code (match to your processor), completely remove MySQL from your system, install the appropriate one (I’m guessing you’ll probably need the 64-bit one), then reinstall DBD::MySQL.

Let me know how you get on.

原文在此

StackOverflow 上也有这个讨论

是的,问题就是这个mysql32和64的区别,要和cpu对应。 设置环境变量是 Error: Unable to load shared library 解决这个错误

人类已经无法阻止cnodejs被XSS了!

这个是因为mysql需要的一些库没有在正确的位置, 一楼给的方案可以解决该问题, 最完美的方案是将需要的库安装到指定位置