第一步:新建 node_mysql_test 文件夹
![](https://i-blog.csdnimg.cn/blog_migrate/a8648b4f32ba51a36553902d5a82c1e8.png)
第二步:在node_mysql_test目录下执行命令:cnpm install mysql
2-1:
此时npm会编译node.js连接mysql的环境
![](https://i-blog.csdnimg.cn/blog_migrate/5866cb0608b1d1708e1d73ac8799609d.png)
2-2:
在当前目录编写node.js连接mysql数据库的代码,将文件名命令为 mysql.js
var mysql = require('mysql');
var connection = mysql.createConnection({
host: "127.0.0.1",
user: "root",
password: "root",
port: '3306',
database: 'zfw'
});
connection.connect();
connection.query('select * from zfw_fangattrs',function(error, results, fields){
if(error) throw error;
console.log("这是结果:"+JSON.stringify(results));
for(let index in results) {
console.log(index,results[index]);
};
});
connection.end();
第三步:执行命令:node mysql.js
![](https://i-blog.csdnimg.cn/blog_migrate/c16e6b0b97a79aeeda5886d050a21a93.png)
mysql连接成功