mysql drop / create database
 

in the database tab window

right clicking on a database should have a dropdown window with the drop database , create database etc. today it is missing , somehow locked out on the mysql interface from doing this.

I have seen this problem before with 3.23 but can't remember what fixed it. all i have now is flush hosts , flush ect.

anyone know what causes this? the options arn't even greyed out they just arnt there.

Thanks mudman

Its the new verison of winmysqladmin..

You need to use the command line to do it..


c:\mysql\bin\mysql

mysql>drop database eq;
mysql>create database eq;
etc.

.
 

wierd that was a nice little feature, wonder why it was dropped. i thought i saw it on a previous installation of the same version of mysql though. guess it does not matter

but.. i tried create database in mysql prompt and it did not show up in the database window which worries me. i reinstalled with 3.23 but same deal.

ty

I know im retarded for not knowing how to do this but could you please be a little more detailed? i dont really know much about this MySQL program and using the command prompt to control it.
Thanks

Xan...Just do this.

Go to C:\Mysql\bin\Mysql.exe
(Or wherever you may have installed it,above is the default directory)

To create the EQ database type...

Create Database EQ;

To drop it type....

Drop Database EQ;