


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!

Understanding how JavaScript engine works internally is important to developers because it helps write more efficient code and understand performance bottlenecks and optimization strategies. 1) The engine's workflow includes three stages: parsing, compiling and execution; 2) During the execution process, the engine will perform dynamic optimization, such as inline cache and hidden classes; 3) Best practices include avoiding global variables, optimizing loops, using const and lets, and avoiding excessive use of closures.

Python is more suitable for beginners, with a smooth learning curve and concise syntax; JavaScript is suitable for front-end development, with a steep learning curve and flexible syntax. 1. Python syntax is intuitive and suitable for data science and back-end development. 2. JavaScript is flexible and widely used in front-end and server-side programming.

Python and JavaScript have their own advantages and disadvantages in terms of community, libraries and resources. 1) The Python community is friendly and suitable for beginners, but the front-end development resources are not as rich as JavaScript. 2) Python is powerful in data science and machine learning libraries, while JavaScript is better in front-end development libraries and frameworks. 3) Both have rich learning resources, but Python is suitable for starting with official documents, while JavaScript is better with MDNWebDocs. The choice should be based on project needs and personal interests.

The shift from C/C to JavaScript requires adapting to dynamic typing, garbage collection and asynchronous programming. 1) C/C is a statically typed language that requires manual memory management, while JavaScript is dynamically typed and garbage collection is automatically processed. 2) C/C needs to be compiled into machine code, while JavaScript is an interpreted language. 3) JavaScript introduces concepts such as closures, prototype chains and Promise, which enhances flexibility and asynchronous programming capabilities.

Different JavaScript engines have different effects when parsing and executing JavaScript code, because the implementation principles and optimization strategies of each engine differ. 1. Lexical analysis: convert source code into lexical unit. 2. Grammar analysis: Generate an abstract syntax tree. 3. Optimization and compilation: Generate machine code through the JIT compiler. 4. Execute: Run the machine code. V8 engine optimizes through instant compilation and hidden class, SpiderMonkey uses a type inference system, resulting in different performance performance on the same code.

JavaScript's applications in the real world include server-side programming, mobile application development and Internet of Things control: 1. Server-side programming is realized through Node.js, suitable for high concurrent request processing. 2. Mobile application development is carried out through ReactNative and supports cross-platform deployment. 3. Used for IoT device control through Johnny-Five library, suitable for hardware interaction.

I built a functional multi-tenant SaaS application (an EdTech app) with your everyday tech tool and you can do the same. First, what’s a multi-tenant SaaS application? Multi-tenant SaaS applications let you serve multiple customers from a sing

This article demonstrates frontend integration with a backend secured by Permit, building a functional EdTech SaaS application using Next.js. The frontend fetches user permissions to control UI visibility and ensures API requests adhere to role-base


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

mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

Dreamweaver Mac version
Visual web development tools

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment