How to use the createConnection function from mysql2

mysql.test.js

GitHub: elastic/apm-agent-nodejs

435
436
437
438
439
440
441
442
443
444
    queryablePromise.end()
    queryablePromise = undefined
  }
}

queryable = mysql.createConnection(connectionOptions)
queryable.connect()

mysqlPromise.createConnection(connectionOptions).then(connection => {
  queryablePromise = connection

211

536

296

+ 3 other calls in file

Server.js

GitHub: pdpatel13/Software-Team12

315
316
317
318
319
320
321
322
323
324
325
*/
}


//setting up mySQL database, still needs work
//from lec8 REST server example slides
const dbCon = mysql.createConnection(
    {
        host:"localhost",
        user: "root",
        password: "passwd" //change this to the password for your mysql root account

1

3

4

+ 3 other calls in file

database.js

GitHub: SvinDzjuba/Shpilly-Willy

0
1
2
3
4
5
6
7
8
9
10
const { Sequelize } = require('sequelize');
const mysql = require('mysql2');


module.exports.createDb = async function createDb() {
    // Create connection to MySQL
    const connection = mysql.createConnection({
        host: 'localhost',
        user: 'root',
        password: ''
    });

0

2

2

database.js

GitHub: bull28/Brawl-Stars-Database

32
33
34
35
36
37
38
39
40
41
42
43
    tableNames.trades = process.env.DATABASE_TRADE_TABLE_NAME;
} if (typeof process.env.DATABASE_COSMETIC_TABLE_NAME != "undefined"){
    tableNames.cosmetics = process.env.DATABASE_COSMETIC_TABLE_NAME;
}


const connection = mysql2.createConnection(databaseLogin);


// Having a variable which checks whether the connection is successful
// instead of throwing an error when trying to connect allows the app
// to continue running even if the connection was unsuccessful. Other

0

2

1

+ 14 other calls in file

user.js

GitHub: Leotheprodu/flproductions-server

-1

0

1

1

+ 3 other calls in file

server.js

GitHub: MingJ116/IntelliMJ

7
8
9
10
11
12
13
14
15
16
17
18
const app = express();
app.use(cors()); // CORS(교차 출처 리소스 공유)를 사용 설정하여 다른 도메인의 요청을 허용합니다.
app.use(bodyParser.json());// 수신 요청에 대해 JSON 본문 구문 분석 활성화




const connection = mysql.createConnection({ // 제공된 연결 정보로 MySQL 연결을 설정합니다.
    host: 'mj-fp-db.c2ghfqx8jn0l.ap-northeast-2.rds.amazonaws.com', // AWS RDS endpoint
    user: 'mjade0116', // AWS RDS username
    password: 'rainstorm116', // AWS RDS password
    database: 'MJ_FP', // MySQL database name

0

1

0

bookstore-endpoints.js

GitHub: Karcoolka/Academy-Exercises-Reposiotry

2
3
4
5
6
7
8
9
10
11
12
13
const { query } = require('express');
const app = express();
const PORT = 8080;




let conn = mysql.createConnection({
  host: 'localhost',
  user: 'gfa',
  database: 'bookstore',
});

0

1

1

+ 3 other calls in file

MR-app.js

GitHub: Karcoolka/Academy-Exercises-Reposiotry

3
4
5
6
7
8
9
10
11
12
13
14
15




const express = require("express");
const sql = require("mysql2");


const connection = sql.createConnection({
    host: 'localhost', //database running on a localhost
    user: 'gfa',
    database: 'reddit',
  }

0

1

1

+ 3 other calls in file

projects.js

GitHub: TrongNhannn/DIPE

3
4
5
6
7
8
9
10
11
12
const { mysql } = require('../Connect/conect');
const { id } = require('../module/modulars');
const { TablesController } = require('../controller/tables-controller');
const e = require('express');
const moment = require('moment');
const connection = mysqla.createConnection({
    host: 'localhost',
    user: 'nhan',
    password: 'root',
    database: 'dipe'

0

0

1

+ 4 other calls in file

index.js

GitHub: khanna-harshit/LabReservationBackend

8
9
10
11
12
13
14
15
16
17
18
const mysql = require('mysql2');
const { check } = require("express-validator");
app.use(cors());
app.use(bodyparser.json());


const db = mysql.createConnection({
	host: 'localhost',
	user: 'root',
	password: '',
	database:'labreservationsystem',

0

0

1

+ 4 other calls in file

om-modi-work.js

GitHub: Om-modi/esparkbiz_work

15
16
17
18
19
20
21
22
23
24
25
26
app.use(body.urlencoded({ extended: false }))
let bcrypt = require('bcryptjs');


app.use(express.static('assets'))


var con = mysql.createConnection({
    host: "localhost",
    user: 'root',
    password: 'root',
    database: 'job_application_db'

0

0

1

+ 14 other calls in file

dbop.js

GitHub: undefined1raven/Ring-Relay-API-Prod

-1

0

0

1

+ 9 other calls in file

api.js

GitHub: JLoGukA/musicVoteApi

7
8
9
10
11
12
13
14
15
16
17
18


const app = express();
app.use(cors());
app.use(express.json());


const con = mysql.createConnection({
    host: 'localhost',
    port: "3306",
    user: "root",
    password: "0000",  

0

0

1

+ 9 other calls in file

index.js

GitHub: AjarnDang/spa-api

20
21
22
23
24
25
26
27
28
29
30
31
// ให้อนุญาตหรือไม่อนุญาต ร้องขอทรัพยากรใดๆ ในหน้า Web ที่ถูกเรียกจาก Domain อื่น
// ที่ไม่ใช่ Domain ที่หน้า Web นั้นอยู่
app.use(express.json());
app.use(cors());


const db = mysql2.createConnection(process.env.DATABASE_URL);


app.get("/", (req, res) => {
    res.json("This is server-side. AKA Backend")
})

0

0

1

+ 9 other calls in file

connection.js

GitHub: skmamunkhan072/MySql_filtaration_category_Company_Task_Server

-2

0

0

1

+ 5 other calls in file

db.js

GitHub: Odko19/mtc_admin_panel

-2

0

0

1

+ 3 other calls in file

index.js

GitHub: Michael-she/CarpoolCoordinator

25
26
27
28
29
30
31
32
33
34
35
36
37
38


//DATABASE modules and other declarations


require('dotenv').config();
const mysql = require('mysql2');
const connection = mysql.createConnection(process.env.DATABASE_URL); //gets the url of the database, allowing the connection to be made


connection.connect() //initialises connection to the PlanetScale API.


//Stuff for decoding JSON

0

0

0

index.js

GitHub: AjarnDang/spa-api

16
17
18
19
20
21
22
23
24
25
26
27
// ให้อนุญาตหรือไม่อนุญาต ร้องขอทรัพยากรใดๆ ในหน้า Web ที่ถูกเรียกจาก Domain อื่น
// ที่ไม่ใช่ Domain ที่หน้า Web นั้นอยู่
app.use(express.json());
app.use(cors());


const db = mysql2.createConnection(process.env.DATABASE_URL)


app.get("/", (req, res) => {
    res.json("This is server-side. AKA Backend")
})

0

0

1

+ 4 other calls in file

projects.js

GitHub: TrongNhannn/DIPE

3
4
5
6
7
8
9
10
11
12
const { mysql } = require('../Connect/conect');
const { id } = require('../module/modulars');
const { TablesController } = require('../controller/tables-controller');
const e = require('express');
const moment = require('moment');
var connection = mysqla.createConnection({
    host: process.env.DB_HOST,
    user: process.env.DB_USER,
    password: process.env.DB_PASSWORD,
    database: process.env.DB_NAME

0

0

1

+ 4 other calls in file

index.js

GitHub: Smulchman/employee-tracker

-1

0

0

1

+ 4 other calls in file