ER_ACCESS_DENIED_ERROR:对用户"@'localhost"的访问被拒绝(使用密码:NO) [英] ER_ACCESS_DENIED_ERROR: Access denied for user ''@'localhost' (using password: NO)
本文介绍了ER_ACCESS_DENIED_ERROR:对用户"@'localhost"的访问被拒绝(使用密码:NO)的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有这个问题,我已经研究过了,但无法解决,我想它与数据库权限有关,但是我无法解决它:
I have this problem, I already researched and I could not solve it, I imagine it has something to do with database permissions, but I can not fix it:
if (error) throw error;
^
Error: ER_ACCESS_DENIED_ERROR: Access denied for user ''@'localhost' (using password: NO)
at Handshake.Sequence._packetToError (/home/carlos/www/express-cc/node_modules/mysql/lib/protocol/sequences/Sequence.js:52:14)
at Handshake.ErrorPacket (/home/carlos/www/express-cc/node_modules/mysql/lib/protocol/sequences/Handshake.js:103:18)
at Protocol._parsePacket (/home/carlos/www/express-cc/node_modules/mysql/lib/protocol/Protocol.js:279:23)
at Parser.write (/home/carlos/www/express-cc/node_modules/mysql/lib/protocol/Parser.js:76:12)
at Protocol.write (/home/carlos/www/express-cc/node_modules/mysql/lib/protocol/Protocol.js:39:16)
at Socket.<anonymous> (/home/carlos/www/express-cc/node_modules/mysql/lib/Connection.js:103:28)
at emitOne (events.js:115:13)
at Socket.emit (events.js:210:7)
at addChunk (_stream_readable.js:266:12)
at readableAddChunk (_stream_readable.js:253:11)
--------------------
at Protocol._enqueue (/home/carlos/www/express-cc/node_modules/mysql/lib/protocol/Protocol.js:145:48)
at Protocol.handshake (/home/carlos/www/express-cc/node_modules/mysql/lib/protocol/Protocol.js:52:23)
at Connection.connect (/home/carlos/www/express-
cc/node_modules/mysql/lib/Connection.js:130:18)
at Object.<anonymous> (/home/carlos/www/express-cc/db.js:10:12)
at Module._compile (module.js:573:30)
at Object.Module._extensions..js (module.js:584:10)
at Module.load (module.js:507:32)
at tryModuleLoad (module.js:470:12)
at Function.Module._load (module.js:462:3)
at Module.require (module.js:517:17)
----编辑-----
我的环境默认文件:
NODE_ENV=DEVELOPMENT
DB_HOST=localhost
DB_USER=user
DB_PASSWORD=userpass
DB_NAME=teste
这就是我的db.js文件:
so this my db.js file:
var mysql = require('mysql')
var connection = mysql.createConnection({
host: process.env.DB_HOST,
user: process.env.DB_USER,
password: process.env.DB_PASSWORD,
database : process.env.DB_NAME,
sockertPath: '/var/run/mysqld/mysqld.sock'
})
connection.connect()
connection.query('SELECT 1 + 1 AS solution',
function (error, results, fields) {
if (error) throw error;
console.log('The solution is: ', results[0].
solution)
});
module.exports = connection;
推荐答案
您必须专门创建一个MySQL用户才能访问该应用程序.创建一个用户并设置一个密码(不要将密码保留为空).不要忘记授予该用户访问权限,使其能够访问应用程序的数据库和表.希望我能帮上忙.
You must create a MySQL user specifically to access the app. Create a user and set a password (do not leave the password null). Do not forget to give this user permission to be able to access the database and tables of app. I hope I have helped.
这篇关于ER_ACCESS_DENIED_ERROR:对用户"@'localhost"的访问被拒绝(使用密码:NO)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文