当我将sails与mysql连接时出错(节点- v7.5.0)

Question

error: A hook (`orm`) failed to load!
error: Error (E_UNKNOWN) :: Encountered an unexpected error
: Could not connect to MySQL:
Error: connect ECONNREFUSED 127.0.0.1:3306
    at afterwards (/root/sails/sailsUserApp/node_modules/sails-mysql/lib/connections/spawn.js:72:13)
    at /root/sails/sailsUserApp/node_modules/sails-mysql/lib/connections/spawn.js:40:7
    at Handshake.onConnect [as _callback] (/root/sails/sailsUserApp/node_modules/sails-mysql/node_modules/mysql/lib/Pool.js:54:9)
    at Handshake.Sequence.end (/root/sails/sailsUserApp/node_modules/sails-mysql/node_modules/mysql/lib/protocol/sequences/Sequence.js:96:24)
    at Protocol.handleNetworkError (/root/sails/sailsUserApp/node_modules/sails-mysql/node_modules/mysql/lib/protocol/Protocol.js:364:14)
    at PoolConnection.Connection._handleNetworkError (/root/sails/sailsUserApp/node_modules/sails-mysql/node_modules/mysql/lib/Connection.js:421:18)
    at emitOne (events.js:96:13)
    at Socket.emit (events.js:189:7)
    at emitErrorNT (net.js:1280:8)
    at _combinedTickCallback (internal/process/next_tick.js:74:11)
    at process._tickDomainCallback (internal/process/next_tick.js:122:9)

connection.js -

Mysql: 
{
    adapter: 'sails-mysql',
    host: 'localhost',
    port: '3306',
    user: 'root', //optional
    password: 'sipl@1234', //optional
    database: 'sails_users' //optional
}

models.js - connection: 'Mysql',

我想不出这个问题.端口: 3306已经在配置中提到了。

Answer 1

MySQL连接参数将取决于MySQL配置。配置文件位置和默认连接访问控制列表将取决于运行MySQL的操作系统和传递给安装的选项。

它可能期望使用Unix套接字连接，而不是TCP连接。检查您的MySQL配置文件，以查看允许哪些连接和用户。如果它只允许套接字连接，那么它将使用特定的unix套接字。

根据这些信息，您可以相应地设置配置参数。

若要使用套接字连接，参数如下：

Mysql: 
{
    adapter: 'sails-mysql',
    socketPath: 'path-to-socket/mysql.sock',
    user: 'mysql-user',
    password: 'mysql-password',
    database: 'mysql-database'
}