MySQL on connect windows错误扩展属性不一致

Question

我正试图在我的windows机器上运行hot gym prediction example。我按照https://discourse.numenta.org/t/running-nupic-on-windows/2166中的说明在C:\Python27\Lib\site-packages\nupic\support\nupic-site.xml中设置数据库密码

我检查了MySQL是否在默认端口3306上运行

运行python swarm.py时出现以下错误：

Traceback (most recent call last):
  File "swarm.py", line 111, in <module>
    swarm(INPUT_FILE)
  File "swarm.py", line 103, in swarm
    modelParams = swarmForBestModelParams(SWARM_DESCRIPTION, name)
  File "swarm.py", line 80, in swarmForBestModelParams
    verbosity=0
  File "C:\Python27\lib\site-packages\nupic\swarming\permutations_runner.py", line 271, in runWithConfig
    return _runAction(runOptions)
  File "C:\Python27\lib\site-packages\nupic\swarming\permutations_runner.py", line 212, in _runAction
    returnValue = _runHyperSearch(runOptions)
  File "C:\Python27\lib\site-packages\nupic\swarming\permutations_runner.py", line 141, in _runHyperSearch
    search = _HyperSearchRunner(runOptions)
  File "C:\Python27\lib\site-packages\nupic\swarming\permutations_runner.py", line 412, in __init__
    self.__cjDAO = _clientJobsDB()
  File "C:\Python27\lib\site-packages\nupic\swarming\permutations_runner.py", line 376, in _clientJobsDB
    return cjdao.ClientJobsDAO.get()
  File "C:\Python27\lib\site-packages\nupic\support\decorators.py", line 56, in exceptionLoggingWrap
    return func(*args, **kwargs)
  File "C:\Python27\lib\site-packages\nupic\database\client_jobs_dao.py", line 548, in get
    cjDAO.connect()
  File "C:\Python27\lib\site-packages\nupic\support\decorators.py", line 56, in exceptionLoggingWrap
    return func(*args, **kwargs)
  File "C:\Python27\lib\site-packages\nupic\support\decorators.py", line 208, in retryWrap
    result = func(*args, **kwargs)
  File "C:\Python27\lib\site-packages\nupic\database\client_jobs_dao.py", line 633, in connect
    with ConnectionFactory.get() as conn:
  File "C:\Python27\lib\site-packages\nupic\database\connection.py", line 167, in get
    return cls._connectionPolicy.acquireConnection()
  File "C:\Python27\lib\site-packages\nupic\database\connection.py", line 553, in acquireConnection
    dbConn = self._pool.connection(shareable=False)
  File "C:\Python27\lib\site-packages\DBUtils\PooledDB.py", line 331, in connection
    con = self.steady_connection()
  File "C:\Python27\lib\site-packages\DBUtils\PooledDB.py", line 279, in steady_connection
    *self._args, **self._kwargs)
  File "C:\Python27\lib\site-packages\DBUtils\SteadyDB.py", line 134, in connect
    failures, ping, closeable, *args, **kwargs)
  File "C:\Python27\lib\site-packages\DBUtils\SteadyDB.py", line 186, in __init__
    self._store(self._create())
  File "C:\Python27\lib\site-packages\DBUtils\SteadyDB.py", line 190, in _create
    con = self._creator(*self._args, **self._kwargs)
  File "C:\Python27\lib\site-packages\pymysql\__init__.py", line 88, in Connect
    return Connection(*args, **kwargs)
  File "C:\Python27\lib\site-packages\pymysql\connections.py", line 626, in __init__
    self._connect()
  File "C:\Python27\lib\site-packages\pymysql\connections.py", line 818, in _connect
    2003, "Can't connect to MySQL server on %r (%s)" % (self.host, e))
pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (255)")

错误代码255是表示The extended attributes are inconsistent的windows错误代码

C:\Program Files\MySQL\MySQL Server 8.0\bin>perror 255 Win32 error

code 255: The extended attributes are inconsistent.

我试过：

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourRootPassword'; FLUSH PRIVILEGES;

发件人：https://github.com/numenta/nupic/issues/3189#issuecomment-429343101 但那没用

将地址从localhost更改为127.0.0.1也没有帮助

关于如何解决这个问题有什么建议吗