mysql localhost

Anon

Hi
I run MYSQL on Windows and every time I try to start it. It give me this message:
This is the way I did it.
c:\mysql\bin\mysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

Please help me, I really appreciate very much for your help
Kevin

Anon

You may not have the server itself started.

Try this,

change directory to:
c:\mysql\bin

then type:
mysqld and hit enter

This will start the mysql daemon (read server - that's what the d is for) and will allow you to use what is actually your command line mysql client (started by typing mysql)

If you don't start the server (mysqld), you can't connect to it.
matt.

Anon

Hello,

If it's Win95/98 it must be:

mysqld --standalone

Anon

That's not the way I've been running my server.

Should I be using the --standalone directive? If so, could you explain what that does, as I am not familiar with it. I'd be very interested.

Many thanks,
matt.

Anon

--standalone is needed when you are on a Windows 95/98 OS. If you are using NT, mysqld or mysqld --install is needed.

Every time you restart your system, you must retype mysqld --standalone to launch MySQL.

On NT, one time mysqld --install is suffisant.

Anon

Serdar wrote:
--standalone is needed when you are on a Windows 95/98 OS.

I guess I gathered that the above is what you meant in your last post.

What I am curious about is the function of the --standalone directive.

Why is it necessary or needed? I'm curious because I simply have a shortcut to mysqld in my startup folder and I don't use the --standalone directive and everything is working fine.

So, I'm just wondering. I'd be interested to know.

Thanks,
matt.

Anon

Thank you for responding.
I have tried the way you said, but the error message still appear. Here is the way I did
c:\mysql\bin\mysqld-shareware
c:\mysql\bin\mysql
ERROR 2003: Can\'t connect to MySQL server on \'localhost\' (10061)
This is the message I got when I tried.
I am running win2k with Internet Information Server 5. Even when I install the start up service, but I could not start it up in the Service,(got the same error message). Here is the way I install the service:
c:\mysql\bin\mysqld-shareware --install

I have done every single way I could,but no luck, please help me. Thank you in advance for you help.
Kevin

Anon

Thank you Serdar
but I am runing Win2K with IIS version 5
I have done that way too, but no luck.
Thanks again, please help
Kevin

Anon

Kevin

I have just installed mysql on win 98 and am having the same problem getting started - Have you resolved the problem?
If so please could you let me into the secret.

I am like a kid with a new toy without any batteries. Look forward to your reply.
Pete

Anon

I know I had the same error message when trying to connect to the database after adding a mysql username and password.

Basically when you insert into the MYSQL database a username and password that you wish to be able to connect to ANY mysql database.
When you do so you MUST MUST MUST use the password(whateveryoupasswordis) command to define the password.

Otherwise it switched to OLD mode because of the format of the password.

The solution would be to delete the MYSQL folder in the c:\mysql\data folder, then reinstall MySQL and when adding a username and password for access use the following commands:

run a dos command box
go to the c:\mysql\bin directory
type "mysql" and hit enter
type "use mysql" at the mysql prompt
then type:

insert into user (host, user, password) values ('localhost', 'yourusername', password('yourpassword');

then hit enter.

Hope all goes well!
Mike

Anon

I am using win2k Proffessional with IIS 5.0

I am getting error 2003....cant connect mysql to 'localhost...

I have started MYSQLD-shareware.exe

Please help me

Deepak

Anon

I had the same thing happening and I opened up MySql Admin up you know the program in the startup menu. Then I went all the way to the last tab and hit the button called "Generate Report" I don't know exactly what it did but I didn't get the error anymore.

cavcharlie

but still, i can't connect the localhost even i uninstall the mysql...