00PARZIVAL00
Picopat
- Katılım
- 23 Temmuz 2022
- Mesajlar
- 519
- Çözümler
- 1
Daha fazla
- Cinsiyet
- Diğer
Selam, MySQL veritabanını, NodeJS ile bağlamaya çalışıyorum, normal yazdığımda bağlanıyor, fakat .env dosyası ile denediğimde bağlanmıyor, internete baktım biraz ama çözemedim. Yardım eder misiniz?
Env dosyası kullanmadan sorunsuz bağlanan şekil;
Env Dosyası ile hata aldığım şekil;
Not: Dotenv'nin config kısmına path vererek yapmayı denedim o da olmadı. Hepsi aynı klasörde.
Hata;
Env dosyası kullanmadan sorunsuz bağlanan şekil;
JavaScript:
const express = require('express');
const app = express();
const mysql = require('mysql');
const db = mysql.createPool({
connectionLimit: 100,
host: "127.0.0.1",
user: "newuser",
password: "password123",
database: "userDB",
port: "3306"
})
db.getConnection( (err, connection) => {
if (err) throw (err)
console.log("DB connected succesful:" + connection.threadId)
})
Env Dosyası ile hata aldığım şekil;
Kod:
DB_HOST = 127.0.0.1
DB_USER = newuser
DB_PASSWORD = password123
DB_DATABASE = userDB
DB_PORT = 3606
PORT = 3000
JavaScript:
const express = require('express');
const app = express();
const mysql = require('mysql');
require('dotenv').config()
const DB_HOST = process.env.DB_HOST
const DB_USER = process.env.DB_USER
const DB_PASSWORD = process.env.DB_PASSWORD
const DB_DATABASE = process.env.DB_DATABASE
const DB_PORT = process.env.DB_PORT
const db = mysql.createPool({
connectionLimit: 100,
host: DB_HOST,
user: DB_USER,
password: DB_PASSWORD,
database: DB_DATABASE,
port: DB_PORT
})
db.getConnection( (err, connection) => {
if (err) throw (err)
console.log("DB connected succesful:" + connection.threadId)
})
Not: Dotenv'nin config kısmına path vererek yapmayı denedim o da olmadı. Hepsi aynı klasörde.
Hata;
Kod:
C:\Users\root\Desktop\dbServer\node_modules\mysql\lib\protocol\Parser.js:437
throw err; // Rethrow non-MySQL errors
^
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
at Handshake.Sequence._packetToError (C:\Users\root\Desktop\dbServer\node_modules\mysql\lib\protocol\sequences\Sequence.js:47:14)
at Handshake.ErrorPacket (C:\Users\root\Desktop\dbServer\node_modules\mysql\lib\protocol\sequences\Handshake.js:123:18)
at Protocol._parsePacket (C:\Users\trfur\Desktop\dbServer\node_modules\mysql\lib\protocol\Protocol.js:291:23)
at Parser._parsePacket (C:\Users\root\Desktop\dbServer\node_modules\mysql\lib\protocol\Parser.js:433:10)
at Parser.write (C:\Users\root\Desktop\dbServer\node_modules\mysql\lib\protocol\Parser.js:43:10)
at Protocol.write (C:\Users\root\Desktop\dbServer\node_modules\mysql\lib\protocol\Protocol.js:38:16)
at Socket.<anonymous> (C:\Users\root\Desktop\dbServer\node_modules\mysql\lib\Connection.js:88:28)
at Socket.<anonymous> (C:\Users\root\Desktop\dbServer\node_modules\mysql\lib\Connection.js:526:10)
at Socket.emit (node:events:527:28)
at addChunk (node:internal/streams/readable:315:12)
--------------------
at Protocol._enqueue (C:\Users\root\Desktop\dbServer\node_modules\mysql\lib\protocol\Protocol.js:144:48)
at Protocol.handshake (C:\Users\root\Desktop\dbServer\node_modules\mysql\lib\protocol\Protocol.js:51:23)
at PoolConnection.connect (C:\Users\root\Desktop\dbServer\node_modules\mysql\lib\Connection.js:116:18)
at Pool.getConnection (C:\Users\root\Desktop\dbServer\node_modules\mysql\lib\Pool.js:48:16)
at Object.<anonymous> (C:\Users\root\Desktop\dbServer\dbServer.js:23:4)
at Module._compile (node:internal/modules/cjs/loader:1105:14)
at Object.Module._extensions..js (node:internal/modules/cjs/loader:1159:10)
at Module.load (node:internal/modules/cjs/loader:981:32)
at Function.Module._load (node:internal/modules/cjs/loader:822:12)
at Function.executeUserEntryPoint [as runMain] (node:internal/modules/run_main:77:12) {
code: 'ER_NOT_SUPPORTED_AUTH_MODE',
errno: 1251,
sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client',
sqlState: '08004',
fatal: true
}
[nodemon] app crashed - waiting for file changes before starting...
Son düzenleme: