Ok, is the python AND the mysql on the same windows BOX ? If not, could be a firewall issue.
For the record, my python stand alone are truly stand alone (But I run LINUX , no Windowns here). So all my script are not thru the web2py but use the pydal library ... *Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Thu, Feb 14, 2019 at 7:48 AM andfae <and...@gmail.com> wrote: > How to test via command prompt the connection between python and mysql? > > Il giorno gio 14 feb 2019 alle ore 14:47 andfae <and...@gmail.com> ha > scritto: > >> Yes I tried this usi too uri = mysql://root:passwordroot@localhost/gadb >> I don't know what is the problem... >> Thank you >> >> Il giorno gio 14 feb 2019 alle ore 00:48 黄祥 <steve.van.chris...@gmail.com> >> ha scritto: >> >>> RuntimeError: Failure to connect, tried 5 times: >>> >>> seems have a connection problem between python and mysql >>> perhaps you can test the connection first (via command prompt) >>> >>> or perhaps an uri definition is wrong, had you try: >>> *private/appconfig.ini* >>> uri = mysql://root:passwordroot@localhost/gadb >>> ? >>> >>> best regards, >>> stifan >>> >>> -- >>> Resources: >>> - http://web2py.com >>> - http://web2py.com/book (Documentation) >>> - http://github.com/web2py/web2py (Source code) >>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>> --- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "web2py-users" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/web2py/w0aSCaf7W5o/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> web2py+unsubscr...@googlegroups.com. >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
