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

[Fli]

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)

[kumkum]

Mostly this error occur when user don't have write and edit permission, if you are server admin then you can use below command to solve this error.
grant create on *.* to phpmyadmin@localhost;

You are giving permission to particular user to resolve this error.

If you want complete information then you can check solution of Access denied (https://hoststud.com/resources/access-denied-for-user-1044-1045-mariadb-mysql-db-error.831/) for user error.

[Alex_Re]

I would like to create (https://www.frog-kingdom.com/collections/frog-plush) an e-commerce store in which I would sell only frog plush at a very affordable price. I would like to know if it is a good idea to use php as a backend programming language.