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:
$DSN = "DBI:mysql:cac:localhost";
$dbh = MySql->Connect('localhost','cac');
$SQL= "SELECT * FROM artigos where Familia='VASOS';" or die "erro ao seleccionar Queryn";
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?