SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Evangelist
    Join Date
    Mar 2011
    Posts
    423
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Error message when importing CSV file into PHPMyAdmin

    Hi,

    I am trying to import a .csv file into PHPMyAdmin but I get this error message:

    Error
    SQL query:

    CREATE DATABASE IF NOT EXISTS `CSV_DB` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

    MySQL said:

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



    I have no idea what it means. Can someone help me, please?


    Thanks,

    Matt.

  2. #2
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    5,016
    Mentioned
    103 Post(s)
    Tagged
    0 Thread(s)
    The MySQL user that PHPMyAdmin uses to access the MySQL server doesn't have permission to access the database called "CSV_DB" for creating tables. What permissions does the MySQL user "cpses_mb5CYRNCvf" have?
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator

  3. #3
    SitePoint Evangelist
    Join Date
    Mar 2011
    Posts
    423
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I do not have a database called "CSV_DB" and I do not know what "cpses_mb5CYRNCvf" is. When I try again the user name changes (see below):

    Error
    SQL query:

    CREATE DATABASE IF NOT EXISTS `CSV_DB` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

    MySQL said:

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


    Any ideas?

    Matt.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •