+ Post New Thread
Results 1 to 2 of 2

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

  1. #1
    Fli
    Fli is online now
    Administrator Fli's Avatar
    Join Date
    Mar 2013
    Posts
    2,471

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



    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)

  2. #2
    Junior Member BossMain's Avatar
    Join Date
    Nov 2019
    Posts
    4


    Is this useful / helpfull? Yes | No
    I appreciate your help

+ Post New Thread

Similar Threads

  1. Replies: 0
    Last Post: 04-21-2018, 08:53 AM
  2. How to fix named error: permission denied
    By Fli in forum Linux Forums
    Replies: 0
    Last Post: 04-16-2017, 01:20 PM
  3. Replies: 0
    Last Post: 11-03-2015, 09:59 AM
  4. Replies: 1
    Last Post: 01-11-2015, 07:55 AM
  5. Replies: 0
    Last Post: 04-21-2014, 01:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
 Protected by : ZB BLOCK  &  StopForumSpam