Ubuntu – How to Access MySQL with Python Version 3.4

MySQLpython

Python comes in two versions: Python 2.7.6 which has now been superseded by Python 3.4.0. The critical line in Python to access MySQL is "import MySQLdb"

Thanks to a response from StackOverFlow, I realized that I was unintentionally accessing MySQL through Python version 2.7.6. Apparently, "MySQLdb" is not compatible with Python version 3.4.0.

Searching the internet has disclosed alternatives for connecting Python to MySql, however, many of the suggestions do not disclose whether the offered solutions would actually work with Python version 3.4.0.

This StackOverFlow Post listed some possible solutions. Python 3.4.0 with MySQL database. I installed mysqlclient 1.3.6, I also ran "sudo pip install PyMySQL" with out error.

However, upon entering python with "python3"; I still received the error message "ImportError: No module named 'MySQLdb'" after typing in: "import MySQLdb". So something was still wrong.

As an FYI MySQL evidently has its own connector, but I don't know whether it works or does not work with Python 3.4. Connecting to MySQL Using Connector/Python I will have to look into this more.

Any advice on how to connect Python 3.4 with MySQL?

Best Answer

The documentation for MySQL Connector/Python says Version 2.0 should work with MySQL Server 5.5-5.7 and Python 3.3 and later. So I would say it's a good bet. If it doesn't work, follow up with what error you encounter and I'll see if I can help.

Related Solutions

Ubuntu – How to install sympy for Python 3.4

You can use pip3 (which is just normal pip but in system's Python3 packages). Normally I would suggest avoiding using pip for installing stuff globally but given there are no packages for this that could overwrite the files, there's nothing to lose.

It's quick and simple:

sudo apt-get install python3-pip
sudo pip3 install sympy

Ubuntu – Python 3.4 on Ubuntu 16.04

Revised from Creating a virtual environment with python3.4 on Ubuntu 16.04 Xenial Xerus:

Install dependencies.
sudo apt install build-essential checkinstall  
sudo apt install libreadline-gplv2-dev libncursesw5-dev libssl-dev libsqlite3-dev tk-dev libgdbm-dev libc6-dev libbz2-dev openssl  
Get python3.4 source code.
mkdir -p $HOME/opt  
cd $HOME/opt  
curl -O https://www.python.org/ftp/python/3.4.3/Python-3.4.3.tgz  
tar xzvf Python-3.4.3.tgz  
cd Python-3.4.3
Configure and install.
./configure --enable-shared --prefix=/usr/local LDFLAGS="-Wl,--rpath=/usr/local/lib"  
sudo make altinstall  
--enable-shared is necessary for some libraries. The --prefix is needed for reasons (more information in this answer). make altinstall keeps your python3.5 installation as the default one.
Create a python3.4 virtualenv.

Now we can create a new virtual environment and activate it:
python3.4 -m venv Python3.4VirtualEnv  
. Python3.4VirtualEnv/bin/activate

pip3 is installed by default when the Python 3.4 virtual environment is created. List installed packages:

pip3 list

Returns

Flask (0.11.1)

Type flask --help to show Flask help. This output shows that Flask has been successfully installed in a Python virtual environment for Python 3.4.

Related Question