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.

MySQL User Permissions

Discussion in 'General Discussion' started by justhost, Oct 4, 2003.

  1. justhost

    justhost Well-Known Member

    Joined:
    Sep 2, 2003
    Messages:
    108
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Halifax, Nova Scotia
    Hello

    I might be in the wrong forum so mods move this if you must.

    I run a Redhat 9.0 server running mySQL 4.0.15-standard. This is a CPanel/WHM Box.

    I have a client that needs to be able to assign users to his database and GRANT them access to specific features for a table or tables or all tables in the database.

    Here is what I have tried and what my results were.

    I have logged into mysql as root (mysql -uroot -p) and executed the following command:

    GRANT ALL TO user_main.*
    ->TO user_admin@localhost
    ->IDENTIFIED BY "password"
    ->WITH GRANT OPTION;


    Then I exit mysql and log in as user_admin.

    mysql -u user_admin -p

    I then try to execute the following:

    GRANT SELECT TO user_main.*
    ->TO user_guess@localhost
    ->IDENTIFIED BY "password";

    This gives the following message:
    ERROR 1044: Access denied for user: 'user_admin@localhost' to database 'user_main'

    Could someone please let me know what is wrong?

    Thank you.

    cPanel.net Support Ticket Number:
     
  2. mickeymouse

    mickeymouse Well-Known Member

    Joined:
    Sep 16, 2003
    Messages:
    389
    Likes Received:
    0
    Trophy Points:
    16
    Dear justhost,

    Please check the format that you are given. You have to use ALL PRIVILEGES option to give the permissions. Please try with that option.

    Please refer the link at the given url for more information regarding this:
    http://www.ninthwonder.com/info/mysql/manual-split/manual_Reference.html#GRANT

    Regards,

    cPanel.net Support Ticket Number:
     
Loading...

Share This Page