Multiple Databases - Same User ID?

Discussion in 'General' started by Mosquito, Jan 28, 2010.

  1. Mosquito

    Mosquito New Member

    One of my clients has an inhouse application that connects to multiple MySQL databases with the same user credentials. I really don't know a ton about this application, other than it would be quiet difficult to rewrite.

    My question - how do / (can) I set up multiple databases for this client, yet allow each database to use the same username? When I've tried creating two databases (difference DB names, obviously) with the same username I get the following error

    "There is already a database user with this name on the server. To get a unique name, e.g. prepend your domain name to the username."

    Thanks.
     
  2. theWeird

    theWeird Member

  3. Ben

    Ben ISPConfig Developer ISPConfig Developer

    Depending on how urgent this is, you could avoid ispconfig here and create additional DBs directly (mysql on the console, phpMyAdmin via Web...) and set the grants to them for the existing user.
    But don't forget, that at least the additional DBs won't probably be deleted by ispconfig when you delete the user and the DB ISpconfig created for him...
     
  4. Mosquito

    Mosquito New Member

Share This Page