Results 1 to 5 of 5
  1. #1
    Full Member que007's Avatar
    Join Date
    January 18th, 2005
    Posts
    339
    Im trying to load my database like i always do but i am getting this error using another host.


    SQL-query :

    LOAD DATA INFILE '/tmp/phpHJmbhA' INTO TABLE `testingfeed` FIELDS TERMINATED BY '|' LINES TERMINATED BY '\r\n'

    MySQL said:


    #1045 - Access denied for user: 'testdatabase@localhost' (Using password: YES)

    Can anyone explain this error? Also when I open phpmyadmin I see this which I havent seen with my usual host:

    MySQL
    Create new database: [Documentation]
    No Privileges


    Can this have something to do with it?

  2. #2
    ABW Ambassador swampy_webber's Avatar
    Join Date
    January 18th, 2005
    Location
    West Virginia
    Posts
    698
    sil,

    Sounds like the user isn't in the MYSQL.USERS table for 'localhost' Do you manage your own MySQL installation?
    Life is like a dogsled team. If you ain't the lead dog, the scenery never changes.

    -- Lewis Grizzard

  3. #3
    ABW Ambassador FFoc's Avatar
    Join Date
    January 18th, 2005
    Posts
    1,015
    It means just that -- access is denied for that user.

    Check to see if you have GLOBAL FILE granted to that user, and if not, you need to grant it. Don't forget to flush the grants table when you're done altering user permissions.
    “An adventure is an inconvenience rightly considered. An inconvenience is an adventure wrongly considered.” - G.K. Chesterton

  4. #4
    Newbie
    Join Date
    January 18th, 2005
    Location
    Houston and Singapore
    Posts
    9
    Heya Sil -
    try LOAD DATA LOCAL INFILE ...
    and see if that fixes your problem ...
    warmest regards [Bill]

  5. #5
    Full Member
    Join Date
    January 18th, 2005
    Posts
    88
    PHPMyAdmin has released a patch for this.
    Ask your host to install it.

  6. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. phpMyAdmin Help
    By aireen9 in forum Domains & Hosting
    Replies: 1
    Last Post: December 12th, 2008, 08:05 AM
  2. Did anybody here create datafeed from phpmyadmin?
    By sinpeople in forum Programming / Datafeeds / Tools
    Replies: 1
    Last Post: June 17th, 2007, 07:40 PM
  3. Looking for phpMyAdmin Help
    By Doug247 in forum Midnight Cafe'
    Replies: 3
    Last Post: December 1st, 2003, 09:28 PM
  4. phpmyadmin installation help
    By Chet_B in forum Programming / Datafeeds / Tools
    Replies: 4
    Last Post: October 17th, 2003, 01:23 PM
  5. phpmyadmin help needed!
    By wendy in forum Programming / Datafeeds / Tools
    Replies: 4
    Last Post: September 8th, 2002, 09:31 PM

Posting Permissions

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