Softaculous


Topic : database problem need help urgent


Posted By: sameed on October 10, 2014, 6:07 pm
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

Posted By: sameed on October 11, 2014, 2:04 am | Post: 1
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

Posted By: valley on October 13, 2014, 7:57 am | Post: 2
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


Posted By: andiklive on October 14, 2014, 3:16 am | Post: 3
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


Posted By: valley on October 14, 2014, 9:29 am | Post: 4
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


Powered By AEF 1.0.8 © 2007-2008 Electron Inc.