This procedure allows people to connect to MySQL server remotely over a local LAN network
Firstly, the Tabernus server will require two network connections - one for external connection, one for the wiping network. For example:
eth0 - commercial networketh1 - isolated 192.168.0.1 network for erasures
These can be set up from System > Administration > Network
The external network connection should be set up as a static IP address, not in the range 192.168.0.1 - 254
Assuming this is set up, the following actions need to be performed to add a user that can be used from an external machine
Open up a terminal from the desktop, by right clicking and open in terminal.
Type:
gedit /etc/mysql/my.cnf
This will open an editor with the MySQL configuration.
Find the line:
bind-address = 127.0.0.1
Edit this to be:
bind-address = 0.0.0.0
Save and close my.cnf
Restart the MySQL service from the terminal window:
service mysqld restart
Open up the Administrator Program:
Applications > Programming > MySQL Administrator
Log in with the following details:
Server Hostname: localhost
Port: 3306
Username: root
Password: tabernus
Press connect.
On the left hand side click User Administration.
Under the user 'root' on the bottom left hand of the window right click and choose New User
Under Login Information for that user, rename the user to something useful
Set the password for the user to be something memorable
Apply the changes (bottom right hand side)
Once you have applied the settings, you will have to reselect that new account (as the name has changed)
Select Schema Privileges on the Administrator
Select the TABERNUS_ASSETDB_V2 schema
Select all the Available Privileges from the right hand column (select one and press [Ctrl]-a) and press the left hand arrow on the screen to allow all.
Apply the changes, and exit the software.
You should be able to connect to the database from a second computer/server now.
When connecting use:
Hostname: Static IP Address of the Tabernus Server on the commercial networkPort: 3306Username: New username set abovePassword: New password as set above.