Author Topic: Can not view database list from a specific user account in mysql manager page  (Read 910 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
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.

Offline
*
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?

Offline
*****
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.
You can ask me to solve any problem with your server for some money in pm  ;)
Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor
Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
I have tried the command
Code: [Select]
mysql -e "show databases"and there is no error

Offline
*****
It must be investigated by a system administrator. As I know new CWP versions do not have the issue.
You can ask me to solve any problem with your server for some money in pm  ;)
Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor
Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services