mysql-connector-python | MySQL Connector/Python is implementing the MySQL Client | Database library

You cannot use the MySQL connector to connect to an Azure SQL database. There's a difference between a MySQL database and an Azure SQL database.

You can either use Azure Database for MySQL as a database, or check out this example on how to Use Python to query a SQL database, which uses an ODBC driver. As you can see in the linked article, they exist for macOS, Ubuntu and Windows.

I think the problem might be because Airflow 2 uses a newer Debian which does not support TLS v1.

I am not 100% sure how you should configure your MySQL/Client but this sounds awfully similar to MySQL ERROR 2026 - SSL connection error - Ubuntu 20.04

The solution is either to disable SSL (not recommended) or decrease security level of Debian (not recommended) or make sure that you use TLS v2

Apparently this can be done via changing your MySQL seetings and restarting it:

As @TimRoberts and @Dhivakar Chelladurai said in te comments, the solution is to find a version of MySQL-Connector-Python for Python2 or Python3.5 max as this is the last version that Debian 9 has for Python3.

1. Download:

I figured this out myself. The solution is to create a singleton class to define the connection pool and then instantiate it only once inside the factory function. Once the connection pool is initialised, we can store it in the app.config dictionary object so that it is accessible by other modules throughout the lifespan of the application. We may need to use the current_app reference while creating a connection from the pool.

This problem appears to be caused by using the default Raspbian install of Python, which is Python 2.7.

Use Python 3 instead. It is also installed on Raspbian. Use python3 and pip3 in place of python and pip.

You can't mix values and a subquery like that, but you could query the value you meant to have in the values clause instead:

its seens you are looking for the ARG instruction. it's only avaible at the building time and won't be avaible at image runtime. Don’t use them for secrets which are not meant to stick around!

The syntax you've tried would be for multiple commands, which is not its goal.

(1 entrypoint, 1 command)

https://docs.docker.com/compose/compose-file/compose-file-v3/#command

You can either write it this way

The main issue was related to code runner. uninstall, then install did the trick.

I often face some error because of code runner not connecting to the right environment or not reading new package. Normally, restarting the visual studio code session or the whole software solve it, but not in this case.