在Heroku服务器上从NodeJS连接到Mysql [英] Connection to Mysql from NodeJS on Heroku server

问题描述

我可以通过Navicat连接到运行在Heroku上的ClearDB Mysql，我甚至可以连接到使用Heroku的ClearDB Mysql。创建了一个名为t_users的表。但我在从Heroku的NodeJs连接时遇到了问题。

这是我的代码，它非常简单：在尝试连接到MySQL之前，一切都能正常工作

web.js：

  var express = require（express）; 
 var app = express（）; 
 app.use（express.logger（））; 
 
 var mysql = require（'mysql'）; 
 var connection = mysql.createConnection（{
 host：'us-cdbr-east-04.cleardb.com'，
 user：''，
 password：''， 
数据库：''
}）; 
 
 connection.connect（）; 
 
 app.get（'/'，function（request，response）{
 response.send（'Hello World !!!! HOLA MUNDOOOOO !!!'）; 
 connection.query（'SELECT 1 + 1 AS solution'，function（err，rows，fields）{
 if（err）throw err; 
 
 response.send（'解决方法是： '，rows [0] .solution）; 
}）; 
}）; 
 
 var port = process.env.PORT || 5000; 
 app.listen（port，function（）{
 console.log（Listening on+ port）; 
}）; 
  

这是我在命令行运行时得到的结果：Heroku config

  C：\wamp\www\Nodejs_MySql_Heroku> heroku config 
 === freeze-wave-8356 Config Vars 
 CLEARDB_DATABASE_URL：mysql：// b32fa719432e40：[e-mail]/heroku_28437b49d76cc53？reconnect = true 
路径：bin：node_modules / .bin：/ usr / local / bin：/ usr / bin：/ bin 
  

这是LOG：
http://d.pr/i/cExL

任何想法我怎么能从NodeJs连接到Heroku上的Mysql ClearDB？
Thanks

解决方案

试试这个。希望这会帮助你

  mysql：// b32fa719432e40：[e-mail]/heroku_28437b49d76cc53 ？reconnect = true 
 
 var connection = mysql.createConnection（{
 host：'us-cdbr-east-04.cleardb.com'，
 user：'b32fa719432e40'， 
密码：'87de815a'，
数据库：'heroku_28437b49d76cc53'
}）; 
  

使用此详细信息并将其连接到mySQL工作台，并导入localhost db

ANy idea how can I connect from NodeJs to the Mysql ClearDB on Heroku?

I was able to connect to the ClearDB Mysql runing on Heroku from Navicat, I even created a table called t_users. But I'm having problems connecting from NodeJs from Heroku.

This is my code, it is very simple: everything works find until it tries to connect to MySQL

web.js:

var express = require("express");
var app = express();
app.use(express.logger());

var mysql      = require('mysql');
var connection = mysql.createConnection({
  host     : 'us-cdbr-east-04.cleardb.com',
  user     : '',
  password : '',
  database : ''
});

connection.connect();

app.get('/', function(request, response) {
  response.send('Hello World!!!! HOLA MUNDOOOOO!!!');
  connection.query('SELECT 1 + 1 AS solution', function(err, rows, fields) {
      if (err) throw err;

      response.send('The solution is: ', rows[0].solution);
    });
});

var port = process.env.PORT || 5000;
app.listen(port, function() {
  console.log("Listening on " + port);
});

This is what I got when I run on the command line: Heroku config

C:\wamp\www\Nodejs_MySql_Heroku>heroku config
=== frozen-wave-8356 Config Vars
CLEARDB_DATABASE_URL: mysql://b32fa719432e40:[e-mail]/heroku_28437b49d76cc53?reconnect=true
PATH:                 bin:node_modules/.bin:/usr/local/bin:/usr/bin:/bin

This is the LOG: http://d.pr/i/cExL

ANy idea how can I connect from NodeJs to the Mysql ClearDB on Heroku? Thanks

解决方案

Try this. Hope this will help you

mysql://b32fa719432e40:[e-mail]/heroku_28437b49d76cc53?reconnect=true

var connection = mysql.createConnection({
  host     : 'us-cdbr-east-04.cleardb.com',
  user     : 'b32fa719432e40',
  password : '87de815a',
  database : 'heroku_28437b49d76cc53'
});

Use this details and connect it in mySQL work bench, and import your localhost db

这篇关于在Heroku服务器上从NodeJS连接到Mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！