mysql

cold119 · #1 10-01-2002, 08:11 AM

i was wondering if anyone could help me out with mysql..
everytime i open it (winmysqladmin) the light says its green but when i try to add an eq database it keeps saying not connected.
I've tried everything, from uninstalling, reinstalling, and deleting the my.ini file and making a new account..
anyone got suggestions plzzz help ?:(

Trumpcard · #2 10-01-2002, 08:16 AM

Mysql is really simple.. If you've got a green light, you should be able to connect to the database.

First, open up a command prompt, and cd to the c:/mysql/bin directory.

Once there, type 'mysql'

You should be in the database at this point, if you do not receive an error message, the database is up and running. If you get the mysql> prompt, you are in and connected.

Where are you getting an error, your post is rather vague.

cold119 · #3 10-01-2002, 08:20 AM

ok, this is what i do.
i open mysql c:\mysql\bin and open the file "winmysqladmin"
everything boots up and when i click the database tab nothing shows up in the database (theres suppose to be 2 defaults right?) then i right click in the databases and click "create database". but all it says is "the server must be connected"
oh and i did what you said it gave me an error msg, "error 2003: 'can't connect to mysql server on 'localhost' <10061>

Trumpcard · #4 10-01-2002, 08:36 AM

Try rebooting first.. then open winmysqladmin, and make sure the database is started.

Then try to connect via the command line.

Lurker_005 · #5 10-01-2002, 08:36 AM

Only guess I have is you used the wrong username or password for mysql...

Anyhow, www.mysql.org is the best place to start, check the faq over there, and look for links to troubleshooting or help.

cold119 · #6 10-01-2002, 08:47 AM

tried restarting, still same thing.
and i made a new user name and pass, still nothing, is there anything else i can try?

cold119 · #7 10-01-2002, 09:13 AM

oh and how do i change my info on the first page? it said that my OS is "Whistler"

cold119 · #8 10-01-2002, 09:40 AM

nm i fixed it, my router was messing the whole thing up

now another question, i did all the steps, but it says my server is locked, whys that?

Lurker_005 · #9 10-02-2002, 05:08 AM

if there aren't any zones connected to world it will be listed as locked.

Check the world screen carefully for errors, and fix em