"Ola Ogunneye" <[EMAIL PROTECTED]> wrote: > > I have just finally finished my error free installation of mysql 4.0.13 > on Apache 2.0.47 and PHP 4.3.2 all running on Windows 2000 Advanced > Server. > > I was able to follow a direction that helped me change the root user to > myname and asign a password to myname. After that, I created 3 databases > in addition to the test and mysql that were already created through the > install process. > > My problem is that when I created the databases, I did not do anything > else - no tables. > > I am running another application (Geeklog) and in the install of > Geeklog, I got an error message saying that the "Table gl_access already > exist" when I went to Geeklog forum help, it says that my problem is > that I had performed an unsuccessful installation prior to this > successful one, and therefore, I need to delete the table or better yet, > delete the database and create a new one to use with Geeklog > installation. > > The real question is that I do not know what would happen if I delete > the database, and how do I delete the database? > > I thought it is something I could do at the command prompt just the same > way I created the database: > > mysql>create database dbasenow > > would the following work: > > mysql>delete database dbasenow
No, the correct command is DROP DATABASE: http://www.mysql.com/doc/en/DROP_DATABASE.html > > Or do I have to delete the tables in it first? If you remove database, all its tables will be deteted, too. > Please understand that > when I created the databases, I did not create any tables, but when I > used PHPMYADMIN, I found that the database in question has tables in it > while the other 2 that I created had nothing in them.. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]