how to create new user for mysql database and connected through workbench

https://stackoverflow.com/questions/39281594/error-1698-28000-access-denied-for-user-rootlocalhost

sudo mysql -u root # I had to use "sudo" since is new installation

mysql> USE mysql;
mysql> CREATE USER 'YOUR_SYSTEM_USER'@'localhost' IDENTIFIED BY 'YOUR_PASSWD';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'YOUR_SYSTEM_USER'@'localhost';
mysql> UPDATE user SET plugin='auth_socket' WHERE User='YOUR_SYSTEM_USER';
mysql> FLUSH PRIVILEGES;
mysql> exit;

$ sudo service mysql restart

the change I made is to replace auth_socket with

mysql_native_password

this will allow to type password. I found through the auth_socket, no password is needed in terminal, but i cannot use it to connect through workbench.