Its been a long while since i have actually used the mysql command line client..
Thanks to phpmyadmin which i have been using for the past 2 years.
phpMyadmin does many things without troubling me.
I had a problem renaming a database and I found out that mysql does not have rename database statement until MySQL 5.1.7.
so what to do ?
mysqldump came to the rescue as usual. I had to generate a dump of the current database.
Then create a new database with the desired name, and then import back the dump into the
new database , and then drop the old database.