Guest User

Untitled

a guest
Jan 21st, 2019
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. var mysql = require('mysql');
  2. var connection = mysql.createConnection({
  3. host: 'MY_HOST_IP',
  4. database: 'MY_HOST_DB',
  5. user: 'MY_HOST_USR',
  6. password: 'MY_PW'
  7. });
  8. connection.connect(function (err) {
  9. console.log('conecting');
  10. if (err) {
  11. console.error('Error connecting: ' + err.stack);
  12. }
  13.  
  14. console.log('Connected as id ' + connection.threadId);
  15. });
  16. connection.query('SELECT * from accounts', function (error, results, fields) {
  17. if (error) console.log(error);
  18. console.log('account ', results[0]);
  19. });
  20. connection.ping(function (error) { console.log('pingerror'); });
Add Comment
Please, Sign In to add comment