With the command given below you will be able to repair all the dbs in your server. It may take some time. mysqlcheck -A -h localhost -u root -r -p After you enter this command,you will be asked for your mysql root password.just write your mysql root password and hit enter. If you dont know your mysql root password,you can reset it here WHM >> SQL Services >> Reset Local MySQL Root Password
But this command is also do the same without mysql root password: For Repair mysqlcheck --all-databases -r #repair For Analyze mysqlcheck --all-databases -a #analyze For optimize mysqlcheck --all-databases -o #optimize Hope it will also help to users... Regards,