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!

Cannot change a MySQL user's privilege.

Discussion in 'General Discussion' started by PondRicefied, Sep 14, 2005.

  1. PondRicefied

    PondRicefied Well-Known Member

    Joined:
    Dec 13, 2004
    Messages:
    52
    Likes Received:
    0
    Trophy Points:
    156
    Since I could not change a user's privilege in MySQL, I was troubled. (from ALL Privilege.)

    In the "Grant permissions on a MySQL database to a MySQL user" section of Cpanel, I chose created DB user as the User field, and chose the created database name as the MySQL Database field.

    Next, I checked only to SELECT, INSERT, and UPDATE in the Privileges field, and clicked the Grant Permissions button.

    However, the Privilege field after sending is still All.

    How can I change Privilege?


    --- Digression ---
    When a privilege table is checked by the root user of MySQL, the backslash is added to the database name.
    That is, two kinds per privilege data of definitions exist.

    localhost | account1_dbname1 | account1_user1 | ....
    localhost | account1\_dbname1 | account1_user1 | ...
    ^
    ...
    -------------------

    Please help.......

    I am thankful to the ones of the warm heart of this forum.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. PondRicefied

    PondRicefied Well-Known Member

    Joined:
    Dec 13, 2004
    Messages:
    52
    Likes Received:
    0
    Trophy Points:
    156
    When change of a privilege is run from a control panel, he can be understanding that a backslash (\) is added to an underscore (_) as follows.
    Code:
    GRANT ... ON 'account1\_dbname1'.* TO 'account1_dbusername1'@'localhost';
    However, being saved where a backslash (\) is added is mysterious.
    Code:
    +-----------+---------+--------+---
    | Host      | Db      | User   | ...
    localhost | account1_dbname1 | account1_user1 | ...   ---1
    localhost | account1\_dbname1 | account1_user1 | ...   ---2
    ...
    Which is a right as data which should be saved? 1 ro 2?


    The cause may have escaped the backslash.
    Temporarily, If this is the cause, where do I have to fix this?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

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