I want to catch createConnection() Error

[Philosoph228]

I want to handle connection error like this:

import { Connection, createConnection } from 'mysql2';

let connection: Connection;

try {
  connection = createConnection({
    host: '127.0.0.1',
    port: 3306,
    user: 'root',
    password: 'password'
  });
} catch (err) {
  if (err instanceof Error) {
    console.log(`createConnection error: ${(err as Error).message}`);
  }

  throw err;
}

But error doesn't catch. It just prints to console that it is uncaught:

/usr/bin/node ./build/index.js
Process exited with code 1
Uncaught Error Error: connect ECONNREFUSED 127.0.0.1:3306
    at __node_internal_captureLargerStackTrace (internal/errors:490:5)
    at __node_internal_exceptionWithHostPort (internal/errors:668:12)
    at afterConnect (net:1494:16)
    at callbackTrampoline (internal/async_hooks:130:17)
    --- TickObject ---
    at init (internal/inspector_async_hook:25:19)
    at emitInitNative (internal/async_hooks:202:43)
    at emitInitScript (internal/async_hooks:505:3)
    at nextTick (internal/process/task_queues:132:5)
    at onDestroy (internal/streams/destroy:103:15)
    at Socket._destroy (net:811:5)
    at _destroy (internal/streams/destroy:109:10)
    at destroy (internal/streams/destroy:71:5)
    at afterConnect (net:1503:10)
    at callbackTrampoline (internal/async_hooks:130:17)
    --- TCPCONNECTWRAP ---
    at init (internal/inspector_async_hook:25:19)
    at emitInitNative (internal/async_hooks:202:43)
    at internalConnect (net:1047:26)
    at defaultTriggerAsyncIdScope (internal/async_hooks:464:18)
    at <anonymous> (net:1250:9)
    at processTicksAndRejections (internal/process/task_queues:77:11)
    --- TickObject ---
    at init (internal/inspector_async_hook:25:19)
    at emitInitNative (internal/async_hooks:202:43)
    at emitInitScript (internal/async_hooks:505:3)
    at nextTick (internal/process/task_queues:132:5)
    at defaultTriggerAsyncIdScope (internal/async_hooks:464:18)
    at lookupAndConnect (net:1248:5)
    at Socket.connect (net:1193:5)
    at connect (net:243:17)
    at Connection (/home/philosoph228/ts230508/node_modules/mysql2/lib/connection.js:50:27)
    at exports.createConnection (/home/philosoph228/ts230508/node_modules/mysql2/index.js:10:10)
    at <anonymous> (/home/philosoph228/ts230508/build/index.js:7:52)
    at <anonymous> (/home/philosoph228/ts230508/build/index.js:13:7)
    at Module._compile (internal/modules/cjs/loader:1254:14)
    at Module._extensions..js (internal/modules/cjs/loader:1308:10)
    at Module.load (internal/modules/cjs/loader:1117:32)
    at Module._load (internal/modules/cjs/loader:958:12)
    at executeUserEntryPoint (internal/modules/run_main:81:12)
    at <anonymous> (internal/main/run_main_module:23:47)

[wellwelwel]

@Philosoph228, you can catch the errors adding an error event listener, like:

import { Connection, createConnection } from 'mysql2';

let connection: Connection;

connection = createConnection({
   host: '127.0.0.1',
   port: 3306,
   user: 'root',
   password: 'password',
});

connection.addListener('error', (err) => {
   if (err instanceof Error) {
      console.log(`createConnection error: ${(err as Error).message}`);
   }
});

Or using mysql/promise, like:

import { Connection, createConnection } from 'mysql2/promise';

(async() => {
   let connection: Connection;
   
   try {   
      connection = await createConnection({
         host: '127.0.0.1',
         port: 3306,
         user: 'root',
         password: 'password',
      });
   } catch (err) {
      if (err instanceof Error) {
         console.log(`createConnection error: ${(err as Error).message}`);
      }
   }
})();