Welcome Guest. Please Login or Register  
Client Area  |  Softaculous Cloud  |  Calendar  |  Quick Links  |  
   


You are here: Index > Webuzo > General Support > Topic : database not show up but still exists on phpmyadmin



Threaded Mode | Print  

 database not show up but still exists on phpmyadmin, Unable to create database (7 Replies, Read 43289 times)
darrendave
Posted on # January 5, 2016, 11:41 am
Group: Member
Post Group: Newbie
Posts: 4
Status:
I have problem...

I have only 2 databases and still running
but when I open on manage database via webuzo
not show any databases

I tried to create new database
error : "Unable to create database"

I open phpmyadmin
our 2 databases still in there and still works!

I tried create 1 new database
with new user also

still not show up on manage databases

I heard about mysql password issue
YES I changed mysql root password
coz I can't login on phpmyadmin before
now I can login on phpmyadmin
after change mysql root password
our databases still show up on [manage database menu]

but now our databases not show up

Please help me to fix it
IP: --   

database not show up but still exists on phpmyadmin
peopleinside
Posted on # January 6, 2016, 1:21 pm | Post: 1
Group: Member
Post Group: Super Member
Posts: 1394
Status:

Open source, web and security passionate 		Hi,
maybe you have changed the phpmyadmin password of root or the
/var/webuzo/my.conf

If you are on CentOs you have to put the right mysql password in the file

/var/webuzo/my.conf


-----------------------
PeopleInside  :angel:

Web, security, open source passionate.
IP: --   

database not show up but still exists on phpmyadmin
darrendave
Posted on # January 6, 2016, 1:49 pm | Post: 2
Group: Member
Post Group: Newbie
Posts: 4
Status:
what syntax to input password on my.conf (on centos)?

coz my my.conf just have 1 line text and can't read (like machine code)

please guide me
IP: --   

database not show up but still exists on phpmyadmin
peopleinside
Posted on # January 6, 2016, 1:58 pm | Post: 3
Group: Member
Post Group: Super Member
Posts: 1394
Status:

Open source, web and security passionate 		Hi,
sorry I Am just an user of Webuzo control Panel, I AM not part of Webuzo Team.

I have this issue on the past also I see some user have the same issue ... database exist but are not showed on Webuzo.

From what I know this problem happen when you change the root mysql password from phpmyadmin.

The password is changed by phpmyadmin but not changed into Webuzo so Webuzo can't have access to yours database.

Or maybe you edited the my.conf file.

Do you know your root mysql password? If yes please try to open Webuzo, click on phpmyadmin try to put username root and your root password.
Are you able to log in?

If the reply is yes I suggest to backup the my.conf file, after this delte the content and insert the password of mysql root here by pressing I as (insert) when you finish esc than :wq for exit and save.

Try now to restart mysql service.
Are now able to see databases?

If not plase try to restart webuzo service : service webuzo restart from SSH
are now able to see your databases in webuzo?

If not please resume your my.conf file and ask help to the Webuzo team.

WARNING:
your my.conf file should contain only one row with letter and number. This should be the actual mysql root password for webuzo, maybe this is different from your actual mysql password.

IF you did not change the root mysql password in the past please not follow this post and wait for Webuzo support.

All i told you is only a suggestion, is at your risk. Maybe you are more safe to wait some days the reply of Webuzo team who maybe will told you if what i suggest to you is correct or no.



-----------------------
PeopleInside  :angel:

Web, security, open source passionate.
IP: --   

database not show up but still exists on phpmyadmin
peopleinside
Posted on # January 6, 2016, 2:01 pm | Post: 4
Group: Member
Post Group: Super Member
Posts: 1394
Status:

Open source, web and security passionate 		You can read also this topics:

http://www.softaculous.com/board/index.php?tid=3510

http://www.softaculous.com/board/index.php?tid=7811




-----------------------
PeopleInside  :angel:

Web, security, open source passionate.
IP: --   

database not show up but still exists on phpmyadmin
peopleinside
Posted on # January 6, 2016, 2:07 pm | Post: 5
Group: Member
Post Group: Super Member
Posts: 1394
Status:

Open source, web and security passionate 		For put correct password root into my.conf you need to log in into SSH with root account.

after that
do this command:
PHP Code

 cd / 


PHP Code

 cd /var/webuzo 


For backup
PHP Code

 cp my.conf my.conf.bk 



Now we need to open the file
PHP Code

 vi ./my.conf 


here press letter I on your keyboard and edit the password after press esc on your keyboard and than :wq for exit and save

PHP Code

 service webuzo restart 



Hope it helps,
maybe also after that if you don't see the database try to restart mysql service from Webuzo Serives.

If the issue persist you need contact Webuzo.

Thank you.


-----------------------
PeopleInside  :angel:

Web, security, open source passionate.
IP: --   

database not show up but still exists on phpmyadmin
darrendave
Posted on # January 8, 2016, 8:33 am | Post: 6
Group: Member
Post Group: Newbie
Posts: 4
Status:
Quote From : peopleinside January 6, 2016, 2:07 pm
For put correct password root into my.conf you need to log in into SSH with root account.

after that
do this command:
PHP Code

 cd / 


PHP Code

 cd /var/webuzo 


For backup
PHP Code

 cp my.conf my.conf.bk 



Now we need to open the file
PHP Code

 vi ./my.conf 


here press letter I on your keyboard and edit the password after press esc on your keyboard and than :wq for exit and save

PHP Code

 service webuzo restart 



Hope it helps,
maybe also after that if you don't see the database try to restart mysql service from Webuzo Serives.

If the issue persist you need contact Webuzo.

Thank you.



YES This WORK!!!

thank you for your help!

you are smart and can make easy step to do it  ;-D
IP: --   

database not show up but still exists on phpmyadmin
peopleinside
Posted on # January 8, 2016, 8:41 am | Post: 7
Group: Member
Post Group: Super Member
Posts: 1394
Status:

Open source, web and security passionate 		I AM happy to hear you have resolved quickly.


-----------------------
PeopleInside  :angel:

Web, security, open source passionate.
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is April 27, 2024, 11:59 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 10  |  Page Created In:0.032