MySQL/NodeJS problem

Help and Feedback Scripting Support
#1

Sup, so first, I want to achieve a simple thing, select a database using the “USE” command and then check if the database is selected with “SELECT DATABASE() FROM DUAL;” command.

The issue is that it does not select, and when I try to execute any query related to the database it says “400, No database selected”

image
image1231×240 50.5 KB

Here is the output: (Ignore that “undefined” after the OkPacket since it’s because USE only returns 1 argument)

image
image470×587 32.2 KB

See that “null”, it’s because no database is selected.

Until now, I did not find any solution.

#2

Interesting, have you succeed to define the database yet?

1 Like
#3

Yes, the database is fully operational, works fine with phpMyAdmin and also works fine using the console itself to execute the commands that are shown in the script

#4

That’s really weird Imma look up what’s wrong can you send the connection script?

1 Like
#5

The connection itself is the mysql Pool, outside from that there is nothing, I mean nothing uses the connection except the one I sent. And Session is just a class, if you want I can explain what it is.
image

That is when the connection is created, those values are the normal ones, port is the default, and the other ones are credentials.

#6

I forgot to mention, MySQL is the library “mysql” from npm

#7

image
This is me trying those commands in console

#8

Wait wait I got something, at least something different, so I did it so as soon as the connection is created it tries to use the database,
image

The other use still returns null tho, idk why and the error still happens

#9

image
image1174×78 20.6 KB

Its the same exact code, idk why the other one dosent work tho

#10

Wait wait, the newSession.connection doesn’t work (newSession being the same as the “Session” you saw in the first pic)
image

I think I know what’s the problem, I will later tell if it works or not

Code:

image
image844×72 17.4 KB

#11

YESSS, the solution.

So really important, the “mysql.createPool” function returns a pool, normally you would use this pool for doing the query, since well it looks the same as the other one I am going to mention BUT THEY ARE NOT, the connection you actually want to use is the one that is given to you after you create the Pool, this one:
image

Using the normal pool won’t work even tho it looks like it should.

#12

I dont think you need the ; in the database name

#13

I mean you don’t need it, but I like to add it since it doesn’t change anything. But yes I did test to see if that was the problem, it was not