First Cd /var/lib/mysql/ then select the DB need to repaired..
cd database name/
ls
Then Execute the command,
myisamchk -o -f tablename (TO CHECK THE TABLES ASSOCIATED WITH DB)
Eg, myisamchk -o -f tablename Eg, myisamchk -o -f abc.MYI
myisamchk -r *.MYI (TO CHECK ALL THE TABLES ACSSOCIATED WITH THE DB)
How to grant full privillage for a user on database.
Enter in to mysql , then shoot the command,
eg, GRANT ALL PRIVILEGES ON cpaneluser_db.* TO cpaneluser_dbuser@localhost IDENTIFIED BY 'dbuserpassword';
mysql>GRANT ALL PRIVILEGES ON indian_test.* TO indian_test@localhost IDENTIFIED BY 'd3fault1';
where indian_test is the db name indian_test as username and d3fault1 as password