We would like to generate a mysql select query from a perl script.
Unfortunately we are facing problems in connecting mysql from the perl script.
We think the connection part of the script should be something like this:

Our server name is “Ceramicarte”. Our database name is “cac” (you prepared it for us two weeks ago and we already create a
table and filled it with data).
Can you help us with this problem? Do we need to provide our password somewhere on the script?