Well I ve been trying to connect to a little test db I got on my local Wamp Server but I can't seem to get it right .
At first I tried to connect via mysql://username:password@127.0.0.1:3306/mydb URI and got it but the table of my db were unseen (only the auth table were there) then I def 'ed them .but i got a ticket RACEBACK 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. Traceback (most recent call last): File "gluon/restricted.py", line 212, in restricted File "C:/Users/PCPC/Downloads/web2py_win/web2py/applications/button/models/db.py" <http://127.0.0.1:8000/admin/default/edit/button/models/db.py>, line 15, in <module> File "gluon/dal.py", line 6774, in __init__ RuntimeError: Failure to connect, tried 5 times: Traceback (most recent call last): File "gluon/dal.py", line 6755, in __init__ File "gluon/dal.py", line 2384, in __init__ File "gluon/dal.py", line 583, in reconnect File "gluon/dal.py", line 2382, in connector File "gluon/contrib/pymysql/__init__.py", line 93, in Connect File "gluon/contrib/pymysql/connections.py", line 575, in __init__ File "gluon/contrib/pymysql/connections.py", line 741, in _connect File "gluon/contrib/pymysql/connections.py", line 796, in _request_authentication File "gluon/contrib/pymysql/connections.py", line 845, in _send_authentication File "gluon/contrib/pymysql/connections.py", line 341, in check_error File "gluon/contrib/pymysql/err.py", line 142, in raise_mysql_exception File "gluon/contrib/pymysql/err.py", line 135, in _check_mysql_exception OperationalError: (1044, u"Access denied for user ''@'localhost' to database 'pythontest'") .i modified my db by putting "id" fields as primary keys with auto increment option but still nothing then I searched some more and got the extract_mysql_models.py solution ,but the output "db1" file while I was trying to edit it with idle and web2py gave me a " USAGE: extract_mysql_models.py username:password@data_basename " Sorry for the bother. I'm a total newbie and help would be very much appreciated . Jesse --
