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.

HowTo add MySQL File Privileges

Discussion in 'General Discussion' started by equens, Feb 20, 2004.

  1. equens

    equens Well-Known Member

    Joined:
    Feb 8, 2002
    Messages:
    270
    Likes Received:
    0
    Trophy Points:
    16
    Hello, I need to add a FILE privileges to mysql user, how can I do it? thanks!
     
  2. bamasbest

    bamasbest Well-Known Member

    Joined:
    Jan 10, 2004
    Messages:
    531
    Likes Received:
    0
    Trophy Points:
    16
    Funny, but file perms are no longer (IMO) automatic when Grant All is issued?. Regardless, you should be able to add via PhpMyAdmin or MySql at ssh/commandline. Make sure you assign the appropriate perms to /temp!
     
  3. equens

    equens Well-Known Member

    Joined:
    Feb 8, 2002
    Messages:
    270
    Likes Received:
    0
    Trophy Points:
    16
    I have an user user_name (Privileges: ALL PRIVILEGES) but when I try to import data from a file (chmod 777) it gives me this error:

    Importing data... Access denied for user: 'user_name@localhost' (Using password: YES)

    Can you tel me how can I assign the appropriate perms to add file privileges from ssh? thanks again!
     
Loading...

Share This Page