PDA

View Full Version : mysql

cold119
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
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
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
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
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
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
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
10-01-2002, 09:40 AM
nm i fixed it, my router was messing the whole thing up :D
now another question, i did all the steps, but it says my server is locked, whys that?
Lurker_005
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