1045 (28000): Access denied for user '[email protected]'@'localhost' (using password: YES) code example

Example 1: ERROR 1045 (28000): Access denied for user 'labanino'@'localhost' (using password: NO)

mysql -u root -p

Example 2: windows error 1045 (28000): access denied for user 'root'@'localhost' (using password: yes)

update user set authentication_string=password('my_password') where user='root';

Example 3: Error 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

sudo mysql -u root -p