mysql-python Questions
0
I couldn't find anything online about this.
When I start a docker container with mysql for the first time, it results very slow at startup (it takes up to 5 minutes to start). Then the next few tim...
Industrials asked 28/1, 2023 at 9:55
13
Solved
I'm not asking for the SHOW COLUMNS command.
I want to create an application that works similarly to heidisql, where you can specify an SQL query and when executed, returns a result set with rows ...
Offensive asked 15/2, 2011 at 22:1
36
I am trying to get a Python script to run on the linux server I'm connected to via ssh. The script uses mysqldb. I have all the other components I need, but when I try to install mySQLdb via setupt...
Heliotherapy asked 19/9, 2011 at 18:0
2
I'm running MySQLdb v1.2.3 and getting the following error:
LookupError: unknown encoding: utf8mb4
This answer suggests updating MySQLdb to version 1.2.5. I updated and am now getting this error:
...
Profant asked 7/3, 2016 at 20:53
12
Solved
I am trying to install version 1.2.2 of MySQL_python, using a fresh virtualenv created with the --no-site-packages option. The current version shown in PyPi is 1.2.3. Is there a way to install the ...
Alverson asked 7/3, 2011 at 22:58
9
Solved
I want to connect MySQL database to my django project, but it is throwing an error :
"django.core.exceptions.ImproperlyConfigured: Requested setting
USE_I18N, but settings are not configured. Y...
Backpedal asked 7/12, 2017 at 17:15
8
After finishing of one of my Flask projects, I uploaded it on github just like everybody else. after a 2-3 months period I downloaded the entire githube repository on another machine to run it. How...
Merganser asked 27/10, 2018 at 18:11
5
I want to run a Django application in PyCharm which works on MySQL DB.
I am unable to connect my program to the database.
When I am trying to install MySQLclient or MySQL-python I am getting the...
Shelah asked 15/4, 2017 at 13:42
10
Solved
I want to install MySqlclient on my windows system. I am Currently using Python 3.6. After going through the various post over Stackoverflow, I could Not find the correct way.
This is what I have ...
Cartridge asked 3/7, 2018 at 3:6
3
Solved
I tried to make a MySQL connection with peewee and followed the tutorial from their website:
peewee quickstart
So my code is the following:
from peewee import *
db = MySQLDatabase(
host='127.0.0....
Chondriosome asked 13/7, 2020 at 12:1
3
Solved
I am getting ImportError: No localization support for language 'eng' when using MySQL Connector in Python.
My Traceback is as below.
Traceback (most recent call last):
File \"DB_Module.py\", line...
Peculation asked 9/4, 2013 at 4:3
14
I face this problem when I want to install mysql-python on osx 10.8, it show error with 'my_config.h' file not found.
Below is my running code:
sudo easy_install mysql-python
Password:
Searching ...
Corsair asked 31/8, 2012 at 15:17
16
Solved
I am referring the following tutorial to make a login page for my web application.
http://code.tutsplus.com/tutorials/intro-to-flask-signing-in-and-out--net-29982
I am having issue with the databa...
Streamline asked 7/3, 2014 at 14:12
0
I read a column's length in the code given below. Then, I have a list fakeNames whose length is equal to the column's original length.
How can I replace the values of the original column person_nam...
Crossbred asked 16/6, 2022 at 7:22
8
Solved
I have installed tools via xcode-select --install but still show the following error while doing pip install MySQL-python
Building wheels for collected packages: MySQL-python
Running setup.py bdi...
Winnah asked 20/6, 2018 at 4:38
3
I am new to Mac and i am trying to install MySQLdb for Python on MAC but after following the steps mentioned on http://www.tutorialspoint.com/python/python_database_access.htm, i received an error ...
Cleome asked 7/2, 2014 at 21:51
5
Solved
In Python mysqldb I could declare a cursor as a dictionary cursor like this:
cursor = db.cursor(MySQLdb.cursors.DictCursor)
This would enable me to reference columns in the cursor loop by name ...
David asked 31/3, 2014 at 18:55
8
Solved
I'm trying to install MySQLdb extension, but I get this error any idea what may be the cause? Could be something with permissions? I'm using Mac OX Lion....
This is a part of the error a got. Dja...
Giddy asked 9/1, 2013 at 19:25
2
Solved
I need to update a row if a record already exists or create a new one if it dosen't. I undersant ON DUPLICATE KEY will accomplish this using MYSQLdb, however I'm having trouble getting it working. ...
Transpolar asked 17/3, 2013 at 19:57
4
I'm trying to set up a MySQL connection pool and have my worker processes access the already established pool instead of setting up a new connection each time.
I'm confused if I should pass the da...
Rhodia asked 23/6, 2014 at 19:43
6
I have read every single post and googled for the last 4 hours to try to find a solution to this error.
I am not running virtual environment, this server is just for django.
Server: Ubuntu 16.04
...
Miliary asked 21/6, 2018 at 13:47
2
I have this code to connect to a rds instance:
import MySQLdb
USERNAME = 'root'
PASSWORD = 'pass'
DB_NAME = 'databasetest2'
print "Connecting to RDS instance"
conn = MySQLdb.connect ( host = 'm...
Selfinduction asked 17/4, 2015 at 18:38
6
Solved
I am trying to do the following insert operation:
cursor.execute("""
insert into tree (id,parent_id,level,description,code,start,end)
values (%d,%d,%d,%s,%s,%f,%f)
""", (1,1,1,'abc','def',1,1)
...
Nedranedrah asked 26/4, 2011 at 2:1
5
I've installed MySQL-python on mac with following procedure :
pip uninstall MySQL-python
brew install mysql
pip install MySQL-python
Then test it :
python -c "import MySQLdb"
When I test it, ...
Nival asked 17/6, 2015 at 2:34
1
I use the following line of code in order to connect to a database instance of my computer.
cnx = mysql.connector.connect(host=Host, user=User, password=Password, database=db, auth_plugin='mysql_n...
Lexicography asked 27/6, 2018 at 15:36
© 2022 - 2025 — McMap. All rights reserved.