Control Web Panel

WebPanel => MySQL => Topic started by: senindiaonline on December 22, 2019, 08:38:50 PM

Title: Can not view database list from a specific user account in mysql manager page
Post by: senindiaonline on December 22, 2019, 08:38:50 PM

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.

Title: Re: Can not view database list from a specific user account in mysql manager page
Post by: mcyahoo on December 24, 2019, 12:39:45 AM

I found a solution at https://wiki.centos-webpanel.com/mysql-manager-not-working. (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?

Title: Re: Can not view database list from a specific user account in mysql manager page
Post by: Igor S. on December 25, 2019, 06:36:00 PM

Quote from: mcyahoo on December 24, 2019, 12:39:45 AM

I found a solution at https://wiki.centos-webpanel.com/mysql-manager-not-working. (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.

Title: Re: Can not view database list from a specific user account in mysql manager page
Post by: mcyahoo on December 29, 2019, 11:35:37 PM

I have tried the command

Code: [Select]

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

Title: Re: Can not view database list from a specific user account in mysql manager page
Post by: Igor S. on December 30, 2019, 12:03:07 PM

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