MySQL tools
- mysqlnavigator - use apt-get install mysql-navigator
Using OpenOffice as a front end to MySQL database using ODBC
OpenOffice is running on user's workstation. MySQL database is running on a server computer elsewhere. We assume that MySQL is configured to accept connections from appropriape people and locations.
- make sure MySQL client is installed - use apt-get install mysql-client
- this may very well add 8 new packages (libdbd-mysql-perl, libdbi-perl, libmysqlclient12, libnet-daemon-perl, libplrpc-perl, mysql-client, mysql-common, mysql-doc), update 4 packages (libperl, perl, perl-base, perl-modules), and remove one package (perl-doc)
- install ODBC software on workstation - use apt-get install unixodbc
- install MySQL libraries (MySQL-shared-...) MyODBC software on the workstation
configuration files in /home/dalep
.my.cnf (configuration file for connection to database)
[client]
host=biostat.mc.vanderbilt.edu
user=dalep
password=********
.odbc.ini (defines what OpenOffice calls "data sources". one [section] for each source)
[DatabaseServer]
Description = Biostatistics Database Server
Driver = MySQL
Server = biostat.mc.vanderbilt.edu
Database = test
Port = 3306
Socket =
Option =
Stmt =