Any insight would be appreciated. Follow Post Reply. I'm also looking for a MySQLdb binary for windows. This is holding me from upgrading from Python 2. Or does anybody know of alternatives?
I have to connect directly to an MySQL database. Henk HI All, Does such a beast exist? Robin Becker. Chris I'm just trying to build from source and am having problems getting the right parameters for the setup.
It seems mysql Jan Dries. That's how I got my binaries. Regards, Jan. John Nagle. Want to install that executable, as root, on your production machines? You're not the only person having problems with Python 2.
Here's an explanation how it should run under Python 2. On Python 3. You can try to use myPySQL. It's really easy to use; no compilation for windows, and even if you need to compile it for any reason, you only need Python and Visual C installed not mysql. Have you tried those? I had problems following the steps with Willie's answer, but I determined that the problem is probably that I am running windows 7 x64 install, which puts the registry key for mysql in a slightly different location, specifically in my case note: I am running version 5.
After working through all of this, IMO it would have been smarter to run the entire python dev environment from cygwin. You might want to also consider making use of Cygwin , it has mysql python libraries in the repository. Unixodbc is also available to make the code compatible on Linux. Got sick of the installation troubles with MySQLdb and tried pymysql instead. Stack Overflow for Teams — Collaborate and share knowledge with a private group.
Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 12 years, 10 months ago. Active 4 years, 4 months ago. Viewed k times. Any help? Braiam 4, 11 11 gold badges 50 50 silver badges 73 73 bronze badges. Sammy Sammy 1, 2 2 gold badges 9 9 silver badges 10 10 bronze badges. Since 3 years have passed since this was asked, and 2 years since last high voted answer, see updated answer for Python 3.
Add a comment. Active Oldest Votes. You can install it from here more instructions here , and then run: pip install pymysql. Community Bot 1 1 1 silver badge. With MySQL-python The results showed that the root user had all privileges. In my python code I was using root as my user I.
The solution was that my HOST name was incorrect. Opened up the localhost instance and went to users and privileges. Sure enough the HOST name corresponding to the root user was localhost. Here is my connection code:. You are commenting using your WordPress. You are commenting using your Google account.
Use pip version This page is not a pip package index. Many binaries are not compatible with Windows XP or Wine.
0コメント