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!

MySQL User Permissions

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

  1. justhost

    justhost Well-Known Member

    Sep 2, 2003
    Likes Received:
    Trophy Points:
    Halifax, Nova Scotia

    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"

    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. Support Ticket Number:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. mickeymouse

    mickeymouse Well-Known Member

    Sep 16, 2003
    Likes Received:
    Trophy Points:
    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:

    Regards, Support Ticket Number:

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