How do I connect to a MySQL Database in Python with a RaspberryPi

Question

I'm a student and I'm trying to write some sensor values into a MySQL database.

As IDE I'll be using Inteliji. First off I started by installing the database Plug-in.

• This was done successfully

Next I tried to connect to the data base (see figure below)

Figure of successful connection

Now The next thing I want to do is use a MySQL connector. Therefore I've installed MySQL onto the r-PI and used following code to implement it.

import mysql.connector
print("Step 1")
cnx = mysql.connector.connect(user='a21ib2a01', 
                              password='secret',
                              host='mysql.studev.groept.be',
                              database='a21ib2a01')
Print("Step 2")

When now I run my code the terminal will output:

Step1

For some reason I don't know; the connect function always times my program out with the next occurring errors:

mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'mysql.studev.groept.be:3306' (110 Connection timed out)

So does anyone know why my connection is successful but I can't connect to it? Long story short what am I doing wrong and how do I fix this?

Thanks in advance!