Welcome Guest. Please Login or Register  


You are here: Index > Webuzo > General Support > Topic : database problem need help urgent



Threaded Mode | Print  

 database problem need help urgent (4 Replies, Read 10669 times)
sameed
Group: Member
Post Group: Newbie
Posts: 11
Status:
hi i have problem on my database
- enduser in manage database not show databases and also not able to create new database
- not able to login phpmyadmin

but database show fine in root and also select query working fine but other query not work
i service mysqld restart database from root its working fine

please tell me what i do where is problem
IP: --   

database problem need help urgent
sameed
Group: Member
Post Group: Newbie
Posts: 11
Status:
i check problem from mysql log file
its show me crashed some database table should be repire
i am not access to phpmyadmin can any one tell me how tp repair from root in webuzo
i run some command but not work
IP: --   

database problem need help urgent
valley
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
Did you change the password to the MySQL server's root user ? If yes, it should be added to the file /var/webuzo/my.conf

The following command can help to repair your database

/usr/local/apps/mysql/bin/mysqlcheck --repair --all-databases

Hope this helps



-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

database problem need help urgent
andiklive
Group: Member
Post Group: Working Newbie
Posts: 50
Status:
Quote From : valley October 13, 2014, 7:57 am
Did you change the password to the MySQL server's root user ? If yes, it should be added to the file /var/webuzo/my.conf

The following command can help to repair your database

/usr/local/apps/mysql/bin/mysqlcheck --repair --all-databases

Hope this helps



thanks for tips, it will save my time.

previously i repair it from phpmyadmin.

thanks

-----------------------
Get Free $50 VULTR Cloud Servers Credit

IP: --   

database problem need help urgent
valley
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
Quote From : andiklive October 14, 2014, 3:16 am
Quote From : valley October 13, 2014, 7:57 am
Did you change the password to the MySQL server's root user ? If yes, it should be added to the file /var/webuzo/my.conf

The following command can help to repair your database

/usr/local/apps/mysql/bin/mysqlcheck --repair --all-databases

Hope this helps



thanks for tips, it will save my time.

previously i repair it from phpmyadmin.

thanks


IF you have not changed the password to your MySQL servers' root user and if your MySQL service is running, you should be able to login to MySQL and perform the action.

You can learn more about the issue from the MySQL logs


-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

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 19, 2024, 5:12 am.

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