Cannot change a MySQL user's privilege.

[PondRicefied]

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.

 

[PondRicefied]

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.

GRANT ... ON 'account1\_dbname1'.* TO 'account1_dbusername1'@'localhost';

However, being saved where a backslash (\) is added is mysterious.

+-----------+---------+--------+---
| 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?