Can not create database

[bannas]

i downloaded and installed MySQL, am at the part where it says "right click on the database section" etc. etc....

Only problem is i right click and all i can friggin get is a "flush hosts, flush logs, tables, threads? pop up.. what am i doin wrong?

[JamesLF]

The newest version of mysql doesn't allow you to create a database like that. Instead, go to C:\mysql\bin and open mysql.exe.

Type: create database eq;

Then your database will be made and you can go on through the rest of the steps :wink:

[bannas]

Ty very much James =)

[fnemo]

If you use the GUI for MySQL, as i think you do, there is a tiny bouton "SQL" thats is used to create a new DB.

[YoSoyElQueso]

Ok, I go in to the bin directory and open mysql.exe but before I can type anything, it dissapears. Can anyone tell me if I'm doing something wrong?

[SargonVI]

You have to open a DOS window and then go to the directory and type it, that will show the error you are getting from running MYSQL.exe. To do that:

Win9x: Go to run then type Command at the prompt, then browse to your MySQL\bin

WinNT/2000/XP: Go to run then type Cmd at the prompt, then browse to your MySQL\bin

[YoSoyElQueso]

Ok, I get there and now I get a message that says "Error 2003: Can't connect to MySQL server on 'localhost' (10061)"
I'm connected to a network, can I not run it from my computer but it has to be from the host?

[Pneu]

If mysql is installed correctly then you should be able to click START, RUN and type

C:\mysql\bin\mysqladmin create eq

to make a database, and

C:\mysql\bin\mysqladmin drop eq

to delete it when you mess it all up and want to resource it :). You should do this on the machine upon which mysql is installed. The network should not matter. Hope that helps

Pneu