1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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

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

  1. #1
    Hi there,

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

    I get this error message:
    SEMrush
    #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
    SEMrush
  2. MilesWeb

    MilesWeb Well-Known Member

    Messages:
    856
    Likes Received:
    33
    Best Answers:
    7
    Trophy Points:
    123
    #2
    MilesWeb, Feb 8, 2014 IP
  3. phptechie

    phptechie Well-Known Member

    Messages:
    869
    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