MySQL Connection String Failes

[shannon.j.chaney@…]

Hello: Currently running the following:

Distributor ID:	Ubuntu 16.04 xenial
apache2: Installed: 2.4.18-2ubuntu3.1
mysql-server: Installed: 5.7.15-0ubuntu0.16.04.1

Services:
apache2.service - LSB: Apache2 web server
   Loaded: loaded (/etc/init.d/apache2; bad; vendor preset: enabled)
  Drop-In: /lib/systemd/system/apache2.service.d
           └─apache2-systemd.conf
   Active: active (running) since Fri 2016-09-16 14:59:00 EDT; 45min ago
     Docs: man:systemd-sysv-generator(8)
  Process: 28298 ExecStart=/etc/init.d/apache2 start (code=exited, status=0/SUCC
   CGroup: /system.slice/apache2.service
           ├─28314 /usr/sbin/apache2 -k start
           ├─28315 /usr/sbin/apache2 -k start
           └─28316 /usr/sbin/apache2 -k start

Sep 16 14:59:00 GRSLW16080193L systemd[1]: Starting LSB: Apache2 web server...
Sep 16 14:59:00 GRSLW16080193L apache2[28298]:  * Starting Apache httpd web serv
Sep 16 14:59:00 GRSLW16080193L apache2[28298]: AH00558: apache2: Could not relia
Sep 16 14:59:00 GRSLW16080193L apache2[28298]:  *
Sep 16 14:59:00 GRSLW16080193L systemd[1]: Started LSB: Apache2 web server.

mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en
   Active: active (running) since Fri 2016-09-16 14:11:04 EDT; 1h 33min ago
 Main PID: 21921 (mysqld)
   CGroup: /system.slice/mysql.service
           └─21921 /usr/sbin/mysqld

Sep 16 14:11:03 GRSLW16080193L systemd[1]: Starting MySQL Community Server...
Sep 16 14:11:04 GRSLW16080193L systemd[1]: Started MySQL Community Server.

mysql -u tracuser -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.7.15-0ubuntu0.16.04.1 (Ubuntu)

sudo trac-admin /usr/share/trac/projects/my-project initenv
Database connection string [sqlite:db/trac.db]> mysql://tracuser:letmein@localhost:3306/trac

Creating and Initializing Project
Initenv for '/usr/share/trac/projects/my-project' failed. 
Failed to create environment.
Cannot load Python bindings for MySQL
Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/trac/admin/console.py", line 463, in do_initenv
    options=options)
  File "build/bdist.linux-x86_64/egg/trac/core.py", line 124, in __call__
    self.__init__(*args, **kwargs)
  File "build/bdist.linux-x86_64/egg/trac/env.py", line 280, in __init__
    self.create(options)
  File "build/bdist.linux-x86_64/egg/trac/env.py", line 603, in create
    DatabaseManager(self).init_db()
  File "build/bdist.linux-x86_64/egg/trac/db/api.py", line 250, in init_db
    connector, args = self.get_connector()
  File "build/bdist.linux-x86_64/egg/trac/db/api.py", line 339, in get_connector
    raise TracError(connector.error)
TracError: Cannot load Python bindings for MySQL

Used MySQL connection string from TracEnvironment and MySqlDb.

What is the proper way to make the connection to MySQL?

[Jun Omae]

InstallationIssue.

Install ​MySQL-python. See also MySqlDb#MySQLdb and ​https://packages.ubuntu.com/precise/python-mysqldb.