How to fix PHPMyAdmin import error: #1044 - Access denied for user '***'@'localhost ?

It is possible that the mysql file you are trying to upload/import contains an instruction that new user/database should be created and this is not allowed.

You can either create that user and database or edit the file you are importing.

I choose to edit the file and on the top of it i found:

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `zadmin_olddbname` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `zadmin_oddbname`;
and i remove these lines and then (IMPORTANT): save the file under different name so you do not overwrite original, because your editor may damage some characters in the file and so we should have way to return to original backup.

Then i successfully imported the modified file. (it worked to also pack it into .zip)