cluster with centos7

I guess there are three possible sources for the problem then:

a) You used a non mysl-root user for ispconfig installation so the installer had insufficient privileges.
b) The database was removed by accident and the mysql users were altered at the time you configured the mysql cluster.
c) You use an unsupported MySQL version. You xcan use any MySQL or MariaDB version except of MySQL 8 as MySQL 8 is not fully compatible with older MySQL versions.

 

No, this will not work as ISPConfig is not fully installed due to missing database access. You must have a mysql root user which has full access to mysql incl. grant privelige and then use this root user when you install ispconfig so that the ispconfig installer can create the database, the tables and the database users and load the installation specific data into the database.

The i9nstallation of ispconfig on the first server will create a user 'ispconfig' which has full access to the local dbispconfig1 database. The installation of the second node will craete another user 'ispconfig' on the second node with access to the local 'dbispconfig2' database and it will create a user ispcsrv1 on the first node which has limited access to the dbispconfig database on the first node as it is used to pull data to the slave database, so this ispcsrv1 user shall not have full access, it has just access to some tables and fields, you can see that in the sub tables of the mysql.mysql database.