Skip to content

Connecting to a database

ExpManager keeps nothing of its own: the experiments, plates and labels it shows are all in a BacBuster database on a MySQL or MariaDB server - the same database BacBuster saves the scanned plates to, and Baclan reads them from.

Choosing a database

Click the yellow DATABASE label. The Database Connection window lists the servers, the users on each, and the databases each user can see.

The Database Connection window

Button Does
Add/Change Opens the Connection Editor for a new server, or for the one selected
Create New Database Makes a database with the name in the box beside it, for the selected server and user, with the tables BacBuster and Baclan need
Remove Forgets the selected server or user, after asking. The databases stay on the server
Refresh Asks the servers again which databases each user can see
Ok Uses the selected database. A double-click does the same
Close Leaves things as they were

The Connection Editor asks for the server's Host (name or address), its Port (usually 3306), the User and Password, and optionally a Host Short Name to show in place of the address. Test tries the connection; Ok adds it to the list.

The list is shared with BacBuster and Baclan on the same computer: a server added in one is there in the others.

Passwords are stored

The connections, passwords included, are kept in %APPDATA%\BaclAn\Servers.dat, so that ExpManager can connect by itself at start-up. Use accounts with no more rights than they need: planning plates needs the right to add and delete plates, not to change the database.

Database Setup

Database Setup, in the settings (the fork-and-spoon button), opens the Manager, for whoever looks after the server. It logs in as the server's root user:

Control Does
Host, Port, Root Password, Connect Log in to the server
Users, Global Privileges The server's accounts and the selected one's rights
New User Name, Password With Create Read Only User or Create Full Access User: make an account
Change Password, Delete User For the selected user
Databases Read Only, Databases Full Access Tick databases and click Read Only or Full Access to give the selected user those rights
Init Recreates Service Table. Does NOT erase data.
Apply Updates (Full Access List) Brings the ticked databases up to the current table structure
Update Colony Thumbs Makes the small colony pictures in the ticked databases; Stop Update stops it

These are accounts of the database server. The USER of ExpManager's window is something else: the name plates are filed under, kept in the database itself.