您可以跳过ORM，构建器等，并使用sqler和sqler-mdb简化您的DB/SQL管理。

-- create this file at: db/mdb/read.table.rows.sql
SELECT TST.ID AS "id", TST.NAME AS "name", NULL AS "report",
TST.CREATED_AT AS "created", TST.UPDATED_AT AS "updated"
FROM TEST TST
WHERE UPPER(TST.NAME) LIKE CONCAT(CONCAT('%', UPPER(:name)), '%') 

const conf = {
  "univ": {
    "db": {
      "mdb": {
        "host": "localhost",
        "username":"admin",
        "password": "mysqlpassword"
      }
    }
  },
  "db": {
    "dialects": {
      "mdb": "sqler-mdb"
    },
    "connections": [
      {
        "id": "mdb",
        "name": "mdb",
        "dir": "db/mdb",
        "service": "MySQL",
        "dialect": "mdb",
        "pool": {},
        "driverOptions": {
          "connection": {
            "multipleStatements": true
          }
        }
      }
    ]
  }
};

// create/initialize manager
const manager = new Manager(conf);
await manager.init();

// .sql file path is path to db function
const result = await manager.db.mdb.read.table.rows({
  binds: {
    name: 'Some Name'
  }
});

console.log('Result:', result);

// after we're done using the manager we should close it
process.on('SIGINT', async function sigintDB() {
  await manager.close();
  console.log('Manager has been closed');
});

如果你使用docker，它对我有用!

在码头上。Yml添加以下行:

mysql:
   ...    
   command: --default-authentication-plugin=mysql_native_password
   restart: always

然后，从容器里往下，再往上。

除上述答案外; 执行以下命令后

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'

如果你得到一个错误为:

[ERROR] Column count of mysql.user is wrong. Expected 42, found 44. The table is probably corrupted

然后尝试在cmd作为admin;将路径设置为cmd下的“MySQL server bin”文件夹

set path=%PATH%;D:\xampp\mysql\bin;

然后执行如下命令:

mysql_upgrade --force -uroot -p

这将更新服务器和系统表。

然后，您应该能够成功地在Workbench中的Query中运行以下命令:

 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'    

然后记得执行以下命令:

flush privileges;

完成所有这些步骤后应该能够成功连接到您的MySQL数据库。 希望这对你有所帮助……

在Mysql最新的docker容器

ALTER USER root IDENTIFIED WITH mysql_native_password BY 'password';

对于会话，您应该使用用于mysql连接的任何模式

(async () => {
    const connection = await db.connection();
    sessionStore = new MySQLStore({

    }, connection); //just pass your connection here 
})();

我只是复制粘贴到这里但你可能已经实现了类似的东西来处理你的查询

const mysql = require('mysql')

if (!process.env.NODE_ENV || process.env.NODE_ENV === 'development') {
    require('dotenv').config();
}

const dbConfig = {
    host: process.env.DB_HOST,
    user: process.env.DB_USER,
    password: process.env.DB_PASSWORD,
    database: process.env.DB_DATABASE,
    connectionLimit: process.env.DB_CONNECTION_LIMITS
}

const pool = mysql.createPool(dbConfig);

const connection = () => {
    return new Promise((resolve, reject) => {
        pool.getConnection((err, connection) => {
            if (err) {
                reject(err);
            }

            const query = (sql, binding) => {
                return new Promise((resolve, reject) => {
                    connection.query(sql, binding, (err, result) => {
                        if (err) {
                            reject(err);
                        }
                        resolve(result);
                    });
                });
            };

            const release = () => {
                return new Promise((resolve, reject) => {
                    if (err) {
                        reject(err);
                    }
                    resolve(connection.release());
                });
            };
            resolve({ query, release });
        });
    });
};

const query = (sql, binding) => {
    return new Promise((resolve, reject) => {
        pool.query(sql, binding, (err, result, fields) => {
            if (err) {
                reject(err);
            }
            resolve(result);
        });
    });
};

module.exports = { pool, connection, query };

对于MySql 8，创建一个拥有所有权限的新用户，并将认证方法从caching_sha2_password更改为mysql_native_password。 详细步骤请查看Ochuko Ekrresa的文档。

步骤总结:

以root登录mysql -u root -p 创建用户newuser @ localhost 授予*上的所有特权。* TO 'newuser'@'localhost';

请检查上述文档链接，以获得有关授予特定特权的详细信息。

重新加载特权FLUSH privileges; MySql退出;再次登录mysql -u [newuser] -p; ALTER USER 'newuser'@'localhost' IDENTIFIED WITH mysql_native_password by 'password';

额外的信息: 对于我来说，在将身份验证更改为root后，我面临身份验证问题，无法登录。所以我重置我的密码(重置密码doc)。