How to install UserGate 6.1+ with MySQL
Posted by Dmitriy Zarukin on 23 July 2013 10:58 AM
To install UserGate with MySQL you should do the following:
Install MySQL Server from here.
Maybe you'll need dotNET, you can install it form here.
Then open WorkBench, go to Server Administration, click Users and Priviledges, then Add account, put in username, password, confirm password, in Administrative roles give to this user DBA role, Apply. Go out of WorkBench.
Install connector form here.
Next, create the database.
Open command line, type: cd "C:\Program Files\MySQL\MySQL Server 5.5\bin" or the path where you install MySQL Server.
Then type: mysql -u <user_name> -p, type the password, then type: create database - this will create database named "usergate".
Then quit the command line.
Then take the latest version of UserGate:
Choose all settings you need. When there's a window with choosing the database - click on MySQL, fill all fields in.
It's ready to use. Type your license key and set the program.