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.

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:
    6
    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.
     
  2. PondRicefied

    PondRicefied Well-Known Member

    Joined:
    Dec 13, 2004
    Messages:
    52
    Likes Received:
    0
    Trophy Points:
    6
    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?
     
Loading...

Share This Page