search

polkascan / explorer

Polkascan Substrate Explorer
GNU General Public License v3.0
42 stars 44 forks source link

Error: 2003, "Can't connect to MySQL server on 'localhost' ([WinError 10061] No connection could be made because the target machine actively refused it)" #23

Closed SWS-5007 closed 1 year ago

SWS-5007 commented 1 year ago

Hi, When I run python app/harvester.py --force-start command after I migrate db of Harvester, I am getting this error.

File "C:\Users\Home\AppData\Local\Programs\Python\Python310\lib\site-packages\sqlalchemy\engine\default.py", line 598, in connect return self.dbapi.connect(*cargs, **cparams) File "C:\Users\Home\AppData\Local\Programs\Python\Python310\lib\site-packages\pymysql\connections.py", line 353, in init self.connect() File "C:\Users\Home\AppData\Local\Programs\Python\Python310\lib\site-packages\pymysql\connections.py", line 664, in connect raise exc sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'localhost' ([WinError 10061] No connection could be made because the target machine actively refused it)") (Background on this error at: https://sqlalche.me/e/14/e3q8)

How can I fix this problem?

SWS-5007 commented 1 year ago

I solved this problem by running the Xampp first and run that command again. After running the Xampp Server for Sql, It works well. Thanks.