Minos and MySQL

Installing MySQL

If you possibly can, the easiest way to install MySQL is with RedHat's rpm system- detailed installation instructions are at

http://www-numi.fnal.gov/fnal_minos/computing/srt_public_context/WebDocs/external_products.html

You will also find instructions on setting up the permissions tables. Note that there are "database user accounts" which are not at all the same as "linux user accounts".

The offline software needs to know where to read data from, and which database account to use to read it. These are supplied by environment variables, set up by SRT. At Minnesota, these are:

ENV_TSQL_URL=mysql:odbc://urheim.hep.umn.edu/offline;mysql:odbc://urheim.hep.umn.edu/temp
ENV_TSQL_USER=reader
ENV_TSQL_PSWD=numi96

At your institution, you should change the "urheim.hep.umn.edu" to the URL of your database machine.

---

The mysql client
Pete Border
January 7, 2002