Configuring FossLook to Work With MySQL

Let’s look at how to install the free MySQL database and how to configure FossLook to work with it.

Installing and configuring MySQL

1) Download the free version of MySQL Community Server, select the required installation on the official website of the product. Unzip and run the installation of the MySQL server. Click “Next”:

2) Accept the license agreement, click “Next”:

3) Select "Typical":

4) Click “Install”:

5) Close the MySQL Enterprise window, it will not be needed anymore:

6) Select the checkbox to start the wizard configuration, and click “Finish”

7) Select the standard setting and click “Next”:

8) Choose the MySQL service name and check the “Include Bin Directory in Windows PATH”:

9) Enter the Administrator password:

10) Click “Execute”:

After all the actions were completed, click “Finish”.

11) You need to edit the file my.ini, which is located in the C:\Program Files\MySQL\MySQL Server 5.5:

• a) In the [mysql] section, instead of the default-character-set = latin1 line, insert the line: default-character-set=utf8
• b) In the [mysqld] section insert the line: max_allowed_packet=64M
• c) instead of the line character-set-server = latin1 insert the line: character-set-server = utf8
• d) instead of the line innodb_buffer_pool_size = 18M insert the line: innodb_buffer_pool_size = 500M

12) You must restart the MySQL server:

13) Download and run the installation of the MySQL-workbench from this link. At the start, the installer checks availability of the C++ 2010 and the .Net Framework 4.0. If they are not found, a message appears:

Click “OK” and “Download Perquisites” to download Microsoft Visual C++ 2010 Redistributable Package, Microsoft .Net Framework 4 Client Profile and install it:

14) Restart the installation of the MySQL Workbench and click “Next”

15) Select the “Complete” installation and click “Next”

Setting up a FossLook server

1) Run FossLookServerSetup.msi and click “Next”:

2) Accept the license agreement and click “Next”:

3) After the server installation, the setup wizard starts FossLook configurator

You have to enter the server name, the path to the license file and the network port. Click “Next”:

4) Select MySQL as a data storage provider:

5) Next, configure the connection to the MySQL server:

• Server - you must specify the name of the machine where the MySQL server is installed. If it is installed on the same machine as FossLook, then leave the ip-address of the local machine 127.0.0.1
• Database – You can change the database name, or leave it as it is.
• User ID – default user
• Password – the same password as when you installed the MySQL server.

Click “Next”.

6) In the confirmation window, click “Next”:

7) After the wizard finishes, click “Finish”

Related articles