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.
Providing users with remote access to the database:
1. From the MySQL Server Instance Configuration dialog box, select the Modify Security Settings check box.
2. Type a new root password (this password is used when executing the GRANT ALL ON query executed below).
3. 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 ‘’ with grant option; CREATE DATABASE DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; GRANT ALL ON .* to ‘root’@’%’ identified by ‘’ with grant option;
Where is the database name you will specify while installing Foglight and 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 ) remote access with all privileges.
To grant remote access to the entire MySQL instance:
Option 2
Use this option only when the MySQL® instance is dedicated entirely to Foglight.
• From the mysql prompt, type:
GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY ‘’ with grant option; Where 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 ) remote access with all privileges.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center