for 64-bit windows install using wheel pip install wheel download from http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python For python 3.x: pip install mysqlclient-1.3.8-cp36-cp36m-win_amd64.whl For python 2.7: pip install mysqlclient-1.3.8-cp27-cp27m-win_amd64.whl
mySQLdb is a python interface for mysql, but it is not mysql itself. And apparently mySQLdb needs the command ‘mysql_config’, so you need to install that first. Can you confirm that you did or did not install mysql itself, by running “mysql” from the shell? That should give you a response other than “mysql: command … Read more
I am not certain, but I am going to guess you are using a INNODB table, and you haven’t done a commit. I believe MySQLdb enable transactions automatically. Call conn.commit() before calling close. From the FAQ: Starting with 1.2.0, MySQLdb disables autocommit by default
I solved the problem by creating a symbolic link to the library. I.e. The actual library resides in /usr/local/mysql/lib And then I created a symbolic link in /usr/lib Using the command: sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib so that I have the following mapping: ls -l libmysqlclient.18.dylib lrwxr-xr-x 1 root wheel 44 16 Jul 14:01 libmysqlclient.18.dylib … Read more
All I had to do was go over to oracle, and download the MySQL Connector C 6.0.2 (newer doesn’t work!) and do the typical install. https://downloads.mysql.com/archives/c-c/ Be sure to include all optional extras (Extra Binaries) via the custom install, without these it did not work for the win64.msi Once that was done, I went into … Read more
It seems mysql_config is missing on your system or the installer could not find it. Be sure mysql_config is really installed. For example on Debian/Ubuntu you must install the package: sudo apt-get install libmysqlclient-dev Maybe the mysql_config is not in your path, it will be the case when you compile by yourself the mysql suite. … Read more
Globals in Python are global to a module, not across all modules. (Many people are confused by this, because in, say, C, a global is the same across all implementation files unless you explicitly make it static.) There are different ways to solve this, depending on your actual use case. Before even going down this … Read more
TL;DR: pip install -Iv (i.e. pip install -Iv MySQL_python==1.2.2) What these options mean: -I stands for –ignore-installed which will ignore the installed packages, overwriting them. -v is for verbose. You can combine for even more verbosity (i.e. -vv) up to 3 times (e.g. -Ivvv). For more information, see pip install –help First, I see two … Read more