我是 AWS 的新手,请您帮助我。
正在遵循本教程:输入教程链接
创建了一个 RDS 并在 Visual Studio 代码中运行了以下代码:
文件名:测试.js
var mysql = require('mysql');
var config = require('./config.json');
var pool = mysql.createPool({
host : config.dbhost,
user : config.dbuser,
password : config.dbpassword,
database : config.dbname
});
pool.getConnection(function(err, connection) {
// Use the connection
connection.query('SELECT emp_name from Employee where emp_id=1', function (error, results, fields) {
// And done with the connection.
connection.release();
// Handle error after the release.
if (err) throw error;
else console.log(results[0].emp_name);
process.exit();
});
});
但是,当我运行节点测试时.js , 它返回了以下错误。
(base( zi-jies-mbp:sql zijie$ node test.js/Users/zijie/node_modules/mysql/lib/protocol/Parser.js:437 投掷错误;重新抛出非 MySQL 错误 ^
类型错误:无法读取未定义的属性"查询" at/Users/zijie/Documents/I&E/Silverride/sql/test.js:11:14 at Handshake.onConnect (/Users/zijie/node_modules/mysql/lib/Pool.js:58:9( 握手。(/Users/zijie/node_modules/mysql/lib/Connection.js:525:10( at Handshake._callback (/Users/zijie/node_modules/mysql/lib/Connection.js:491:16( at Handshake.Sequence.end (/Users/zijie/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24( at Handshake.ErrorPacket (/Users/zijie/node_modules/mysql/lib/protocol/sequences/Handshake.js:125:8( at Protocol._parsePacket (/Users/zijie/node_modules/mysql/lib/protocol/Protocol.js:291:23( at Parser._parsePacket (/Users/zijie/node_modules/mysql/lib/protocol/Parser.js:433:10( at Parser.write (/Users/zijie/node_modules/mysql/lib/protocol/Parser.js:43:10( at Protocol.write (/Users/zijie/node_modules/mysql/lib/protocol/Protocol.js:38:16(
请您分享并建议我错误是什么,以及如何补救? 提前谢谢。
根据您的错误
类型错误: 无法读取未定义的属性"查询">
似乎未创建连接对象。这可能是由于
诸如- 您没有为连接传递正确的参数
- RDS 安全组不允许连接(这似乎是使用该教程的多个人面临的问题:检查评论(