Forums

Connecting to MySQL using MySQL Workbench DBLoginError:Access denied for user greentool@10.0.0.98 using password 'YES'

Hello all,

I'm trying to connect to a DB on Python anywhere. Completed all the steps from https://help.pythonanywhere.com/pages/AccessingMySQLFromOutsidePythonAnywhere/

After I click connect it shows me next error:

DBLoginError:Access denied for user username@10.0.0.98 using password 'YES'

Checked all the password twice. Using correct default scheme- 'username$dbname. Have a suspicion that it might be a problem with DB user permissions, but don't what to change things I don't know. Any help will be highly appreciated,

Thank you!

greentool | 12 posts | Feb. 28, 2018, 5:50 a.m. | permalink

UPDATE: All good, suddenly fixed. By setting up 'System Profile' in MySQL Workbench. Previously it was FreeBSD enter image description here

greentool | 12 posts | Feb. 28, 2018, 6:05 a.m. | permalink

How odd -- I wouldn't have expected that to have an effect like that. Glad you worked it out, anyway, and thanks for sharing the solution!

Staff giles | 12095 posts | PythonAnywhere staff | March 1, 2018, 2:02 p.m. | permalink