Troubleshoot MySQL client connectivity issues

problem: Installing the MySQL server on Linux, using the Client connection times error message is: Error 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using password: YES)     Workaround 1:        1. Login mysql: mysql -uroot -proot         2. Authorized:grant all privileges on *.* to  ' MyUser ' @ '% '  IDENTIFIED BY  ' mypassword '  WITH GRANT OPTION;         3. Refresh permissions: Flush privileges;        4. Exit:exit          Workaround 2:         1.  login mysql: mysql -uroot -proot        2.   Select MySQL Database:use mysql;        3.  Modify access rights:update  user set host =  '% '  where user =  ' root ';         4.  Refresh Permissions:flush privileges;        5.  Exit: Exit

Troubleshoot MySQL client connectivity issues