THE MYSQL SERVER MACHINE
If you are setting up a MySQL database server for multiple Compendium users you firstly need to install MySQL on a machine that has network access, (see Compendium ReadMe or MySQL instructions on installing the software). The computer that you select must have a fixed IP address or a host name that can then be referenced by the remote Compendium users. MySQL uses port 3306 by default, so this port must be open. If you have any firewall software in place please check that this port is accessible.

SETTING UP MYSQL USER ACCOUNTS
Once you have installed MySQL you will then need to setup one or more MySQL user accounts. You have two options for setting up MySQL users:
1. You can set up one MySQL user account and give it to all your Compendium users and make the account open for all external hosts.
2.
You can set up one MySQL user account for each Compendium user who wishes to connect to the database server, and specify their actual machine IP address as the allowed host.
Whichever option you select you need to be able to create MySQL user accounts. If you are a more experienced computer user you may be able to use the MySQL command line facilities to create these accounts. If not, you will need to install a third party piece of software to give you a more user-friendly front end onto MySQL

Download