Control Web Panel

WebPanel => CentOS 7 Problems => Topic started by: Andrawenial on March 20, 2018, 12:29:40 PM

Title: [CentOS7][Mysql] MYSQL nan%
Post by: Andrawenial on March 20, 2018, 12:29:40 PM
Hello,

So yesterday my boss disconnected my laptop where i ran centos7 Web Panel.
Afterwards i tried to connect to my sites after rebooting, nothing worked as it should.
I use CWP as test server right now for our homepage before going live, and maybe we'll use it afterwards as real webserver.

But now my problem right now, as everything was broken i had chosen to reinstall everything.
So i reinstalled centos7 minimal and afterwards CWP el7 latest.

So far everything works just like before, but now when i create a new user, log into that user, i can't create any database for him.
So in the circle above MYSQL there is only the following : nan%

Anyone know how to resolve this?

Thanks
Andra
Title: Re: [CentOS7][Mysql] MYSQL nan%
Post by: nguyentrunghoa on March 20, 2018, 12:55:57 PM
I'm getting the same problem:

Today my CWP can't create Database & User.

At MYSQL / it show: nan% as this: https://ibb.co/cqOQ2x

How I should do to fix for this problem?

My VPS info:
CentOS release 6.8 (Final)
KV2.6.32-642.el6.x86_64
PLx86_64
UP46 days, 8:54
STTue Mar 20 12:39:47 2018
Ver.1.06
Title: Re: [CentOS7][Mysql] MYSQL nan%
Post by: Administrator on March 20, 2018, 12:59:26 PM
the best would be that you contact support to check that

http://centos-webpanel.com/contact
Title: Re: [CentOS7][Mysql] MYSQL nan%
Post by: nguyentrunghoa on March 20, 2018, 01:27:41 PM
Thanks for fast support,

I have just send ticket.

Regards,
Title: Re: [CentOS7][Mysql] MYSQL nan%
Post by: Andrawenial on March 20, 2018, 01:49:19 PM
made a ticket now aswell,

thansk for your answer,

best regards
andra
Title: Re: [CentOS7][Mysql] MYSQL nan%
Post by: nguyentrunghoa on March 20, 2018, 03:15:32 PM
Still no one help me!

I'm having 2 VPS is getting this problem now!

Title: Re: [CentOS7][Mysql] MYSQL nan%
Post by: kortibu on March 21, 2018, 08:53:40 AM
Having the same problem :((
Title: Re: [CentOS7][Mysql] MYSQL nan%
Post by: Andrawenial on March 21, 2018, 11:47:32 AM
tried again now using wentos 6.9 with cwp 6, same problem as with cwp 7 :(
Title: Re: [CentOS7][Mysql] MYSQL nan%
Post by: iTBoss on March 21, 2018, 11:58:14 AM
hi,

Login to phpmyadmin with that acoount's user and pass, then create a database.

that's all

the user will now be able to create any database directly from his user account.



or

from admin panel, create a database for that user.

Title: Re: [CentOS7][Mysql] MYSQL nan%
Post by: Andrawenial on March 21, 2018, 12:17:40 PM
Thanks alot iTBoss

Works like a charm after creating a database from admin panel

*thumbs up*