禁用 require_secure_transport mysql

禁用 require_secure_transport mysql

如何永久禁用 mysql 变量 require_secure_transport?我必须使用 node.js 访问 mysql,但它给出了以下错误:

  code: 'ER_SECURE_TRANSPORT_REQUIRED',
  errno: 3159,
  sqlMessage: 'Connections using insecure transport are prohibited while --require_secure_transport=ON.',
  sqlState: 'HY000',
  fatal: true }

作为参考,这就是我所说的https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_require_secure_transport

答案1

我最终require_secure_transport = ON从文件中删除了以下行:etc/mysql/conf.d

相关内容