0

I need your help on the below connection & want to know how to handle special character (@) in password(XSW@3edcvf). Any help is greatly appreciated.

engine=sl.create_engine('mysql+mysqldb://root:XSW@3edcvf@xx.xx.xx.xx:3306/test')

thanks

Trace Call
 Traceback (most recent call last):
      File "<ipython-input-156-c59046254236>", line 13, in <module>
engine=sl.create_engine('mysql+mysqldb://root:XSW@3edcvf@xx.xx.xx.xx:3306/test')
  File "E:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\engine\__init__.py", line 424, in create_engine
    return strategy.create(*args, **kwargs)

  File "E:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\engine\strategies.py", line 57, in create
    entrypoint = u._get_entrypoint()

  File "E:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\engine\url.py", line 156, in _get_entrypoint
    cls = registry.load(name)

  File "E:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\util\langhelpers.py", line 204, in load
    loader = self.auto_fn(name)

  File "E:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\dialects\__init__.py", line 43, in _auto_fn
    module = __import__('sqlalchemy.dialects.%s' % (dialect, )).dialects

  File "E:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\dialects\mysql\__init__.py", line 8, in <module>
    from . import base, mysqldb, oursql, \

  File "E:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\dialects\mysql\base.py", line 708, in <module>
    from . import reflection as _reflection

  File "E:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\dialects\mysql\reflection.py", line 11, in <module>
    from .enumerated import _EnumeratedValues, SET

  File "E:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\dialects\mysql\enumerated.py", line 10, in <module>
    from .types import _StringType

  File "E:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\dialects\mysql\types.py", line 31, in <module>
    class _FloatType(_NumericType, sqltypes.Float):

  File "E:\ProgramData\Anaconda3\lib\site-packages\sqlalchemy\sql\visitors.py", line 60, in __init__
    super(VisitableType, cls).__init__(clsname, bases, clsdict)

TypeError: super(type, obj): obj must be an instance or subtype of type
Barthelemy Pavy
  • 452
  • 3
  • 6
user5889117
  • 89
  • 8
  • Maybe this could help you for [special characters](https://stackoverflow.com/questions/1423804/writing-a-connection-string-when-password-contains-special-characters?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa) – Barthelemy Pavy Jun 12 '18 at 08:41
  • it gave me error when i used % urlquote. Error = NameError: name 'urlquote' is not defined – user5889117 Jun 12 '18 at 20:15
  • Its working for me now, i forgot to add "from urllib.parse import quote_plus as urlquote". Thanks for your help. – user5889117 Jun 12 '18 at 20:39

0 Answers0