mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported

[mengguiyouziyi]

• pyspider version: latest
• Operating system:centos 7
• Start up command:
  sudo docker run --network=pyspider --name scheduler -d -p 23333:23333 --restart=always binux/pyspider --taskdb "mysql+taskdb://root:[email protected]:3306/taskdb" --resultdb "mysql+projectdb://root:[email protected]:3306/resultdb" --projectdb "mysql+projectdb://root:[email protected]:3306/projectdb" --message-queue "redis://172.0.0.2:6379/0" scheduler --inqueue-limit 10000 --delete-time 3600

Expected behavior

scheduler could running

Actual behavior

Traceback (most recent call last): File "/usr/local/bin/pyspider", line 11, in load_entry_point('pyspider', 'console_scripts', 'pyspider')() File "/opt/pyspider/pyspider/run.py", line 754, in main cli() File "/usr/local/lib/python2.7/site-packages/click/core.py", line 722, in call return self.main(*args, **kwargs) File "/usr/local/lib/python2.7/site-packages/click/core.py", line 697, in main rv = self.invoke(ctx) File "/usr/local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/usr/local/lib/python2.7/site-packages/click/core.py", line 895, in invoke return ctx.invoke(self.callback, **ctx.params) File "/usr/local/lib/python2.7/site-packages/click/core.py", line 535, in invoke return callback(*args, **kwargs) File "/usr/local/lib/python2.7/site-packages/click/decorators.py", line 17, in new_func return f(get_current_context(), *args, **kwargs) File "/opt/pyspider/pyspider/run.py", line 194, in scheduler kwargs = dict(taskdb=g.taskdb, projectdb=g.projectdb, resultdb=g.resultdb, File "/opt/pyspider/pyspider/libs/utils.py", line 355, in getattr return ret.get(self, ObjectDict) File "/opt/pyspider/pyspider/libs/utils.py", line 342, in get return self.getter() File "/opt/pyspider/pyspider/run.py", line 43, in return utils.Get(lambda: connect_database(value)) File "/opt/pyspider/pyspider/database/init.py", line 44, in connect_database db = _connect_database(url) File "/opt/pyspider/pyspider/database/init.py", line 64, in _connect_database return _connect_mysql(parsed,dbtype) File "/opt/pyspider/pyspider/database/init.py", line 111, in _connect_mysql return TaskDB(**parames) File "/opt/pyspider/pyspider/database/mysql/taskdb.py", line 28, in init host=host, port=port, autocommit=True) File "/usr/local/lib/python2.7/site-packages/mysql/connector/init.py", line 179, in connect return MySQLConnection(*args, **kwargs) File "/usr/local/lib/python2.7/site-packages/mysql/connector/connection.py", line 95, in init self.connect(**kwargs) File "/usr/local/lib/python2.7/site-packages/mysql/connector/abstracts.py", line 715, in connect self._open_connection() File "/usr/local/lib/python2.7/site-packages/mysql/connector/connection.py", line 210, in _open_connection self._ssl) File "/usr/local/lib/python2.7/site-packages/mysql/connector/connection.py", line 142, in _do_auth auth_plugin=self._auth_plugin) File "/usr/local/lib/python2.7/site-packages/mysql/connector/protocol.py", line 102, in make_auth auth_data, ssl_enabled) File "/usr/local/lib/python2.7/site-packages/mysql/connector/protocol.py", line 58, in _auth_response auth = get_auth_plugin(auth_plugin)( File "/usr/local/lib/python2.7/site-packages/mysql/connector/authentication.py", line 191, in get_auth_plugin "Authentication plugin '{0}' is not supported".format(plugin_name)) mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported

[emiharbur]

this problem happen because mysql8.0 ,

you can ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '{NewPassword}';

[ghost]

This is giving me a syntax error

[nadiabfata]

me too: ProgrammingError: 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[dalpat98]

i'm too getting error while connecting i have installed the python connector ERROR: Authentication plugin 'caching_sha2_password' is not supported pls help

[makungaj1]

cnx = mysql.connector.connect(user='', password="", # required port=port_number, host="localhost", # required database='database_name', auth_plugin='mysql_native_password' # required )

MySQL Command Line Client ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_password' PASSWORD EXPIRE NEVER; ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password';

you_password is the password you use to sign in your mysql

[xorfn]

which way do you start pyspider? mysql needs a path to the created pyspider database - this is projectdb and beyond. The database is created in the data folder. Look for it at the pyspider launch location if the launch does not follow absolute paths from the pyspider deployment location. If you want to specify the path to the pyspider database take a look at this documentation http://docs.pyspider.org/en/latest/Deployment/

[Vashi1]

uninstall mysql-connector by running pip uninstall mysql-connector and run pip install mysql-connector-python

[RowdyKGZ]

uninstall mysql-connector by running pip uninstall mysql-connector and run pip install mysql-connector-python

helped install name pip install mysql-connector-python like for @Vashi1