首页 > 解决方案 > 无法连接到我的 dockerized MySQL/MariaDB Nodejs

问题描述

我正在使用 docker 运行 MariaDB 并在 openshift 上进行部署。我正在使用此命令将端口转发到我的本地端口。

oc port-forward mariadb-sdxcvv 13306:3306

在我的节点项目中。我通过包 mariadb 连接到 mariadb。这是我的代码:

  this.conn = await mariadb.createConnection( {
    host: process.env.DB_HOST,
    user: process.env.DB_USER,
    password: process.env.DB_PWD,
    database: process.env.DB_NAME,
    port: process.env.DB_PORT
  } );

我得到这个错误

Access denied for user 'admin'@'127.0.0.1' (using password: NO)

这是我对 mariadb 容器中用户的授予访问权限

| User  | Host      |
+-------+-----------+
| admin | 127.0.0.1 |
| root  | 127.0.0.1 |
| root  | ::1       |
| admin | localhost |
| root  | localhost |
+-------+-----------+


+-----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for admin@127.0.0.1                                                                                                              |
+-----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'admin'@'127.0.0.1' IDENTIFIED BY PASSWORD '*EA3E87A342924C7419B8D1400798D4E63FBF0930' WITH GRANT OPTION |
+-----------------------------------------------------------------------------------------------------------------------------------------+

我哪里错了?请帮我

标签: javascriptmysqlnode.jsdockermariadb

解决方案


推荐阅读