cPanel Question posted in
The official documentation can be seen here.

#1044 – Access denied for user 'A WEIRD USER'@'localhost' to database 'MY DATABASE' – CPanel

I have problem loading some data from a CSV file to my table in the database
and got an error said :

#1044 - Access denied for user 'A WEIRD USER'@'localhost' to database 'MY DATABASE'

As I know phpmyadmin logged in (Automatically when clicked on phpmyadmin icon in CPanel) as a user who doesn’t have permission to run some queries
and there is no button to log out from phpmyadmin and log in as my user

NOTE: this error is not only for load data from CSV file, but this error also comes on run some queries too!
NOTE 2: I don’t use localhost

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    I know its late but I export my database and tables as SQL format "NOT CSV" and it imported without a problem :)


  2. 0

    You can go around this importing the source tables, then copying the records into the target table.

    Share more Info so I can help you

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search