如何使用nodejs服务器连接OpenShift PhpMyAdmin数据库

Question

如何使用nodejs服务器连接" openshift phpmyadmin数据库" 以下是我的代码...我没有从数据库中得到结果...

日志： 成功{" fieldCount"：0，" aventedrows"：0，" intertid"：0，" serverstatus"：2，warningco unt"：0，"消息"："，" protocol41"：true，" changerows"：0}

 var connection = mysql.createConnection({
    OPENSHIFT_NAMMAOORU_DB_HOST :'127.4.188.2',
    OPENSHIFT_NAMMAOORU_DB_PORT :'3306',
    OPENSHIFT_NAMMAOORU_DB_USERNAME:'adminfxxxxx',
    OPENSHIFT_NAMMAOORU_DB_PASSWORD:'xxxxxxxxx',
    OPENSHIFT_NAMMAOORU_DB_URL:'mysql://adminxxxx:xxxxxxx@127.4.188.2:3306',

    //database:'nammaooru'

    });

    connection.connect(function(err,success){
      if (err) {
        throw err;
      console.log("Error"+JSON.strinerr);
      }
      else
      {
        console.log("Success"+JSON.stringify(success));
      }
    });
app.get('/city',function(req,res){
try{

  //var id = req.query.id;
/*var t=req.query.id;
console.log(t);
*/  /*  var data = {
        "error":1,
        "Books":""
    };*/

    console.log(req.params.cityid);
    var t=1;
    connection.query("SELECT * from city",function(err, rows, fields){
console.log("success"+JSON.stringify(rows));
//console.log("success"+JSON.stringify(fields));
//console.log(JSON.stringify(rows));
res.send(JSON.stringify(err));
//console.log("success"+JSON.stringify(err));
    });
}
catch(e)
{
console.log(e); 
}
});

本地休息URL http：//localhost：8000/city

{代码：" er_no_db_error"，errno：1046，sqlstate：" 3d000"，index：0}

Answer 1

我认为您没有正确创建MySQL连接：

var connection = mysql.createConnection({
    host: '127.4.188.2',
    user: 'adminfxxxxx'',
    password: 'xxxxxxxxx',
    port: 3306
});

Answer 2

尝试一下，只需添加数据库名称

var connection = mysql.createconnection（{

）

host :'127.4.188.2',
port :'3306', // if this doesn't work try removing port once
user:'adminfxxxxx',
password:'xxxxxxxxx',
database:'xxxxxxxxx', //specify database Name