Discussion on: How to get data from an MySQL database in React Native

View post

Replies for: Hi Saulo Joab, when i run this command 'node routes.js', i don't see any data in my browser ??

Hello! Does your Terminal logs any errors? If all you get in the browser is "[]" it means that the query didn't return any values.

Azghour-Saad • Jul 8 '19

i get error like ' Cannot read property 'query' of
undefined', it doesn't know query method when retrieving data from db

Saulo Joab • Jul 9 '19

Are you sure that you installed the mysql module with:
npm install mysql

And imported it into the routes.js file with:

const mysql = require('mysql');

Also, make sure you create the connection with:

const connection = mysql.createPool({
  host     : 'localhost',
  user     : 'me',
  password : 'secret',
  database : 'my_db'
});

Azghour-Saad • Jul 9 '19

I've done it all, the same problem.

Saulo Joab • Jul 9 '19

Huh. That's weird.

Try removing the comma after the database name. If that doesn't work, change mySql to lowercase (mysql). I really don't know what's wrong, maybe something with the npm installation?

Azghour-Saad • Jul 9 '19

Absolutely, this is really weird, I can't figure out this, i'm doing all what you say but he doesn't work, with npm i have this three packages completely.