I did the steps below with Python 3.5.1 and it works:
- Download driver from here
- Driver installation in cmd, in this folder Python\Python35\PyMySQL-0.7.4\pymysql
python setup.py build python setup.py install - Copy folder Python\Python35\PyMySQL-0.7.4\pymysql to Python\Python35\pymysql
- Sample code in python IDE
import pymysql import pymysql.cursors conn= pymysql.connect(host='localhost',user='user',password='user',db='testdb',charset='utf8mb4',cursorclass=pymysql.cursors.DictCursor) a=conn.cursor() sql='CREATE TABLE `users` (`id` int(11) NOT NULL AUTO_INCREMENT,`email` varchar(255) NOT NULL,`password` varchar(255) NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;' a.execute(sql) - Enjoy It!
Related Posts:
- Best way to convert string to bytes in Python 3?
- Does Python have a string ‘contains’ substring method?
- Difference between import numpy and import numpy as np
- No module named ‘sklearn.cross_validation’
- Maximum and Minimum values for ints
- FileNotFoundError: [Errno 2] No such file or directory [duplicate]
- python capitalize first letter only
- Is there a short contains function for lists?
- ImportError: No module named pandas. Pandas installed pip
- How to Execute a Python Script in Notepad++?
- ValueError: operands could not be broadcast together with shapes (5,) (30,)
- Best way to strip punctuation from a string
- How can I explicitly free memory in Python?
- filename.whl is not supported wheel on this platform
- What is the meaning of [:] in python [duplicate]
- Finding and replacing elements in a list
- socket.error: [Errno 48] Address already in use
- No module named MySQLdb
- TypeError: Missing 1 required positional argument: ‘self’
- Convert a tensor to numpy array in Tensorflow?
- How to import the class within the same directory or sub directory?
- Why do I get AttributeError: ‘NoneType’ object has no attribute ‘something’?
- What is __pycache__?
- Permission denied error by installing matplotlib
- Python equivalent of a given wget command
- How to find list intersection?
- Error while Executing jupyter notebook: [Errno 2] No such file or directory
- ValueError: max() arg is an empty sequence
- How do I insert a JPEG image into a python Tkinter window?
- Use a.any() or a.all()
- What is the easiest way to remove all packages installed by pip?
- In practice, what are the main uses for the new “yield from” syntax in Python 3.3?
- Subplot for seaborn boxplot
- Dump a NumPy array into a csv file
- How to delete a character from a string using Python
- What is the difference between sparse_categorical_crossentropy and categorical_crossentropy?
- Inverse of a matrix using numpy
- NameError: name ‘self’ is not defined
- gaierror: [Errno 8] nodename nor servname provided, or not known (with macOS Sierra)
- How to print colored text to the terminal
- TypeError: can only concatenate list (not “str”) to list
- What’s the idiomatic syntax for prepending to a short python list?
- What is the difference between “is None” and “== None”
- Why Python 3.6.1 throws AttributeError: module ‘enum’ has no attribute ‘IntFlag’?
- IndexError: list index out of range and python
- Don’t understand why UnboundLocalError occurs (closure) [duplicate]
- OSError – Errno 13 Permission denied
- ImportError: No module named ‘Queue’
- ImportError: No Module Named bs4 (BeautifulSoup)
- How to calculate rolling / moving average using python + NumPy / SciPy?
- How to fix “Attempted relative import in non-package” even with __init__.py
- Errno 13 Permission denied Python
- How to get all possible combinations of a list’s elements?
- Converting strings to floats in a DataFrame
- Pylint “unresolved import” error in Visual Studio Code
- Errno 13 Permission denied Python
- ValueError: object too deep for desired array while using convolution
- How to convert string to binary?
- How to iterate through two lists in parallel?
- Make list of arrays in python
- In Python, what is `sys.maxsize`?
- double for loops in python
- Convert hex string to int in Python
- Function to close the window in Tkinter
- Is there a way to specify which pytest tests to run from a file?
- Python function overloading
- Breaking out of nested loops
- Youtube_dl : ERROR : YouTube said: Unable to extract video data
- How to stop a function
- What is the common header format of Python files?
- Is it possible to decompile a compiled .pyc file into a .py file?
- How to clear up screen in pygame?
- Efficiently sorting a numpy array in descending order?
- How to replace multiple substrings of a string?
- How to use cookies in Python Requests
- Move column by name to front of table in pandas
- How to search through dictionaries?
- Element-wise addition of 2 lists?
- Converting integer to binary in python
- Open File in Another Directory (Python)
- Python: Making a beep noise
- Negation in Python
- Checking if a string can be converted to float in Python
- Python conversion from binary string to hexadecimal
- ERROR: Could not build wheels for cryptography which use PEP 517 and cannot be installed directly
- ImportError: No module named Cython.Distutils
- Python Brute Force algorithm
- What’s the correct way to convert bytes to a hex string in Python 3?
- How can I install a .egg Python package on Windows (attempt using easy_install not working)
- Case insensitive regular expression without re.compile?
- replace characters not working in python [duplicate]
- ElementClickInterceptedException: element click intercepted:
- During handling of the above exception, another exception occurred
- Python Remove last char from string and return it
- Base language of Python
- numpy/scipy/ipython:Failed to interpret file as a pickle
- What is the Python equivalent of static variables inside a function?
- Python – difference between two strings
- Flask-framework: MVC pattern
- Installing win32gui python module