Foglight 5.9.7 - Installing Foglight on Windows with an External MySQL Database

If you selected the Run Now check box in the Foglight Server Startup step in the installer, the installer starts Foglight and launches the Foglight startup page.

When the server startup is complete, a link to the Foglight login page appears. For more information, see Logging in to Foglight.


	NOTE: The default link to the login page points to http://localhost:8080. In some instances, this link may not correspond to the URL of your Foglight server. In such cases, see Why does clicking the login link on the server startup page not work?.

Next steps

If you performed a Custom Install and you did not install a license in Step 14: Add Foglight license file, follow the instructions in Importing a license file after installation to provide a license file to the Management Server after installation.


	IMPORTANT: See the Administration and Configuration Guide for information about license requirements, managing licenses, and the different categories of cartridges (based on their license requirements).

If you did not select the Run Now option in the Foglight Server Startup step of the installer, start the Management Server by following the instructions in Starting and stopping the Management Server.

To log in to Foglight, see Logging in to Foglight.

To set up an encrypted database connection, see Setting up an encrypted database connection with SSL.

External MySQL database access for remote users

Before installing Foglight with an external MySQL® database, the GRANT ALL ON query needs to be executed once in order to give users remote access to the database.

To provide users with remote access to the database:

From the MySQL Server Instance Configuration dialog box, select the Modify Security Settings check box.

Type a new root password (this password is used when executing the GRANT ALL ON query executed below).

Select the Enable root access from remote machines check box.

Executing the Grant All On Query script

Option 1

For better security, employ this option when the MySQL® instance is being used for more than one database.

To grant remote access to the MySQL Administrator account, create the database, and grant remote access to the database:

•

From the mysql prompt, type:

GRANT ALL ON mysql.* TO 'root'@'%' IDENTIFIED BY ‘<password>’ with grant option;

CREATE DATABASE <database_name> DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

GRANT ALL ON <database_name>.* to ‘root’@’%’ identified by ‘<password>’ with grant option;

Where <database_name> is the database name you will specify while installing Foglight and <password> is the root password you specified in the procedure “To provide users with remote access to the database,” above.

This gives the root user (with username root and password <password>) remote access with all privileges.

Option 2

Use this option only when the MySQL® instance is dedicated entirely to Foglight.

To grant remote access to the entire MySQL instance:

•

From the mysql prompt, type:

GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY ‘<password>’ with grant option;

Where <password> is the root password you specified in the procedure “To provide users with remote access to the database,” above.

This gives the root user (with username root and password <password>) remote access with all privileges.


	IMPORTANT: In some cases, following one of these options might not give grant_priv to the root user. If grant_priv is missing for root@% after executing the GRANT ALL ON query, see Installing Foglight FAQ for more information.

製品を選択してください:

サービス向上のために、「Purpose of your Chat（チャットの目的）」を記入してください。

お客様の不具合に推奨されるソリューション

Foglight 5.9.7 - Installing Foglight on Windows with an External MySQL Database

Foglight Server Startup page

Next steps

External MySQL database access for remote users

Executing the Grant All On Query script