Databases created with mysql command are not visible in ISPManager and are not backed up?

Question

MySQL

I transfer more than 50 databases and users from one VPS to another .
My shell script has a loop that executes the command:

mysql -u root
create database $DB_NAME;
grant all privileges on $DB_NAME.* to [email protected]'localhost' identified by $DB_PASSWORD;
FLUSH PRIVILEGES;

but, such databases are not visible in the ISPManager panel, hosting technical support writes:

Please note that databases created in this way will not be visible in the control panel and, accordingly, will not be copied when the backup of the Control Panel is configured. Also please note that this is full root access to mysql.

is that what it is? and nothing to do about it?
those. exit or stop using ISPManager or manually create 50 databases with individual users?

Answer 1

In the Databases section, click on the " DB Servers " button , then select the MySQL server and click on Free Databases and see all the databases created from under the shell - select the desired one and click Transfer - assign the desired user (owner in ISPManager)

Answer 2

Yes, the panels interfere. Use Ansible to manage the server.

Answer 3

Hello! The ISPmanager product has the ability to migrate from server to server: https://docs.ispsystem.ru/ispmanager6-lite/instrum...
If you make any changes without using the panel, then it will not be able to manage this data, because to. it will not contain information about the changes made.
If the migration is carried out from an empty server to ISPmanager, you need to create a database manually or using the API: https://docs.ispsystem.ru/ispmanager6-lite/razrabo...
Database dumps ( https://docs.ispsystem.ru/ispmanager6 -lite/bazy-da... ) must be imported via the dock and then download the site files via FTP.
We hope we have cleared up the situation. If you have additional questions, please open a ticket in our Support Service and tell us its number, we will follow up with your issue: [email protected]