Looking to setup MySQL on a server so that users can access it via MySQL workbench, and be secure how can this be done?
You simply need to buy webhosting services that support remote access to your MySQL servers or run your own MySQL server with remote access enabled. Then from MySQL workbench they can setup a new connection with the provided server details: username, password, hostname, port(the default is 3306). Once they have that connection setup they can connect to and manage the database from the main MySQL workbench interface.
You mean remote access to the server itself and access mysql from there, and access to mysql using a client application such as workbench?