Hello,
I am having some trouble connecting to a MySQL server running on my
local machine (Macbook Pro running Snow Leopard with My SQL 5.1.46).
I use the following connection string:
db = DAL('mysql://root:passw...@localhost/test', pool_size=10)
and I get the following error:
Traceback (most recent call last):
File "gluon/restricted.py", line 178, in restricted
File "/Applications/web2py.app/Contents/Resources/applications/
FWv7_12/models/db.py", line 9, in <module>
File "gluon/sql.py", line 3840, in DAL
RuntimeError: Failure to connect to DB. Tried 5 times
I do have the python-mysql driver properly installed. Also, I am able
to connect to the database named 'test' both from the shell and using
a third party MySQL app (Sequel Pro). There are no existing tables in
the 'test' database to begin with. Any ideas why the connection may be
failing?
Avik
