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?
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.