Erro message when importing CSV file: #1044 - Access denied for user 'cpses_mbYVs3FKwW'@'localhost'

Discussion in 'Databases' started by MattBOnline, Feb 8, 2014.

0
  1. #1
    Hi there,

    I cannot import any Excel Spreadsheet CSV files in to PHPMyAdmin.

    I get this error message:

    #1044 - Access denied for user 'cpses_mbYVs3FKwW'@'localhost' to database 'CSV_DB'

    Does anyone know how to fix this problem?

    Thanks,
    Matt.
     
    MattBOnline, Feb 8, 2014 IP
  2. MilesWeb

    MilesWeb Well-Known Member

    Messages:
    869
    Likes Received:
    35
    Best Answers:
    7
    Trophy Points:
    173
    #2
    MilesWeb, Feb 8, 2014 IP
  3. phptechie

    phptechie Well-Known Member

    Messages:
    885
    Likes Received:
    10
    Best Answers:
    2
    Trophy Points:
    165
    #3
    Matt,

    The error seems related to user access.
    If you try to export via phpmyadmin , make sure the user login that you logged into phpmyadmin has access rights to that table 'CSV_DB'
    If not try to assign user rights to this user for this table , but for that you need root access to the mysql database.
    Once you assigned user rights to that logged in user . then you must be able to import without this error.
     
    phptechie, Mar 3, 2014 IP