I want to set up databases on a mySQL sever but my IT dept in all its wisdom has decided to run a firewall on the machine. How do I go about setting up access for individual IJC users? What regular and mySQL accounts will I need on the database server? Also I am interested in deploying the database through a web server. What do I need for this?
sorry for the delay in answer. There were public holidays in Hungary and Czech Republic.
In any case, what you should need to be able to run MySQL through firewall is to have the default port MySQL is running on enabled - port 3306 and you need a database user that you can connect to remotely. For more details on the needed permissions for the user see here.
Regarding your question with the web server, what web server are you referring to? JChem Web Services, Plexus Suite or Instant JChem Web Client (deprecated since version 6.2.x).
Now I had a few days off, hence the delay in my answer
I've asked the IT dept to open port 3306, hopefully this will fix the problem (but they also had holidays).
Opening up port 3306 in the firewall on the mySQL server did the trick.