MySQL 1045-access denied for user ' root ' @ ' *.*.*.* ' (using password YES)

Remote cannot connect to MySQL

Workaround:

1. Login data on the server

mysql-uroot-hlocalhost-p3306- PEnter password:welcome to the MySQL Monitor. Commands End With; or \g.your MySQL connectionIDIs AServer Version:5.6. theMySQL Community Server (GPL) Copyright (c) -,2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or Itsaffiliates. Other names trademarks of their respectiveowners. Type'Help ;'Or'\h'  forHelp. Type'\c'ToClearThe current input statement.

2. Select MySQL Database

mysql> use mysql
Reading table information for completion of table and column names
Can turn off this feature to get a quicker startup with-a

3. Update Root password

UPDATE user SET Password=password ('newpassword') where user= ' root '; 4 rows affected (0.015  4  0

4. Refresh Permissions

Mysql> FLUSH privileges; 0 rows affected (0.00 sec)

MySQL 1045-access denied for user ' root ' @ ' *.*.*.* ' (using password YES)