Web Front-end
JS Tutorial
About Node using Sequlize to connect Mysql error: Access denied for user 'xxx'@'localhost'_node.js
About Node using Sequlize to connect Mysql error: Access denied for user 'xxx'@'localhost'_node.js
This article mainly introduces to you the relevant information about Node using Sequlize to connect Mysql error: Access denied for user 'xxx'@'localhost'. The article introduces it in detail through sample code. Friends who need it can refer to it. The following is Come and learn with the editor, I hope it can help everyone.
Preface
I recently encountered a problem at work. The problem is as follows:
Unhandled rejection SequelizeAccessDeniedError: Access denied for user 'lupeng'@'localhost' (using password: YES)
This is an error reported by Node when using Sequlize to connect to Mysql data. The key is to look at the error after the colon. : Access denied. The key is the access denied error, which means there is a problem with the database connection. The database connection access is denied, either because there is no corresponding operation permission, or the account password is wrong.
This locates the problem on two points: access permissions and incorrect account and password. Don’t forget to look for problems in other aspects, as that will only be a waste of time.
1. User permission issues
Permission issues start with the database. After confirming user authorization, whether to refresh the permission list. That is to say, after using the Grant command to authorize a user, you should use the flush privileges command. This is an issue that many people ignore.
If there is no problem with user authorization, try restarting the mysql server. Use the command /etc/init.d/mysql restart to restart the mysql server. The restart command may be different in different Linux versions. I am using the Debain system here.
If the problem is not solved after restarting, then it may not be a problem with the database user permissions.
2. Account password issue
The account password is incorrect. This question sounds ridiculous, but during the development process, many people will ignore it. Why do you say that? I use the config-lite module to configure database parameters, because I switch development in multiple system environments. Using the config-lite module can load different parameter files through simple environment variable configuration. For specific usage, please refer to: Configuration file usage in different environments.
My problem arises here. Open a terminal and run the project npm run test. The test running script is configured in the package.json file NODE_ENV=test supervisor --harmony -i views/ ./bin/www . Open another terminal and run the database synchronization command. The synchronization command is written separately in a js script. The data connection method (general) is quoted in the script. The connection method is as follows:
var Sequelize = require('sequelize');
// 引入数据库配置文件
var sqlConfig = require('config-lite')(__dirname).mysql;
var sequelize = new Sequelize(sqlConfig.database, sqlConfig.user, sqlConfig.password, {
host: sqlConfig.host,
dialect: 'mysql',
pool: {
max: 10,
min: 0,
idle: 10000
}
});
module.exports = sequelize;So in synchronizing the database Sometimes, the error is always reported as the title, but I think it is correct. After a final check, I found the problem: the NODE_ENV environment variable in the test script is only valid in the current terminal. If you want to open another terminal to synchronize the database, you need to Set the environment variables in a separate terminal. Otherwise, the loaded database parameters will be inconsistent, which means that the username and password used to connect to the database are incorrect.
Related recommendations:
Solution to PHP connection MySQL error: Fatal error: Call to undefined function mysql_connect()
Solution to the error "No such file or directory" reported when PHP connects to MySQL under Mac
The error message "No such file or directory" reported when PHP connects to mysql
The above is the detailed content of About Node using Sequlize to connect Mysql error: Access denied for user 'xxx'@'localhost'_node.js. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1381
52
How to implement an online speech recognition system using WebSocket and JavaScript
Dec 17, 2023 pm 02:54 PM
How to use WebSocket and JavaScript to implement an online speech recognition system Introduction: With the continuous development of technology, speech recognition technology has become an important part of the field of artificial intelligence. The online speech recognition system based on WebSocket and JavaScript has the characteristics of low latency, real-time and cross-platform, and has become a widely used solution. This article will introduce how to use WebSocket and JavaScript to implement an online speech recognition system.
WebSocket and JavaScript: key technologies for implementing real-time monitoring systems
Dec 17, 2023 pm 05:30 PM
WebSocket and JavaScript: Key technologies for realizing real-time monitoring systems Introduction: With the rapid development of Internet technology, real-time monitoring systems have been widely used in various fields. One of the key technologies to achieve real-time monitoring is the combination of WebSocket and JavaScript. This article will introduce the application of WebSocket and JavaScript in real-time monitoring systems, give code examples, and explain their implementation principles in detail. 1. WebSocket technology
How to use JavaScript and WebSocket to implement a real-time online ordering system
Dec 17, 2023 pm 12:09 PM
Introduction to how to use JavaScript and WebSocket to implement a real-time online ordering system: With the popularity of the Internet and the advancement of technology, more and more restaurants have begun to provide online ordering services. In order to implement a real-time online ordering system, we can use JavaScript and WebSocket technology. WebSocket is a full-duplex communication protocol based on the TCP protocol, which can realize real-time two-way communication between the client and the server. In the real-time online ordering system, when the user selects dishes and places an order
How to implement an online reservation system using WebSocket and JavaScript
Dec 17, 2023 am 09:39 AM
How to use WebSocket and JavaScript to implement an online reservation system. In today's digital era, more and more businesses and services need to provide online reservation functions. It is crucial to implement an efficient and real-time online reservation system. This article will introduce how to use WebSocket and JavaScript to implement an online reservation system, and provide specific code examples. 1. What is WebSocket? WebSocket is a full-duplex method on a single TCP connection.
Pi Node Teaching: What is a Pi Node? How to install and set up Pi Node?
Mar 05, 2025 pm 05:57 PM
Detailed explanation and installation guide for PiNetwork nodes This article will introduce the PiNetwork ecosystem in detail - Pi nodes, a key role in the PiNetwork ecosystem, and provide complete steps for installation and configuration. After the launch of the PiNetwork blockchain test network, Pi nodes have become an important part of many pioneers actively participating in the testing, preparing for the upcoming main network release. If you don’t know PiNetwork yet, please refer to what is Picoin? What is the price for listing? Pi usage, mining and security analysis. What is PiNetwork? The PiNetwork project started in 2019 and owns its exclusive cryptocurrency Pi Coin. The project aims to create a one that everyone can participate
JavaScript and WebSocket: Building an efficient real-time weather forecasting system
Dec 17, 2023 pm 05:13 PM
JavaScript and WebSocket: Building an efficient real-time weather forecast system Introduction: Today, the accuracy of weather forecasts is of great significance to daily life and decision-making. As technology develops, we can provide more accurate and reliable weather forecasts by obtaining weather data in real time. In this article, we will learn how to use JavaScript and WebSocket technology to build an efficient real-time weather forecast system. This article will demonstrate the implementation process through specific code examples. We
Simple JavaScript Tutorial: How to Get HTTP Status Code
Jan 05, 2024 pm 06:08 PM
JavaScript tutorial: How to get HTTP status code, specific code examples are required. Preface: In web development, data interaction with the server is often involved. When communicating with the server, we often need to obtain the returned HTTP status code to determine whether the operation is successful, and perform corresponding processing based on different status codes. This article will teach you how to use JavaScript to obtain HTTP status codes and provide some practical code examples. Using XMLHttpRequest
How to use insertBefore in javascript
Nov 24, 2023 am 11:56 AM
Usage: In JavaScript, the insertBefore() method is used to insert a new node in the DOM tree. This method requires two parameters: the new node to be inserted and the reference node (that is, the node where the new node will be inserted).
