add user to database not showing in cPanel Web

[kenji0e]

DH..

please help me...

i use command to give privileges my database in shell like this;


GRANT ALL PRIVILEGES ON db1.* TO 'user1'@'localhost' WITH GRANT OPTION;


then.. i look cPanel --> MySQL Database... i can't see user1 in db1..
but when i try add user to database from web cpanel MySQL Database ..in button privileges have check..
user1 ready
privilleges ready..

Just not show in table cPanel user...

please help me.. thanks

[cPanelTristan]

For a user to be able to be added in cPanel > MySQL Databases area to a database, that user must be mapped to the account. You'd need to use WHM > SQL Services > Database Map Tool area to properly map the database user to the account in question.

[mcongosto]

There is a bug here!

When you map an existing databse it does not comes with the domain_ prefix . And when you create a user and then try to assig priviliges to the databse you get an error beacuse the syste m asumes that the databse has the prefix!!

please fix this, is really bad!


Manage User Privileges

User: cooprona_coopro
Database: coopro2009

then:
There was a problem adding the user. Show Details

Error from cpmysql wrapper: You do not have access to that database (cooprona_coopro2009)!

[cPanelTristan]

If you believe this is a bug on your system, please submit a bug report:

http://go.cpanel.net/bugs

Or, using the link at the top of the forum. All bug reports are handled internally via our bug reporting interface.