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