Change database client

Discussion in 'General' started by Devin McManus, Nov 30, 2021.

  1. Devin McManus

    Devin McManus New Member HowtoForge Supporter

    Hi there,
    Is there an easy way to change the Client that is assigned to a database?

    Code:
    # lsb_release -a
    No LSB modules are available.
    Distributor ID: Debian
    Description:    Debian GNU/Linux 10 (buster)
    Release:        10
    Codename:       buster
    # php -v
    PHP 7.3.31-1~deb10u1 (cli) (built: Oct 24 2021 15:18:08) ( NTS )
    Copyright (c) 1997-2018 The PHP Group
    Zend Engine v3.3.31, Copyright (c) 1998-2018 Zend Technologies
        with Zend OPcache v7.3.31-1~deb10u1, Copyright (c) 1999-2018, by Zend Technologies
    
    Screenshot 2021-11-30 163603.png

    Thanks in advance,
    Devin
     
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Have you tried changing the database user? What happens?
    If you first create a second database user for that client then it should be selectable from the dropdown database user menu in the database settings. Do you want an even easier way or does this method not work?
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    A database is assigned to the client by the website it belongs to. So when you change the client in database users settings first as mentioned by @Taleman, then the client in the website settings, and then go to the database settings and save the settings again.
     
    Jesse Norell likes this.

Share This Page