Can not create database

bannas · #1 12-08-2002, 08:58 PM

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 · #2 12-08-2002, 09:49 PM

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

bannas · #3 12-08-2002, 11:27 PM

Ty very much James =)

fnemo · #4 12-09-2002, 06:54 AM

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 · #5 12-10-2002, 02:37 AM

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 · #6 12-10-2002, 02:52 AM

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 · #7 12-10-2002, 03:09 AM

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 · #8 12-10-2002, 07:43 AM

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