If web2py uses pymysql, then it should not work with version 3:
(pymysql) Requirements
Python 2.4 or higher
http://www.python.org/
2.6 is the primary test environment.
MySQL 4.1 or higher
protocol41 support, experimental 4.0 support
With some modifications, it should be possible to accept another
library in the MySQL adpater. For example, PostgreSQL adpater now
accepts two optional db interface libraries specified in the db uri.
On 3 mar, 13:52, Ralo Tannahill <[email protected]> wrote:
> Hello all
>
> I'm new to python and web2py, and I'm evaluating them to make new
> developments accessing legacy databases (MSSQL 2000, MySQL 3 and MySQL 5 ).
> I've tried the connection strings shown in the web2py book, but I can
> connect only to MySQL 5.
>
> - The error connecting to MySQL 3 is "access denied for user
> @databaseServer (using password: NO)", because no username or password is
> passed to the server .
> Is it a problem with pymysql? Searching in google, I found the python
> module "MySQLdb" and with that module I can connect to both MySQL 3 and 5.
> Could I configure web2py to use MySQLdb instead of pymysql?
>
> - The error connecting to MSSQL says that I don't specify a DSN or driver
>
> I am using CENTOS 6 (64bits) + python 2.6 + apache + mod_wsgi
> I'd appreciate any help, thanks in advance
