[CentOS7][Mysql] MYSQL nan%

Started by Andrawenial, March 20, 2018, 12:29:40 PM

Previous topic - Next topic

Andrawenial

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

nguyentrunghoa

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

Administrator

the best would be that you contact support to check that

http://centos-webpanel.com/contact

nguyentrunghoa

Thanks for fast support,

I have just send ticket.

Regards,

Andrawenial

made a ticket now aswell,

thansk for your answer,

best regards
andra

nguyentrunghoa

Still no one help me!

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


kortibu


Andrawenial

tried again now using wentos 6.9 with cwp 6, same problem as with cwp 7 :(

iTBoss

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.


Andrawenial

Thanks alot iTBoss

Works like a charm after creating a database from admin panel

*thumbs up*