Using Superset to Obtain Data from MySQL for Analysis (Historical Version)

Scenarios

Superset is an open-source data exploration and visualization platform. This tool provides a quick way to intuitively visualize datasets by allowing you to create and share interactive dashboards. FlexusL provides a Superset application image running on Ubuntu 24.04 and deployed with Docker. The image comes pre-installed with Nginx, Redis, pgAdmin, and Docker. This section describes how to use Superset to obtain data from MySQL databases for analysis.

This practice applies to FlexusL instances with a Moodle application image purchased before August 28, 2026.

Step 1: Configure Security Groups

Add inbound security group rules to ensure that the application preinstalled in the image can be accessed.

1. Log in to the FlexusL console and click the target resource card or instance name to go to the instance details page.
2. In the navigation pane on the left, choose Cloud Servers and click the target server name to view its details.

   

3. On the Security Groups tab, click Add Rule to add the rules listed in the following table.

   The following only lists common rules. You can add more rules as needed.

   Table 1 Security group rules

   Priority	Action	Type	Protocol & Port	Source	Description
   1	Allow	IPv4	TCP: 80	0.0.0.0/0	Specifies the internal forwarding port of application images
   1	Allow	IPv4	TCP: 3306	0.0.0.0/0	Allows access to MySQL databases.
   1	Allow	IPv4	TCP: 9000	0.0.0.0/0	Allows external access to the application O&M page.
   1	Allow	IPv4	TCP: 9001	0.0.0.0/0	Allows external access to the application dashboard.

Step 2: Reset the Password

A FlexusL instance does not have an initial password. After creating a FlexusL instance, set a password for the FlexusL instance. The password of the FlexusL instance is also used for logging in to the O&M page of the application.

1. In the Image area on the Overview page of the FlexusL console, click Access to go to the application dashboard and check whether the application has been up and running. If yes, go to the next step.
   

   Wait for several minutes until the application is up and running. Then, you can perform operations such as restarting or stopping the instance, or resetting the password. Otherwise, the initial password may become invalid and you cannot log in to the application dashboard.

   Figure 1 Access to the application dashboard
   

   After the application is started, the initialization wizard page of the dashboard is displayed, as shown in Figure 2.

   Figure 2 Initialization wizard page of the Superset dashboard
   
   

   If the dashboard is not properly displayed, check the following causes:

   • The port for accessing the dashboard is not opened. Check whether the port is opened by referring to Step 1: Configure Security Groups.
   • The dashboard is being started. Try again later.
2. Locate the resource card and choose > Reset Password. Alternatively, in the list view, click Reset Password in the Operation column to reset the password for the FlexusL instance.

   For details, see Resetting the Password for a FlexusL Instance.

   Figure 3 Resetting a password
   
   

   The password for logging in to the FlexusL instance is also the password for logging in to the application O&M page.

Step 3: Initialize Superset

Application images use code-based Ubuntu. They provide graphical user interfaces to make your operations easier. You need to initialize the application dashboard upon the first login. Then you can directly log in to the dashboard from the FlexusL console afterwards.

1. In the address bar of a local browser, enter http://server-EIP:9000 to log in to the application O&M page.

   The initial username and password for logging in to the application dashboard are stored on the O&M page of the application. You need to log in to the O&M page first to obtain the username and password. The username for logging in to the O&M page is root, and the login password is the password reset in 2.

   

   For details about the FlexusL instances, O&M page, and dashboard, see What Is the Relationship Among FlexusL Instances, the Dashboard, and the O&M Page?

2. On the My Apps page, click the application icon, choose Access, and click Initial Account to view the username and password for logging in to the application management page.

   The initial password is a randomly generated strong password. After the application is initialized, change the password on the dashboard for easy management. If the password is changed, the initial password will be invalid. Remember the new password.

   

3. In the Image area on the Overview page of the FlexusL console, click Access to go to the application dashboard.

   

   

   If the dashboard is not properly displayed, check the following causes:

   • The port for accessing the dashboard is not opened. Check whether the port is opened by referring to Step 1: Configure Security Groups.
   • The dashboard is being started. Try again later.
4. Enter the username and password obtained in 2 to access the dashboard.

   You can set the language on the login page or on the management page.

   Figure 4 Initialization wizard page of the Superset dashboard
   
   

   If you cannot log in to the application dashboard, see Why Cannot I Access the Dashboard of the Application Pre-installed in the Application Image After Entering the Initial Username and Password?

5. In the upper right corner of the page, choose Settings > User > Info and click RESET MY PASSWORD.

   Preset passwords are usually difficult to remember, so you are advised to set a password that is easy to remember, and please keep it safe.

   

   After the Superset application is initialized, you can deploy your applications on the dashboard.

Step 4: Obtain Data from MySQL Databases for Analysis