flask-mysqldb | MySQL extension for the Flask web framework | SQL Database library

You'll apparently have to tell flask the proper path to the socket file (/opt/lampp/var/mysql/mysql.sock, as you know; currently it seems to be looking at /var/run/mysqld/mysqld.sock).

According to the documentation, you'll need to use the MYSQL_UNIX_SOCKET configuration directive along with your other directives for setting things like the username, password, etc, such as app.config['MYSQL_UNIX_SOCKET'] = '/opt/lampp/var/mysql/mysql.sock'.

This answer should point you in the right direction.

You're using old mysqlclient 1.3.12 with new MySQL 8. Either you need to downgrade MySQL to version 5.6. Or you need to use later mysqlclient.

The incompatibility was fixed in commit a2ebbd2 on Dec 21, 2017 so you need a later version of mysqlclient.

mysqlclient 1.3.13 was released on Jun 27, 2018. Try it or any later version.

You go to

You may want to consider the Flask-SQLAlchemy package to help you with this.

Although the syntax is going to be slightly different from Perl, what you can do is, when you create the model object, you can set it to a variable. Then, when you either flush or commit on the Database session, you can pull up your primary key attribute on that model object you had created (whether it's "id" or something else), and use it as needed.

SQLAlchemy supports MySQL, as well as several other relational databases. In addition, it is able to help prevent SQL injection attacks so long as you use model objects and add/delete them to your database session, as opposed to straight SQL commands.

Finally solved with docker container, I created docker environment In AWS ElasticBeanstalk and deployed it, and now it works fine, below shows my config file and Dockerfile

Dockerfile

You'll have to install Visual Studio Build Tools and MySQL connector

or

Install mysqlclient through unoficiall wheel by downloading it and installing

You need to config the env path to the VS Code.

List of environments VS Code found.

Usually, VS Code can get env from /usr/bin/ directory and from env/ directory inside your working folder. You can create a python environment by using python3 -m venv env command

Select environment by clicking this inside the bottom bar( this is only appear when you open *.py file.

The error message is pretty clear:

OSError: mysql_config not found

You need mysql_config. Install either libmariadbclient-dev or libmysqlclient-dev with apt.

Then try using pip again, but not with sudo.

Mixing system-level Python packages and pip-installed packages is a recipe for disaster. It looks like you already have a virtualenv for your project, so use that. Bonus points if you specify your dependencies in a requirements.txt file or Pipfile.

Flask_mysqldb depends on mysqlclient-python which says this about installing on Windows:

Building mysqlclient on Windows is very hard. But there are some binary wheels you can install easily.

Here's the list of wheels for the current version:

https://pypi.org/project/mysqlclient/1.4.6/#files

You can download the one that fits your platform and then install with pip install filename.whl Then you should be able to install flask_mysqldb without that error.