MySQL does not work after installation

Asked May 13 '15 at 04:45

Active May 13 '15 at 05:30

Viewed 68 times

Hi I am new to Python as well as database implementation. After installing MySQL and trying to import it in my Python script (import MySQLdb), but I got this in return:

Traceback (most recent call last):
  File "C:/Users/opsu/PycharmProjects/FirstProject/src/Test2.py", line 2, in <module>
    import MySQLdb
  File "C:\Python27\lib\site-packages\MySQLdb\__init__.py", line 19, in <module>
    import _mysql
 ImportError: DLL load failed: %1 is not a valid Win32 application.

Process finished with exit code 1

1 suggestion I got from google was to uninstall python 64bit and install python 32 bit. However I am also using wxPython 64bit so I cannot do this. Can anyone help me solve this problem?

edited May 13 '15 at 05:30

jon snow

3,062
1
19
31

asked May 13 '15 at 04:45

annena

which version of python are you using 2.x or 3.x? – Ankit May 13 '15 at 04:50
Your only option around this problem is to install the 32 bit of Python and use that with the 32 bit MySQL version you have. – Tim Biegeleisen May 13 '15 at 04:53
@Ankit I am using 2.7 – annena May 13 '15 at 04:55
@TimBiegeleisen but will it afftect my wxPython? Do i have to change wxPython to 32bit also? – annena May 13 '15 at 04:56
You could also try using a 64 bit version of MySQL which will play friendly with your current Python installation. – Tim Biegeleisen May 13 '15 at 04:57
Thanks a lot! I downloaded the 64 bit mysql and it worked :D – annena May 13 '15 at 06:08

MySQL does not work after installation

0 Answers0