MySQLΒΆ
This chapter contains an example of a basic FUDO configuration, to monitor SQL queries to a remote MySQL database server.
In this scenario, the user connects to a MySQL database using individual login and password. When establishing the connection with the remote server, FUDO substitutes the login and the password with the previously defined values: root
/password
(authorization modes are described in the User authorization modes section).
![../../_images/quickstart_overview_mysql.png](../../_images/quickstart_overview_mysql.png)
Prerequisites
The following description assumes that the system has been already initiated. For more information on the initiation procedure refer to the System initiation topic.
Configuration
![../../_images/data_modeling1.png](../../_images/data_modeling1.png)
Adding a server
- Select > .
- Click .
- Provide essential configuration parameters:
- Click .
Adding a user
- Select > .
- Click .
- Provide essential user information:
- Click .
Adding a connection
- Select > to access the connections configuration page.
- Click the button.
- Provide connection details:
- Click .
Establishing connection with a MySQL database
- Launch a command line interface client.
- Enter
mysql -h 10.0.40.50 -u john_smith -p
, to connect to the database server. - Enter the user’s password.
![../../_images/mysql_connect.png](../../_images/mysql_connect.png)
- Continue browsing the database contents using SQL queries.
Viewing user session
- Open a web browser and go to the FUDO administration page.
- Enter user login and password to log in to FUDO administration panel.
- Select > .
- Click .
- Find John Smith’s session and click i.
![../../_images/mysql_ongoing.png](../../_images/mysql_ongoing.png)
![../../_images/player_mysql_session.png](../../_images/player_mysql_session.png)
Related topics: