Failed to connect to the database

Connect to the database in the framework automatically generated by express

connect.js Code

const mysql = require("mysql");

const db = mysql.createConnection({
  host: "localhost",
  port: 3306,
  user: "root",
  database: "ningxia"
})

db.connect((error) => {
  if (error) {
    console.log(error)
    console.log("")
  } else {
    console.log("")
  }
})

module.exports = db

introduce the connect.js file into the Index.js of api, and the small blackboard indicates that the connection failed

Express mysql

Jun.17,2022

Does the

database have a password?

should be port number 3306 is occupied, another MySQL is opened and another wampserver, port is occupied. After I turn off wampserver, I can link successfully

Previous: How can golang sql get rid of the problem that the parameters of Scan must correspond to the columns returned by the query?

Next: Z-index is invalid when canvas width is greater than parent width

Why is the Sequelize calendar time zone random?
as shown in the figure, every time I create data, it returns at a strange time adding this has no effect timezone: +08:00 ...

Vue.js express mysql node.js sequelize

Feb.28,2021
The use of express-mysql in
var a = "12714 " select * from table where id in ${a} Why does this sql return only one piece of data for advice ...

Express mysql node.js

Mar.03,2021
Sequelizejs's control of transactions, do you have any good suggestions for encapsulation?
use sequelizejs to control mysql transactions. How to encapsulate or design transactions across methods and service? The framework of application is express + sequelizejs,. In the service layer, it often appears in one method to call other service met...

Express mysql node.js javascript

Apr.05,2021
Failed to connect to the database
Connect to the database in the framework automatically generated by express connect.js Code const mysql = require( mysql ); const db = mysql.createConnection({ host: localhost , port: 3306, user: root , database: ningxia }) d...

Express mysql

Jun.18,2022

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e84b90-cff.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e84b90-cff.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?