3,184 questions
0
votes
1
answer
47
views
No connection to MySQL-database - PythonAnywhere/ Beginners Plan
Attempt to connect to MySQL-database by module MySQLdb fails and will be responded by: name 'MySQLdb' is not defined... in the servers log. Environment is not virtual, framework is Flask
The ...
0
votes
0
answers
65
views
Building wheel for mysqlclient (pyproject.toml) did not run successfully
I'm trying to install mysqldb on python3.8 (Windows 11 24H2).
I initially had issues with VSC++14 but I managed to solve them.
pip install -U flask_mysqldb
error: subprocess-exited-with-error
...
0
votes
0
answers
50
views
Python 3 Flask MySQL connection and handle error
I am build a system include server, mobile app and desktop app.
server.py
from flask import Flask, jsonify, request, g, send_file
from flask_cors import CORS
import mysql.connector
import data.data as ...
0
votes
0
answers
25
views
Mysql 5.5..33 : (5010, "Authentication plugin 'mysql_old_password' couldn't be found in restricted_auth plugin list.") [duplicate]
When I am trying to connect the MySQL db that hosted in remote via the python library MySQLdb, I am getting the following error.
(5010, "Authentication plugin 'mysql_old_password' couldn't be ...
- 1,321
0
votes
3
answers
348
views
mysql.connector.connect failing to connect
While trying to connect Python with SQL, it just does not work, with no errors, the execution stops itself, here's the code:
import mysql.connector
def appen():
print('k')
mysq = mysql....
- 27
1
vote
1
answer
72
views
Saving data to the database in django [duplicate]
I am working on a website to recommend stocks on the stock market, based on historically reliable trading strategies.
When running the server, I can't see any of the data which is supposed to be shown ...
0
votes
0
answers
36
views
I am having a problem in MySQL connection in Python which I never had before [duplicate]
Traceback (most recent call last):
File "S:\Python\lib\site-packages\mysql\connector\network.py", line 733, in open_connection
self.sock.connect(sockaddr)
ConnectionRefusedError: [...
0
votes
0
answers
77
views
Unable to connect MySQL (xampp) using Python
import mysql.connector
conn = mysql.connector.connect(host="localhost", user="root", password="")
if conn.is_connected():
print("Successful")
else:
...
0
votes
0
answers
38
views
Wagtail django.db.utils.OperationalError: (1463, "Non-grouping field 'numchild' is used in HAVING clause")
I'm working on a Django project and I've encountered an issue that I'm unable to resolve. When I try to run my application, I get the following error:
django.db.utils.OperationalError: (1463, "...
- 11
0
votes
1
answer
70
views
Can't connect to mysql database from the python code using mysql.connector
I m unable to connect to my database and it gives this error that object is not callable. I did search up the error and even what it means. I changed a lots of stuff in the code but it didn't work for ...
- 11
0
votes
1
answer
84
views
Permission danied when reading file from /var/lib/mysql-files
I am using cursor.execute to generate the file my_file.csv and save it in /var/lib/mysql-files.
Here is my code:
import mysql.connector
connection = mysql.connector.connect(host='localhost', port='...
- 25
1
vote
0
answers
20
views
Error to parse pickled data to/from database [duplicate]
I am trying to store pickled object into database and unpickle it back.
Data is being stored in database, however after reading data its throwing an error during unpickle.
Traceback (most recent call ...
- 11
2
votes
0
answers
122
views
How do I use a loop to update the progress of my entire code in python using a progress bar
I have a code that pulls data from mysql database using python mysql connector and I want to create a progress bar in python using tkinter that shows query execution progress.
I have created a loop ...
- 51
0
votes
0
answers
31
views
ERROR: root: Error fetching patient details: PatientView.html
I'm trying to create a simple webpage using Flask. I have written code to fetch data from a MySQL database, but the code is not working, and I keep getting the error:
Error:
root: Error fetching ...
1
vote
0
answers
55
views
SQLAlchemy difference between regular query and text
I am trying to insert new rows in a table that might already exist with constant values given from my application.
I have tried to create the following code:
with engine.begin() as con:
con....
- 131