• GoDaddy Community
  • VPS & Dedicated Servers
  • VPS & Dedicated Servers

    cancel
    Showing results for 
    Show  only  | Search instead for 
    Did you mean: 
    Go to solution
    ulandreman
    Getting Started

    Changing permissions for mySQL database users

    I've seen similar questions being asked, but I haven't seen a solution yet.

    I have a mySQL database on my VPS.

    I'm trying to find a way to change permissions for various users who have access to that database.

    In particular, I have one user whom I would like to be able to run mysqldump to create a backup of the database.  I get the message in SSH that the user needs the PROCESS privilege to save the dump to a file.

    The privileges tab is missing in phpmyadmin and I can't modify privileges within SSH.

    Has anyone found a work-around?

    1 ACCEPTED SOLUTION
    PL281
    Super User II

    @ulandreman 

    If you aren't using cPanel - I would think you could just run a GRANT sql comment to add the privileges to that user

    I am a GoDaddy End User - Just Like You
    Check out my site! | I currently manage over 300 WordPress Websites
    * Please note that I offer free advice on this forum. Thank You Info If you would like personalized help, please contact me. Otherwise, please ask your question in the proper forum so the answer can assist EVERYONE in the community and not just you. Thanks! *

    Once your issue is resolved,
    please be sure to come back and click accept for the solution

    Get Better Support on the Community Boards!
    Etiquette When Asking for Help from the Community

    View solution in original post

    2 REPLIES 2
    PL281
    Super User II

    @ulandreman 

    If you aren't using cPanel - I would think you could just run a GRANT sql comment to add the privileges to that user

    I am a GoDaddy End User - Just Like You
    Check out my site! | I currently manage over 300 WordPress Websites
    * Please note that I offer free advice on this forum. Thank You Info If you would like personalized help, please contact me. Otherwise, please ask your question in the proper forum so the answer can assist EVERYONE in the community and not just you. Thanks! *

    Once your issue is resolved,
    please be sure to come back and click accept for the solution

    Get Better Support on the Community Boards!
    Etiquette When Asking for Help from the Community

    View solution in original post

    I'll give that a try.  I've never used the GRANT command before in SQL.