How to update MySQL user list in ISP Manager?

Question

System administration

Good evening,

ISP Manager 4.4 Lite is used to manage the server

There is a user on the server, let's say user
He had a MySQL user of the same name.

But then, by accident, the MySQL user was deleted.
I logged into PhpMyAdmin as root and created a new user with the same password.

Everything worked, but the user disappeared from ISP Manager`a.
Those. when creating a database, it is impossible to select it, and, accordingly, give it privileges.

All this, of course, is not fatal, but creates inconvenience.

As I understand it, the ISP has its own "registry" of MySQL users.
Does anyone know how to update it, or manually edit the settings file?

I tried to look in /usr/local/ispmgr/etc/ispmgr.conf - there is only a list of database owners.

Answer 1

The ISP manager panel does not have any "registry", except for its config.
Just in the same phpMyAdmin give privileges to the newly created database user on one of the databases owned by the corresponding system user. I am convinced that then the database user will be displayed in the panel.

Answer 2

At the end of the ispmgr.conf file, write a line like
DbAssign "MySQL" test66 503
where test66 is the user you are looking for in mysql, 503 is the gid of the user to which this mysql user is bound

Answer 3

Apparently, it's impossible to add a database that is in replication. She doesn't show up anyway.
Even renaming the current one and trying to create a new one with the same one results in an error - the database already exists.