Quite some time ago, I started doing a book of exercises. I got some work, put it down, and now I need to start over. So I start up MySQL, do a "DROP DATABASE [name];". And I'm answered by:
ERROR 1008: Can't drop database '[name]'. Database doesn't exist"
So I figure, okay, then I can CREATE it, right? This time I'm answered by:
ERROR 1006: Can't create database '[name]]. (errno: 17)"
What's going on? Shouldn't be one or the other work?
Thank you.
Steve Tiano
Steve,
You probably forgot to log in with someone that has the authority to drop a database. Try logging in as root user using "mysql -uroot -ppassword" and then do a "Show Databases" to see if the database exists, then do a "Drop Database databasename".
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
