Old mysql account on master server

Discussion in 'ISPConfig 3 Priority Support' started by tr909192, Aug 30, 2021.

  1. tr909192

    tr909192 Member HowtoForge Supporter

    Dear,

    over the years happens usually that some old slave node (on a master-slave configuration) are removed (because no longer used or due updates...).
    Generally we simply uninstall the ispconfig on the slave server, and remove the server entries on the master control panel (after that all the website of the old node are migrated).
    What I see there is that on the master database, the old user used by this old nodes are still on the db.
    This users are not removed from the uninstall script, right?

    It's there a way to clean up in a safe way all the unused user on that mysql database?
    For most of this user exist more than one entry (for example an user can connect from the IP and the hostname of the slave server).
    That create a mess.

    ty
     
  2. Jesse Norell

    Jesse Norell Well-Known Member Staff Member Howtoforge Staff

    The easiest way is probably just browse in phpmyadmin and delete the old users. There is nothing in the servers table which ties to a mysql username.
     
    tr909192 likes this.

Share This Page