Hey. I'm new to MySQL, and trying to teach myself from a book. The problem is, i can't seem to get it to run properly. I have MySQ 4.0.4 beta running on Windows 98.

The thing is, the book tells me to run WinMySqlAdmin which automatically runs the mysqld-opt server. So i do. Except when the server is running it slows down my comp. and when i try to connect to the server in DOS it just sits there and doesn't do anything. I am typing mysql -u j (my username) -p
I then type my password at the prompt which is also j.
I've tried variations of this command. For example - mysql -h localhost -u j -p but still the same.

If i don't have the server on, when i try these commands to connect to the server i get the error "ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)" which makes sense since the server isn't on. but as i said, when the server is on, it just sits there and i get no feedback. and i have tried all the commands which are supposed to write errors to a text file etc - but still nothing. Now if i close the mysqld-opt server i get the error about where it has lost contact with the server during a query which also makes sense.

The strange thing is, i spent hours trying to get this all to work, and then the next day i somehow got it to work in no time. I was connected to the server and everything and there was no sign of slowdown. I could issue the mysql commands and stuff. The thing that's strange is, when i asked it to connect to the server, i could have sworn there was no server running so i am bamboozled. I have no idea what it is i am doing wrong. I am really desperate and would appreciate any help on getting the whole thing working correctly so i can teach myself it.

Please don't ignore this because it isn't a specific MySQL problem. I'm really desperate here and don't know where else to turn. I've read the manual countless times and am getting nowhere.

Thanks in advance.

DanielTeam Member

Joined: 06 Jan 2002
Posts: 2564

Posted:
Wed Jun 25, 2003 12:17 pm (14 years, 8 months ago)

Not sure what your problem is, but wouldn't it be easier for you to install an "all in one" package which has Apache, PHP & MySQL, and which would probably do all this stuff for you, and hopefully work.

You cannot post new topics in this forum.You cannot reply to topics in this forum.You cannot edit your posts in this forum.You cannot delete your posts in this forum.You cannot vote in polls in this forum.