MySql Problem...

Poink · #1 12-12-2002, 12:22 PM

When i click on the database tab and rightclick all it comes up with is a tab that shows flush logins, flush hosts, flush tables. It won't show me the create database tab or anything else in that matter. Is it somthing with this program or what else could it be?

cyankee56734 · #2 12-12-2002, 01:02 PM

I have the same problem.

But, I worked around it (Which might be why I have another problem)

I just located the test directory and renamed it to EQ. It was empty anyway.

But, when I try and login, my server is locked.

Ugh! I'm learning this stuff. Any insight?

Waruen · #3 12-12-2002, 09:01 PM

Load mysql (same file you do the "use eq" step)
type create database eq; <--with semicolon

cyankee56734 · #4 12-13-2002, 01:18 AM

Thanks! WAs about to drive myself crazy!

Might even be why I was having problems.

Poink · #5 12-13-2002, 02:28 PM

Umm but still i tried to change the test database's name but it wont even select it =/ and when i rename any other database it just switches it back to its old name. I have no clue whats going on, read almost everything i can think of

Pneu · #6 12-14-2002, 02:37 AM

Click START
Click RUN
type COMMAND
click OK

in the window which appears type the following lines

cd \mysql\bin
mysqladmin drop eq
(if you get asked a yes / no question, answer yes - this deletes any previous mistakes in creating the database you might have made)
mysqladmin create eq

You have now created the eq database and are ready to source in a working .sql file. I have posted one in several other recent threads, or follow the instructions for making your own.

Pneu