Does anyone know anything about mysql, perl and data bases?

Question

When I upload to my host, I normallyhave to put in databse data such as mysql host name, username, password and database name.

This takes the written form of "sql110.01.net" (hostname),

"_123456_" database name, "blahblah" password and "123456" username, for example.

However I have two perl scripts to install and I just can't relate the instructions to my server! I don't usually need to know the dbi driver name, what's that ??? If I print the instructions here, could anyone bear in my the info I put above and show me how it would be entered in a perlscript please???

Answer 1

(a) Open the file 'Common.pm' which is in the main folder of your application

path.

(b) Look for the database connection parameters:

$strConn = "DBI:mysql:database=_123456_;host=sql110...

$strLogin = "123456";

$strPassword = "blahblah";

you might want to specify the port number as well if it is not 3306 by default (you might be don't need this):

$strConn = "DBI:mysql:database=_123456_;host=sql110...

sorry "Answers" cuts long strings off. So...

$strConn

=

"DBI:mysql:database=_123456_;

host=sql110.01.net";

(in a single line, no spaces)

or

$strConn = "DBI:mysql:database=_123456_;

host=sql110.01.net;

port=<port>";