mysql workbench failed to connect with user root access denied ubuntu
The solution that worked for me was that I had to create a new user apart from the root user (in mysql) And then created a new db connection with admin as the user & then it worked To create a new user named admin with password as 'password' commands- sudo mysql -u root -p CREATE USER 'admin'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION; if everything works- ENJOY! At some point if you get an error like 'Your password does not satisfy the current policy requirements' do this- (affter starting mysql) commands- SHOW VARIABLES LIKE 'validate_password%'; The output should be something like that : +--------------------------------------+-------+ | Variable_name | Value | +--------------------------------------+-------+ | validate_password.check_user_name | ON | | validate_password.dictionary_file | | | validate_password.length | 6 | | validate_password.mixed_case_count | 1 | | validate_password.number_count | 1 | | validate_password.policy | LOW | | validate_password.special_char_count | 1 | +--------------------------------------+-------+ if not same do this- SET GLOBAL validate_password.length = 6; SET GLOBAL validate_password.number_count = 0; similarly you can set other fields with the same format just change the variable name that is to be set. DONE! THANKS :) References- https://askubuntu.com/questions/773446/unable-to-connect-via-mysql-workbench-to-localhost-in-ubuntu-16-04-passwordless https://stackoverflow.com/questions/43094726/your-password-does-not-satisfy-the-current-policy-requirements