Can not view database list from a specific user account in mysql manager page

There are 3 mysql database and 3 mysql database users and all are working perfectly. Also creating mysql database and users also perfectly getting done. I checked from admin there's all database is showing and working everything is perfect.

But when I came into the user panel it's showing "There's not database created." / "There's not user created." Means no database showing in user panel. mysql manager page but in dashboard it's showing the total number of database,.

Also surprisingly this issue is happening only for a specific user account in my server there is no issue on other user account on my server.

Have you understood my issue? what is the possible cause & fix for this issue. I think customer have done something nasty like deleting any config file.

I found a solution at https://wiki.centos-webpanel.com/mysql-manager-not-working.
but i am confused / don't understand with: "For MariaDB which is default with CWP please note that you need to add config into file
/etc/my.cnf.d/server.cnf under [mysqld] "
what config / code to add?

I found a solution at https://wiki.centos-webpanel.com/mysql-manager-not-working.
but i am confused / don't understand with: "For MariaDB which is default with CWP please note that you need to add config into file
/etc/my.cnf.d/server.cnf under [mysqld] "
what config / code to add?

Hi, that means the SQL server configuration must not have any error. You can try to check with command:

Code: [Select]

mysql -e "show databases" for errors.

I have tried the command

Code: [Select]

mysql -e "show databases"and there is no error

It must be investigated by a system administrator. As I know new CWP versions do not have the issue.