How to Connect Node js to MySQL Database and Fetch Data in 5 minutes

[@LinXiaoChaun]

At [02:39], I was at first thrown off by the destructuring syntax
const {createPool}=require('mysql');
const pool = createPool( { … } ) ;
An equivalent (more pedestrian) alternative would be something like:
const mysql = require('mysql') ;
const pool = mysql.createPool( { …} )

[@MsamerieJohnson]

For those getting undefined, I used this code to connect to the database
const mysql = require("mysql")
//Create a Database Connection
const con = mysql.createConnection({
host:'localhost',
user:'root',
password:'your_password',
database:'your_databse'
})
con.connect((err) => {
if(err)
{
console.log(err)
}else{
console.log("CONNECTION SUCCESSFUL!")
}
})
// Get The Data From The Table
con.query('select * from your_table', (err, res) =>{
return console.log(res)
})

[@micaelstaubli7653]

you are the best Bro :) thanks

[@תמרנידאם]

תותח אלוףףףףףף
ההסבר ממש מעולה ועוזר
תודה!🙏

[@nerolifong1824]

short video and to the point. great job

[@williamdevonshire356]

awesome. finally i can connect the two!!! woo yea!!! Thank you sir :)

[@phantomak3r477]

Quick and straight to the point.

[@DiscussedFir6]

Thank you so much for this, great tutorial!

[@KindsonTheTechPro]

Glad it was helpful!

[@Sukubus666]

For me it keeps saying 'undefined'. 😭 Could you help out how to fix that issue? I have node.js installed and triple checked if my code looks the same like in video.. 😕

[@axsd1489]

Thanks for help

[@KindsonTheTechPro]

Always welcome

[@Sami_Ljimari]

very useful, thank you for making the video

[@KindsonTheTechPro]

You're welcome 😊

[@rinkijain4517]

Greate sir

[@bryantgarcia998]

Really useful video. By any chance, do you have a follow up video on how to post data to mysql work bench in javascript as well?

[@michelsolis6603]

Thanks! And then? When you want to upload proyect to prod? What do I have to do to hide this information?

[@realhistory765]

Thank you bro ❤

[@CorreaLobo]

Hello Brother! Excellent Video, You just got a sub thank you so much. So simple and understandable. TY ❤❤

[@dimitriskosse1727]

thank you bro

[@assetdev1859]

hey! great video. i have a question, if i want to deploy this website on vercel/heroku what I need to do? our sql data base located in localhost how correctly i understand so can we push it somewhere? something like cloud storage? thanks for the answer :3

[@nimeshpatilvlogs8629]

Do we have to first create table insql

[@wildriftgames1931]

why didn't work on my visual studio code when I'll run in terminal? Pls. help!!

[@_dejvy]

really good tutorial, just one question, how can i default select database name

[@SITPonrajA]

Hey I have a error on require() function

[@forester1]

Can we query same like php api ?

[@yourmoveatheists]

🐐 Thank you!

[@Maumau369]

is require not defined anymore? i get "ReferenceError: require is not defined"

[@VarshaSivaramakrishnan]

i applied your code but it just displays undefined what do i do?

[@goodluckoriuwa1669]

Can uou show how to connect node express app to online MySQL database

[@Dlo2018]

how do i create a node module?

[@leonbou3959]

Hi, i want to store the return of the query in a variable. how can i make that work? When i write const x = (query) and instead of return console.log() just returning the res. It doesn't gave me back the result. Can anyone help me how to get the res returned to store it in a variable?

[@LinXiaoChaun]

In your code, before the call to pool.query, create a variable, say, foo, then assign it the value of res within the function body:
var foo=[] ; pool.query( 'SELECT * FROM apidb.users', (err,res)=>{foo=Array.from(res)} ) ;
The value of foo will now be the result of the mysql query.
To confirm that this code is working, run node in your shell, entering REPL mode, then give it the REPL command '.load database.js'. Node will echo the content of the file database.js followed by the result of running that file.
You will remain in REPL mode: you can give the REPL command "foo", and node will echo its value.
End the session by typing

[@sh44ko58]

@@LinXiaoChaun Why is it not working for me ? Btw i ive coded also something with react so dont be confused ;D
const pool = createPool({
host: "localhost",
user: "root",
password: ""
})
var foo = []
pool.query(`SELECT * FROM appclone.user`, (err, res) => {foo=Array.from(res)} )
res.json({"users": [foo] })
Could you help me ?

[@mukkt]

For anyone getting an authentication error:
"npm install mysql2" then change the require statement to "mysql2"

[@saivinaykolla22]

thank u bro

[@forester1]

Greate

[@jasonmiller1076]

mine said undefined

[@unspoken2409]

same

[@kashish9220]

"undefined" occur as output of node database.js
please help regarding this

[@saadbinwasi3038]

same did you find solution?

[@nirmalgaur3228]

Maybe your password is not "rootuser".

[@timhoward5]

@@nirmalgaur3228 Nope, because mines did the same thing and I used my password.

[@mikahoy]

It occurs because you haven't select the database where the table reside

[@Pan_Jan_Wroclawski]

try to use mysql2 instead of mysql package

[@Aman22506]

can this apply in phpmyadmin

[@joeyGunz1-w1r]

I am getting a 504 error when sending data to mysql in nginx

[@koggism]

video is blured

[@KindsonTheTechPro]

I guess it is playing in lower resolution in your system, you need to play in a higher resolution

[@rezaeiabazar5324]

ok