Making users for My SQL database

Discussion in 'General' started by Hagforce, Dec 20, 2007.

  1. Hagforce

    Hagforce New Member

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

    till Super Moderator

    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.
     
  3. Hagforce

    Hagforce New Member

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

    till Super Moderator

    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.
     

Share This Page