Control Web Panel

WebPanel => CentOS 7 Problems => Topic started by: babakprs on June 14, 2020, 03:17:35 PM

Title: MySQL Manager NOT working
Post by: babakprs on June 14, 2020, 03:17:35 PM
Hello,
I'm newbie and my knowledge about managing a server is very low.
I have installed CW7 some while ago and everything was okay. But now I got a problem with MySQL Manager and the list of database and users are not shown. I'm not sure but probably because I updated centos (yum update), however still database work
I found the below article with this regard, which is exactly about my problem:
https://wiki.centos-webpanel.com/mysql-manager-not-working

When I try mysql --version , I get an error message:
unknown variable 'max_user_connections=45'

How can I fix this problem?
If it is possible, guide me in simple language and step by step, as my knowledge in very low in this field.

Thanks :)


Title: Re: MySQL Manager NOT working
Post by: babakprs on June 14, 2020, 03:47:35 PM
I could fix the problem for roor by adding [mysqld] to /etc/my.cnf  and it works now.
But for one of my accounts, still it doesn't work and it just keeps loading.
Also I can not access to phpMyAdmin through accounts, but I can access through root

Screenshot:
https://ibb.co/yBVtX9r
(https://ibb.co/yBVtX9r)
Title: Re: MySQL Manager NOT working
Post by: Sandeep on June 14, 2020, 03:59:10 PM
we'll check it and there will be some update.
Title: Re: MySQL Manager NOT working
Post by: babakprs on June 14, 2020, 04:06:33 PM
Just wanted to add that in that account, which keeps loading for database and users, the same happens for the domain list, too and I can not see the domain list there.

For the other accounts, I can see database, users and domain lists.

In None of my accounts, I can access to phpMyAdmin (timeout error), except from root.

Thanks again for your help :)