# OpenSQLConnection problem - password visible

Prerequisites

• some database (here, it's called sakila (mysql standard test db I think))

Setup - minimal (?) working example

We call

 Needs["DatabaseLink"]


Next we shall use the wizard/connection tool to create a new database connection, like:

c1 = OpenSQLConnection[]


(after creating the new connection, we use the wizard to connect right to the new connection; and obviously, we do not tick the "store password in plain text").

Next, we set up another connection:

c2 = OpenSQLConnection["test"]


where "test" is the name we used for above connection (we get prompted for the password).

Finally, a third connection:

c3 = OpenSQLConnection[
JDBC["MySQL(Connector/J)", "localhost:3306/sakila"],
"Catalog" -> Automatic, "Description" -> None, "Name" -> "test",