Mysql Access denied with right username and password in pyspider

Skip to first unread message

Alex W

Dec 16, 2018, 8:24:21 AM12/16/18
to pyspider-users

屏幕快照 2018-12-17 02.17.51.png

屏幕快照 2018-12-17 02.18.40.png


I have set all of them in my code, but it still showed a wrong msg when i start pyspider with 'pyspider -c config.json'.

Even though I can handle mysql with the username and password by terminal and client, pyspider still can not work!

Roy Binux

Dec 16, 2018, 1:12:54 PM12/16/18
to Alex W, pyspider-users
Why error message said nzhg@localhost instead of The permission to login for localhost and are different in MySQL.

You received this message because you are subscribed to the Google Groups "pyspider-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
To post to this group, send email to
To view this discussion on the web visit
For more options, visit

Reid Du

Apr 21, 2019, 10:31:58 PM4/21/19
to pyspider-users
this problem comes from mysql 5.7 ,you can have two  solutions:
1) use  mysql <= 5.6
2) add data user  from and localhost,both is needed .

在 2018年12月16日星期日 UTC+8下午9:24:21,Alex W写道:
Reply all
Reply to author
0 new messages