Question

MySQL Workbench Connection

Posted October 15, 2014 5.6k views

I have already come very far from bluehost to digitalocean configuration, but im struggling with mysql workbench login from my pc.
In bluehost i could just whitelist my current home IP and then login with mysql workbench, when i set .cnf to: 0.0.0.0 . and try to connect in mysql workbench over standard (tcp/ip) im presented with password promt (in sudo password works) which i enter and then get error: Access denied for user ‘root’@'59-44.77-71.cust.xxxx.com’(using password:YES).
any idea what im doing wrong?

Add a comment
axxis6
By:
axxis6
Add a comment
2 comments

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
2 answers
axxis6 October 15, 2014

seems to work now, i had to use something like that too:
GRANT ALL PRIVILEGES ON . TO ‘jan’@'83.76.14.59’

guess need to read into user management of mysql more.
an handy manual would be helpful for that, there are some but not as easy as for others subjects.

Reply Report
  • steelpulsefan November 13, 2020

    Hi, I have the same issue. Are you on a droplet or Managed Database services?

    Im on a managed database with Digital ocean and not sure how to do the command you said worked for you. Where did you enter this command? On local MYSQL? Im new to this thanks.

    Reply Report
TVH7 October 15, 2014

Have you checked your bind setting in the my.cnf, it should be binded to the outbound IP address of your droplet.

Reply Report
Submit an Answer

Looking for something else?

Ask a new question Search for more help