Making users for My SQL database

[Hagforce]

Hello

Is there any way for domain admins in ISPConfig to make My SQL users with different rights to the databases they administrate.

In example the administrator of web_15 wants to add a user to his SQL database web15_db2 that has limited rights, for use on his web page.

Is it possible to do this?

[till]

In ISPConfig, every database has only one user. If you want to get more users for a database, you will have to craete them in the mysql user table, e.g. with phpmyadmin.

[Hagforce]

Thank you for replying :)

Does the induvidual database user have rights to do this, or do I have to log in as root to do this?

[till]

You will have to login as root for this. As far as I know, mysql is not able to delegate the right to create users for just one database to a user that has onyl access to this database.