Specifying password in MySQL connection string

Question

I created ExpressJS MVC app using MySQL as DB with Yeoman generator and in config.js I want to change MySQL connection strings, but I don't know to specify password in string.

my string is mysql://root@localhost:3306/

Please help me.

Answer 1

Here's generic connection-string parser, which offers a flexible optional syntax, while adhering to the URL syntax. Works in any environment.

const { ConnectionString } = require('connection-string');

const cs = new ConnectionString('mysql://user:password@host:port/dbName');

Answer 2

Password and DB name also a part of connection string.
Ex: mysql://root:password@localhost:port/dbName