Skip to content
Home » Connect to a MySQL Database

Connect 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 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’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 — and
  • Create a user that has only reading rights

I host my MySQL database in Google Cloud Platform: whitelisting the IP addresses of 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'@'%';

Finally, fill in the credentials in the 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’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 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.

2 thoughts on “Connect to a MySQL Database”

  1. Your Site Has Been Hacked


    We have hacked your website and extracted your databases.

    How did this happen?

    Our team has found a vulnerability within your site that we were able to exploit. After finding the vulnerability we were able to get your database credentials and extract your entire database and move the information to an offshore server.

    What does this mean?

    We will systematically go through a series of steps of totally damaging your reputation. First your database will be leaked or sold to the highest bidder which they will use with whatever their intentions are. Next if there are e-mails found they will be e-mailed that their information has been sold or leaked and your site was at fault thusly damaging your reputation and having angry customers/associates with whatever angry customers/associates do. Lastly any links that you have indexed in the search engines will be de-indexed based off of blackhat techniques that we used in the past to de-index our targets.

    How do i stop this?

    We are willing to refrain from going through with these actions for a small fee. The amount: $3500 (0.15 BTC)

    The Address Part 1: bc1qz0hwyvdrq5xvfwcm9

    The Address Part 2: m5eg7kjktvsux4r058v6g

    So, you have to manually copy + paste Part1 and Part2 in one string made of 42 characters with no space between parts that start with “b” and end with “g” is, the actually address where you should send the payment. Once you have paid we will automatically get informed that it was your payment. Please note that you have to make payment within 72 hours after seeing this message or the database leak, e-mails dispatched, and de-index of your site WiLL start!

    How do i get Bitcoins?

    You can easily buy bitcoins via several websites or even offline from a Bitcoin-ATM.

    What if i don’t pay?

    if you decide not to pay, we will start the attack at the indicated date and uphold it until you do, there’s no counter measure to this, you will only end up wasting more money trying to find a solution. We will completely destroy your reputation amongst google and your customers.

    This is not a hoax, do not reply to this email, don’t try to reason or negotiate, we will not read any replies. Once you have paid we will stop what we were doing and you will never hear from us again!

    Please note that Bitcoin is anonymous and no one will find out that you have complied. Finally don’t reply as this email is unmonitored.

Leave a Reply

Your email address will not be published.