MySQL Database connection from node js application

In This video I have shown how to connect MySQL database from node js Application.
1. create node project "npm init -y"
2. install mysql package "npm install mysql"
3. create a file like "database.js"
4. import mysql package "const { createPool } = require('mysql')"
5. create pool connection
-----------------------------------------
const pool = createPool({
host: "localhost",
user: "root",
password: "",
database: "test",
connectionLimit: 10
})
6. execute query
---------------------------
pool.query(`select * from registration`, function(err, result, fields) {
if (err) {
return console.log(err);
}
return console.log(result);
})

[@elkhanhamet2561]

Thank you sir. It took me an hour of adjusting with ports to make it work. Thank you for the tutorial.

[@cmtg4471]

This has been the easiest and the best I have watched thank you for this

[@Sac-chan]

Thanks man, you don't know how much i appreciate these kind of tutorials!!

[@vishwajeetpatel297]

thank you very much , it worked . I was struggling to connect it but my struggle ends here ,once again thanks.

[@heyazhar2960]

Very useful for beginners, thanks for making bro ❤️

[@oluwapamilerinsobiyede3846]

Life saver, Spent weeks already

[@parkvince5399]

Very helpful for beginners, Thank you so much

[@riviannews1963]

Thank you for this video, very useful for solving this issue and connecting mysql to node js.

[@mujibulhaquetanim]

simple and to the point. thanks bro.

[@victorivanov6603]

Thank you so much, you deserve more subs!

[@nirajbadaik6796]

thanks for the tutorial.. I have one doubt do we need to end the connection if we are using the pool connection. If yes when do we do that???

[@_aergul__219]

thank you so much sir Was indeed helpful.

[@user-cc1wo9px2u]

very clear and neat description

[@asmit_kr]

Thank u so much, it helped me a lot

[@mr.awexmen815]

thank you very much. this help me very much

[@danyelcesarino7913]

Thanks from Brazil!

[@innovative-thoughts]

Very helpful. Thank you

[@shahriarsblog5775]

Are we able to fetch data from MySQL database in Html table without API. Like in PHP we able to fetch data in HTML table without api using PHP loop. Could we do that same using node?? Or API is compulsory to show data with node js??

[@stantarasenko188]

Thanks for good example

[@rahim3070]

What happened when multiple query executed ? I mean How many connection established to DB Server in multiple query execution ?

[@webdevmaruf]

Thank you!

[@priyankaahire1000]

Thanks ..HELPFUL!!!!!!!!!!!!!!!!!!!

[@jonathanlogin4918]

can you implement sequelize with this rest? thanks

[@bilalroshanTESR]

very helpful thank you

[@tamvanvarokah2102]

thanks dude its so helpful

[@TechnicalBabaji1]

Thank you so much

[@YourHeartFeelings]

Thank you very much sir

[@javiermondragon6918]

Great video, solved my problem

[@vishnug9450]

can you tell me how to store that in a variable

[@jairoverachaly7628]

could you please create an app with NODE + SQL Server? thanks!

[@saifalikhan3356]

Also show us that from where we have to create the database

[@robinjohn988]

Thanks bro

[@11shivamAhir00]

Thank u sir

[@augischadiegils.5109]

Nice

[@mukiibipeter07]

What more can I ask for?
Thanks bro.

[@aadityantr3113]

how do i print the result

[@atharvadeshmukh6328]

thanks!!

[@Sanjay54251]

how you will do though index.hrml file

[@satyambansal728]

how to give data to data base from the website

[@vladosononame6376]

Why you did not show hos to install mysql on localhost?

[@manasiraut7656]

how we display two table or more

[@yarramneediravindraswamy6804]

Hello, In the same way I run the code but it showing something access denied error, could you please give explanation to this please,
E:\procedures_practice_server
ode_modules\mysql\lib\protocol\Parser.js:437
throw err; // Rethrow non-MySQL errors
^
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
at Sequence._packetToError (E:\procedures_practice_server
ode_modules\mysql\lib\protocol\sequences\Sequence.js:47:14)
at Handshake.ErrorPacket (E:\procedures_practice_server
ode_modules\mysql\lib\protocol\sequences\Handshake.js:123:18)
at Protocol._parsePacket (E:\procedures_practice_server
ode_modules\mysql\lib\protocol\Protocol.js:291:23)
at Parser._parsePacket (E:\procedures_practice_server
ode_modules\mysql\lib\protocol\Parser.js:433:10)
at Parser.write (E:\procedures_practice_server
ode_modules\mysql\lib\protocol\Parser.js:43:10)
at Protocol.write (E:\procedures_practice_server
ode_modules\mysql\lib\protocol\Protocol.js:38:16)
at Socket. (E:\procedures_practice_server
ode_modules\mysql\lib\Connection.js:88:28)
at Socket. (E:\procedures_practice_server
ode_modules\mysql\lib\Connection.js:526:10)
at Socket.emit (node:events:513:28)
at addChunk (node:internal/streams/readable:324:12)
--------------------
at Protocol._enqueue (E:\procedures_practice_server
ode_modules\mysql\lib\protocol\Protocol.js:144:48)
at Protocol.handshake (E:\procedures_practice_server
ode_modules\mysql\lib\protocol\Protocol.js:51:23)
at PoolConnection.connect (E:\procedures_practice_server
ode_modules\mysql\lib\Connection.js:116:18)
at Pool.getConnection (E:\procedures_practice_server
ode_modules\mysql\lib\Pool.js:48:16)
at Object. (E:\procedures_practice_server\index.js:15:6)
at Module._compile (node:internal/modules/cjs/loader:1218:14)
at Module._extensions..js (node:internal/modules/cjs/loader:1272:10)
at Module.load (node:internal/modules/cjs/loader:1081:32)
at Module._load (node:internal/modules/cjs/loader:922:12)
at Function.executeUserEntryPoint [as runMain] (node:internal/modules/run_main:81:12) {
code: 'ER_NOT_SUPPORTED_AUTH_MODE',
errno: 1251,
sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client',
sqlState: '08004',
fatal: true
}

[@nidhidwivedi1617]

Really helpful. Thanku so much

[@TechnicalBabaji1]

Thank you so much.😊

[@nielfredtabar8335]

how do i output this on a browser??

[@swetasuryavanshi698]

I am not able to open vs code from command prompt

[@roku1892]

indian guy are smart

[@ABUTAHER-wg7gz]

but how to connect cpanel mysql db?

[@grygi7087]

I typed schema name instead of database name and then it retrieved data

[@SteveMorrow8859]

Uncaught ReferenceError: require is not defined. Why is this happening? Everytime I use require in JavaScript I am stuck with this error.

[@dreamer6911]

MAYBE UR USING "TYPE":"MODULE" IN UR PACKAGE.JSON FILE

[@rachitmathur2986]

ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

[@anshulmanapure1980]

Hey bro, did you find the solution to this?

[@smartyarshad303]

Hello sir,
When I creating database connection it shows depreciation warning
[DEP0095] DeprecationWarning: timers.enroll() is deprecated. Please use setTimeout instead.

[@kishore2398]

How to update
Delete

[@dimitriskosse1727]

[@ruturajkulkarni5928]

The system cannot find the path specified. why am i getting this?

[@virreshwarakham7145]

Similar here , how do u solve it

[@pruthvirajjadhav9322]

Client does not support authentication protocol requested by server; consider upgrading MySQL client : Can someone help?

[@RizwanaS18]

why are we using php if we can get data from mysql

[@Sac-chan]

run VS Code as administrator

[@theraildynasty_]

When I type node .\database.js
It gives me
Code : 'ER_NOT_SUPPORTED_AUTH_MODE',
errno: 1251
sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client',
sqlState: '00004' ,
fatal: true
}

[@sivaramchandersolaimuthu1543]

Try this bro ./database.is

[@sivaramchandersolaimuthu1543]

It should be forward slash

[@saivinaykolla22]

npm install mysql2
and then change mysql to mysql2 in the first line

[@thearjunmishra]

Not working

[@user-ku8ry6wr6k]

this is fakhar

[@user-ku8ry6wr6k]

same here

[@user-ku8ry6wr6k]

ggg

[@sanketmuchhala4372]

chorrrrrrrrrrrr

[@mcaddit6802]

worst

[@mayangan_empire]

I follow your step, and WHY IT DID NOT WORK?!!!!!!!

[@luckyardhika3781]

at Function.Module._load (node:internal/modules/cjs/loader:813:14) {
code: 'PROTOCOL_SEQUENCE_TIMEOUT',
fatal: true,
timeout: 10000
} help me nrother

[@NuNaKri]

Thank you!