Skip to content
Home » Connect cumul.io to a MySQL Database

Connect cumul.io to a MySQL Database

Being a little bit bored with the default visualization tools in R and Python, I decided to look into the available visualization tools that are out there in the data ecosystem. The Belgian visualization tool cumul.io focusses on integration in platforms, but it also seems like a solid entry-level visualization tool with a decent number of connectors that should work out of the box. Let’s try MySQL!

I hear you thinking out loud that MySQL might not be your first choice as a data warehouse. That’s correct, but I myself have bumped into some occasions where all website data (like users and purchases) are simply stored in a MySQL database. This is a situation that likely won’t occur in multinational companies with a robust big data stack. On the other hand, these are not the companies that are within cumul.io’s market segment. So if you work for an SME with most data in a MySQL database, this blog post might be of interest to you.

From the datasets section of the tool, you can easily add a new MySQL connection. As I said, it comes out of the box.

If you’re not working via an SSH tunnel. Here are steps you should take to keep the connection safe:

  • Whitelist the IP’s of cumul.io — 88.99.71.232 and 52.213.28.47
  • Create a user that has only reading rights

I host my MySQL database in Google Cloud Platform: whitelisting the IP addresses of cumul.io is straightforward. If you’re accessing a company database, you should contact your IT department.

You can’t create a read-only user through the GCP visual interface. Create a read-only user with the following commands. Once again, if you’re working in a company database, don’t fiddle around yourself and ask you IT department.

CREATE USER 'cumul'@'%' IDENTIFIED BY 'mypassword';
GRANT SELECT ON myatabase . * TO 'cumul'@'%';
FLUSH PRIVILEGES;

Finally, fill in the credentials in the cumul.io interface.

There might be some errors that you run into. Here’s the first one:

The database host could not be resolved. Are you using a publically routable hostname or IP address (an IP from a public range)? Could not connect to this database. Try our troubleshooting guide!

If you run into this error there are two possible causes: (1) the IP address and port are incorrect or (2) you did not whitelist cumul.io’s IP addresses (see higher).

Here’s another error:

This username/password combination is not valid, the user is not allowed to connect remotely or this database is not accessible by this user. Could not connect to this database.

It is clear that cumul.io was able to detect your MySQL server. But once again, there might be two causes: (1) The username and password are incorrect. Make sure you took the earlier steps and that you specifically gave the username access to the database you need. (2) The database does not exist.

So, this should get you started. You can now select the tables you need and use them in your visualizations.

Say thanks, ask questions or give feedback

Technologies get updated, syntax changes and honestly… I make mistakes too. If something is incorrect, incomplete or doesn’t work, let me know in the comments below and help thousands of visitors.

14 thoughts on “Connect cumul.io to a MySQL Database”

  1. Anneliese Mancini

    The Healthcare, Medicine & Wellness Industries Need You: Are You Ready to Make a Difference Without Sacrificing Your Ethics?

    Hi – do you want access to a reliable source of new clients in the healthcare, medicine, and wellness industries?

    Pre-launching https://getclientsmd.com/

    Original: $799/mo

    After Discount: $399/mo

    It’s $400/mo off

    First 10 orders only.

    Price goes up once these sell out.

    GetClientsMD is all about helping cold outreach experts, agency owners, business and sales pros get their ideal future healthcare, medicine, and wellness customers using carefully picked by hand and validated sales prospecting system.

    And let me tell you, I know how to make those clients come running.

    With GetClientsMD, you will have genuine connections to key healthcare, medicine, and wellness decision makers in no time.

    Say goodbye to the time-consuming task of building a breakthrough healthcare, medicine, and wellness leads list, juggling a tremendous stack, and enriching enormous data points.

    And don’t worry about accuracy slipping through the cracks, because GetClientsMD has got you covered.

    And the best part?

    Not only do I provide the highest quality healthcare, medicine, and wellness b2b data around, but I’m also offering it at the absolutely lowest price.

    You can pre-order today and get a whopping over 50% monthly discount forever.

    The price will increase once the first 10 spots are filled up, so the sooner you grab it, the cheaper it’ll be.

    Don’t wait, it’s worth every penny + your inbox (and wallet) will thank you!

    So what are you waiting for?

    Overcome your fears and achieve your goals.

    Make a meaningful impact in the healthcare, medicine, and wellness industries without burning out starting today with GetClientsMD.

    Trust me, you won’t regret it!

    Let’s make those clients come running together!

    P.S. Hurry and take advantage of this limited-time offer! I can only accept 10 beta customers, so join now before all the first ten spots are gone…

    P.P.S. Instead of paying $799 monthly, get it for $399 monthly. That’s $400 monthly off. 10 orders only. Clock’s ticking ⏰

    444 Alaska Avenue, Torrance 90503 US

    Unsubscribe at: 123bye d0t c0m

  2. Hi there,

    I was wondering if youd be interested in getting paid for doing simple social media jobs?

    You can do the work online with full training provided.

    Our pay begins at $30 per hour and increases from there.

    You can find out more here: https://shorturl.at/BDMQ4

    Thanks
    Harry

  3. Hi there,

    I wanted to reach out to introduce you to our premium license for WordPress plugins and themes that brings you unparalleled convenience and benefits.

    With 25,000+ plugins/themes available, automatic updates, one-click installation, and the ability to resell, you can boost functionality, aesthetics, and security while saving time and money. No coding skills required.

    If you would like to try the plugin demo for free, so you can decide for yourself, just get back in touch.

    Best regards,
    Sarah

  4. Heya i am for the first time here. I came across this board and I find It
    really useful & it helped me out much. I hope to give something back and help others like you helped me.

Leave a Reply

Your email address will not be published. Required fields are marked *