mysql drop / create database

[mudman]

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

[Trumpcard]

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.

[mudman]

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

[Xan]

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

[Drizzt40]

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;