Hi, I am having the same error (Failure to connect).
I checked the connection to mysql using python command line 1 2 >>> import mysql.connector >>> mysql.connector.connect(host='localhost',database='mysql',user='root', password='') and it is success. What could be the reason of that error? Thanks. On Wednesday, February 13, 2019 at 10:55:32 PM UTC+3, Andrea Fae' wrote: > > > <type 'exceptions.RuntimeError'> Failure to connect, tried 5 times: > Traceback (most recent call last): File > "C:\web2py\gluon\packages\dal\pydal\base.py", line 454, in __init__ > self._adapter = adapter(**kwargs) File > "C:\web2py\gluon\packages\dal\pydal\adapters\__init__.py", line 40, in > __call__ obj = super(AdapterMeta, cls).__call__(*args, **kwargs) File > "C:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 368, in > __init__ super(SQLAdapter, self).__init__(*args, **kwargs) File > "C:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 52, in __init__ > self.reconnect() File "C:\web2py\gluon\packages\dal\pydal\connection.py", > line 172, in reconnect self.connection = self.connector() File > "C:\web2py\gluon\packages\dal\pydal\adapters\mysql.py", line 52, in > connector return self.driver.connect(**self.driver_args) File > "C:\web2py\gluon\contrib\pymysql\__init__.py", line 90, in Connect return > Connection(*args, **kwargs) File > "C:\web2py\gluon\contrib\pymysql\connections.py", line 688, in __init__ > self.connect() File "C:\web2py\gluon\contrib\pymysql\connections.py", line > 905, in connect self._get_server_information() File > "C:\web2py\gluon\contrib\pymysql\connections.py", line 1231, in > _get_server_information self.server_charset = charset_by_id(lang).name File > "C:\web2py\gluon\contrib\pymysql\charset.py", line 38, in by_id return > self._by_id[id] KeyError: 255 > >> >> >> -- 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.
