I had created a MySQL database to install wordpress but due to some tinkering I did in the phpmyadmin it displayed an error "No Privileges". I'm don't have much knowledge in mysql databases, I spent a week searching for a solution, tried many but nothing seemed to work. In the Yahoo cPanel there is no option to delete a database and do a clean install, if there was this would be obviously my first choice but when nothing worked I searched for a solution to delete mysql database in Yahoo and found the solution, deleted the mysql database and created a fresh database and now everything is working properly. So I'm posting this message for any user searching for a similar solution. To delete mysql database:-
Go to cPanel - File Manager - Open Database Utilites - Now in the url you'll have an address like this -
https://yahoo.com/db/?ssc=in1 - in the url just before the question mark type 'delete' and hit enter
(https://yahoo.com/db/delete?ssc=in1) - that's it the database will be deleted.