The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

phpMyAdmin Problem

Discussion in 'Database Discussions' started by phantasmp, Sep 1, 2004.

  1. phantasmp

    phantasmp Member

    Joined:
    Feb 19, 2003
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Canada
    One of my customers needed to use LOAD DATA INFILE so i logged onto mysql using ssh and typed

    GRANT FILE ON *.* TO username_name@localhost; flush PRIVILEGES;

    Then the user was unable to login to phpMyAdmin, it says "Wrong username/password. Access denied" even though I didn't do anything to the username that's used when logging into phpMyAdmin, I did it to a username they created

    So i ran

    REVOKE FILE ON *.* FROM username_name@localhost; flush PRIVILEGES;

    To see if that would fix it, but it didn't. I checked if the password in the mysql table for that user matched the results from SELECT PASSWORD('theirpassword') and it did.

    Does anyone know how to fix this?
     
  2. phantasmp

    phantasmp Member

    Joined:
    Feb 19, 2003
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Canada
    I restarted mysql and everything works now
     
Loading...

Share This Page