How do I specify the password in the MYSQL connection URL?

Question

I'm currently using this connection URL for MYSQL

mysql://root:macbookair@localhost:3306/test_db

and getting this error.

[INFO] require: ./mysql
[INFO] connecting
[ERROR] Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'localhost' (using password: YES)

How do I specify the password in the MYSQL connection URL?

Answer 1

Got it now.

The connection URL is in this format:

mysql://<username>:<password>@<host>:<port>/<db_name>

thus the password worked when I replaced macbookair in my url with the password.

Answer 2

try below

jdbc:mysql://localhost:3306/organizer?user=root&password=root