Most of the time we get this issue when we copy a MySQL database from one source to another.
The simple solution to this problem is to run below command on the MySQL server.
GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'yourPassword' WITH GRANT OPTION;
Below points will help you in understanding the above command.
*.*denotes all the tables of all the databases. Here
*is a wild card for database and table names.
'root'@'%'means the root user of any host. Here
%is a wild card for the hostname.
GRANT ALL PRIVILEGES ON db_name.table_name TO 'user_name'@'host_name' IDENTIFIED BY 'password' WITH GRANT OPTION;
For more information, refer this link - MySQL Reference Manual - GRANT Statement.