I tried all the solutions mentioned in all other similar question in stackoverflow and various other sites like Youtube.
link from where I looked for solution: Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user 'root'@'localhost'(using password:YES)
For connection I made new user 'admin' and granted him all privileges
updated my plugin to mysql_native_password for user 'admin' and 'root'
but still during test connection in workbench the problem still exist and i am not able to connect to the database server enter image description here: This image is of MySQL server where you can see I made an user 'admin' and granted him all privileges
enter image description here: Here you can clearly see even after all that, workbench is not able to make connection.
