Odd MySQL connection problem

44 views
Skip to first unread message

backseat

unread,
Sep 18, 2019, 3:05:50 PM9/18/19
to web2py-users
I'm getting:

...
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
   
raise errorvalue
OperationalError: (1045, "Access denied for user 'pytrack2'@'localhost' (using password: YES)")

The password, user and database are accessible from the command line.

How can I debug this?

What output can I show here to help?

Thanks,
Keith

backseat

unread,
Sep 22, 2019, 4:47:46 AM9/22/19
to web2py-users
Resolution, in case anyone else sees this:

I had imported the database from our production system. The database includes a view. The database username, and thus the view creator name, are different on the production vs development system. That means the view is not visible to the MySQL user on the development system. Found by changing the connection string to use the MySQL root user, which gave more verbose error messages.
Reply all
Reply to author
Forward
0 new messages