Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

How to grant FILE, RELOAD and LOCK TABLES in Mysql??

Discussion in 'General Discussion' started by cyberwisdom, Jul 19, 2003.

  1. cyberwisdom

    cyberwisdom Well-Known Member

    Jun 2, 2003
    Likes Received:
    Trophy Points:
    I have a user that says he doesn't have the FILE, RELOAD and LOCK TABLES permissions for his MySQL database users. He says he needs it.

    1. Is it safe to grant the user these permissions?
    2. If it's safe then how do I grant them in phpMyAdmin or SSH?

    I'm not that familiar with MySQL so I don't want to do anything until someone helps me out. Support Ticket Number:
  2. www-lab

    www-lab Well-Known Member

    Feb 1, 2003
    Likes Received:
    Trophy Points:
    You can give this user FILE and LOCK TABLES permission.

    Cpanel is not doing this, so you have to do it manually.

    Log into phpmyadmin as root and give that user permissions.

    P.S. RELOAD allows usage of flush, so I dont know why your user wants that feature.

    Good luck Support Ticket Number:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice