469,625 Members | 1,109 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,625 developers. It's quick & easy.

What's Wrong Here?

Hello-
This is my first post, thank you.
I've recently purchased the Sams "Teach Yourself MySQL in 21 Days".
Per the lessons, I installed MySQL on my Windows XP machine. Things
seemed to be running ok. I was able to install it and run mysqld.exe
and mysql.exe. I was able to follow along with the book ok and created
a databas. Then the book asked me to install the ODBC thing. I did so.

Since I installed it, mysqld.exe doesn't work, nor does mysql.exe.
When I open mysql.exe I no longer get a prompt and the window closes
very quickly with a beep coming from my computer.

I was getting (I believe) error 1067 regarding the driver and I
installed
the drivers (hopefully correctly, HOW do you tell?)and now I no longer
get
the error, but it still doesn't fire up.

Can anyone offer any insight?
Thanks
BW
Jul 19 '05 #1
15 2102
barry womb wrote:
Since I installed it, mysqld.exe doesn't work, nor does mysql.exe.
When I open mysql.exe I no longer get a prompt and the window closes
very quickly with a beep coming from my computer.
start -> run -> type: cmd -> press ok -> Black box called command line,
or console, should open. Then run mysql from there, and it won't close
the window and you can see the errormessage.

At the console you can start the mysql-console program by issuing this
command( If you installed mysql to c:\mysql ):

c:\mysql\bin\mysql
I was getting (I believe) error 1067 regarding the driver and I
installed
the drivers (hopefully correctly, HOW do you tell?)and now I no longer
get
the error, but it still doesn't fire up.


Where did you get the odbc driver, what was the name of it? Have you
tried uninstalling it? Did it help?
Jul 19 '05 #2
barry womb wrote:
Since I installed it, mysqld.exe doesn't work, nor does mysql.exe.
When I open mysql.exe I no longer get a prompt and the window closes
very quickly with a beep coming from my computer.
start -> run -> type: cmd -> press ok -> Black box called command line,
or console, should open. Then run mysql from there, and it won't close
the window and you can see the errormessage.

At the console you can start the mysql-console program by issuing this
command( If you installed mysql to c:\mysql ):

c:\mysql\bin\mysql
I was getting (I believe) error 1067 regarding the driver and I
installed
the drivers (hopefully correctly, HOW do you tell?)and now I no longer
get
the error, but it still doesn't fire up.


Where did you get the odbc driver, what was the name of it? Have you
tried uninstalling it? Did it help?
Jul 19 '05 #3
barry womb wrote:
Since I installed it, mysqld.exe doesn't work, nor does mysql.exe.
When I open mysql.exe I no longer get a prompt and the window closes
very quickly with a beep coming from my computer.
start -> run -> type: cmd -> press ok -> Black box called command line,
or console, should open. Then run mysql from there, and it won't close
the window and you can see the errormessage.

At the console you can start the mysql-console program by issuing this
command( If you installed mysql to c:\mysql ):

c:\mysql\bin\mysql
I was getting (I believe) error 1067 regarding the driver and I
installed
the drivers (hopefully correctly, HOW do you tell?)and now I no longer
get
the error, but it still doesn't fire up.


Where did you get the odbc driver, what was the name of it? Have you
tried uninstalling it? Did it help?
Jul 19 '05 #4
Hi Aggro-
I haven't had a chance to do what you're saying and I will tomorrow.
I believe I downloaded the odbc deal from microsoft.
Aggro <sp**********@yahoo.com> wrote in message news:<IO*************@read3.inet.fi>...
barry womb wrote:
Since I installed it, mysqld.exe doesn't work, nor does mysql.exe.
When I open mysql.exe I no longer get a prompt and the window closes
very quickly with a beep coming from my computer.


start -> run -> type: cmd -> press ok -> Black box called command line,
or console, should open. Then run mysql from there, and it won't close
the window and you can see the errormessage.

At the console you can start the mysql-console program by issuing this
command( If you installed mysql to c:\mysql ):

c:\mysql\bin\mysql
I was getting (I believe) error 1067 regarding the driver and I
installed
the drivers (hopefully correctly, HOW do you tell?)and now I no longer
get
the error, but it still doesn't fire up.


Where did you get the odbc driver, what was the name of it? Have you
tried uninstalling it? Did it help?

Jul 19 '05 #5
Hi Aggro-
I haven't had a chance to do what you're saying and I will tomorrow.
I believe I downloaded the odbc deal from microsoft.
Aggro <sp**********@yahoo.com> wrote in message news:<IO*************@read3.inet.fi>...
barry womb wrote:
Since I installed it, mysqld.exe doesn't work, nor does mysql.exe.
When I open mysql.exe I no longer get a prompt and the window closes
very quickly with a beep coming from my computer.


start -> run -> type: cmd -> press ok -> Black box called command line,
or console, should open. Then run mysql from there, and it won't close
the window and you can see the errormessage.

At the console you can start the mysql-console program by issuing this
command( If you installed mysql to c:\mysql ):

c:\mysql\bin\mysql
I was getting (I believe) error 1067 regarding the driver and I
installed
the drivers (hopefully correctly, HOW do you tell?)and now I no longer
get
the error, but it still doesn't fire up.


Where did you get the odbc driver, what was the name of it? Have you
tried uninstalling it? Did it help?

Jul 19 '05 #6
Hi Aggro-
I haven't had a chance to do what you're saying and I will tomorrow.
I believe I downloaded the odbc deal from microsoft.
Aggro <sp**********@yahoo.com> wrote in message news:<IO*************@read3.inet.fi>...
barry womb wrote:
Since I installed it, mysqld.exe doesn't work, nor does mysql.exe.
When I open mysql.exe I no longer get a prompt and the window closes
very quickly with a beep coming from my computer.


start -> run -> type: cmd -> press ok -> Black box called command line,
or console, should open. Then run mysql from there, and it won't close
the window and you can see the errormessage.

At the console you can start the mysql-console program by issuing this
command( If you installed mysql to c:\mysql ):

c:\mysql\bin\mysql
I was getting (I believe) error 1067 regarding the driver and I
installed
the drivers (hopefully correctly, HOW do you tell?)and now I no longer
get
the error, but it still doesn't fire up.


Where did you get the odbc driver, what was the name of it? Have you
tried uninstalling it? Did it help?

Jul 19 '05 #7
Ok, I uninstalled everything. The odbc thing, and mysql.

I reloaded mysql to a different drive and am trying again.
Unfortunately, I'm getting the same deal. Window opens, closes with a
beep. If you remember, all of this started AFTER I loaded the odbc
deal. Now it's not loaded but I'm still getting the same problem.

I tried starting it from the command line and it came back with this
error:
ERROR 2003: Can't connect to MYSQL server on 'localhost' <10061>

Any ideas.

ba*******@yahoo.com (barry womb) wrote in message news:<81**************************@posting.google. com>...
Hi Aggro-
I haven't had a chance to do what you're saying and I will tomorrow.
I believe I downloaded the odbc deal from microsoft.
Aggro <sp**********@yahoo.com> wrote in message news:<IO*************@read3.inet.fi>...
barry womb wrote:
Since I installed it, mysqld.exe doesn't work, nor does mysql.exe.
When I open mysql.exe I no longer get a prompt and the window closes
very quickly with a beep coming from my computer.


start -> run -> type: cmd -> press ok -> Black box called command line,
or console, should open. Then run mysql from there, and it won't close
the window and you can see the errormessage.

At the console you can start the mysql-console program by issuing this
command( If you installed mysql to c:\mysql ):

c:\mysql\bin\mysql
I was getting (I believe) error 1067 regarding the driver and I
installed
the drivers (hopefully correctly, HOW do you tell?)and now I no longer
get
the error, but it still doesn't fire up.


Where did you get the odbc driver, what was the name of it? Have you
tried uninstalling it? Did it help?

Jul 19 '05 #8
Ok, I uninstalled everything. The odbc thing, and mysql.

I reloaded mysql to a different drive and am trying again.
Unfortunately, I'm getting the same deal. Window opens, closes with a
beep. If you remember, all of this started AFTER I loaded the odbc
deal. Now it's not loaded but I'm still getting the same problem.

I tried starting it from the command line and it came back with this
error:
ERROR 2003: Can't connect to MYSQL server on 'localhost' <10061>

Any ideas.

ba*******@yahoo.com (barry womb) wrote in message news:<81**************************@posting.google. com>...
Hi Aggro-
I haven't had a chance to do what you're saying and I will tomorrow.
I believe I downloaded the odbc deal from microsoft.
Aggro <sp**********@yahoo.com> wrote in message news:<IO*************@read3.inet.fi>...
barry womb wrote:
Since I installed it, mysqld.exe doesn't work, nor does mysql.exe.
When I open mysql.exe I no longer get a prompt and the window closes
very quickly with a beep coming from my computer.


start -> run -> type: cmd -> press ok -> Black box called command line,
or console, should open. Then run mysql from there, and it won't close
the window and you can see the errormessage.

At the console you can start the mysql-console program by issuing this
command( If you installed mysql to c:\mysql ):

c:\mysql\bin\mysql
I was getting (I believe) error 1067 regarding the driver and I
installed
the drivers (hopefully correctly, HOW do you tell?)and now I no longer
get
the error, but it still doesn't fire up.


Where did you get the odbc driver, what was the name of it? Have you
tried uninstalling it? Did it help?

Jul 19 '05 #9
Ok, I uninstalled everything. The odbc thing, and mysql.

I reloaded mysql to a different drive and am trying again.
Unfortunately, I'm getting the same deal. Window opens, closes with a
beep. If you remember, all of this started AFTER I loaded the odbc
deal. Now it's not loaded but I'm still getting the same problem.

I tried starting it from the command line and it came back with this
error:
ERROR 2003: Can't connect to MYSQL server on 'localhost' <10061>

Any ideas.

ba*******@yahoo.com (barry womb) wrote in message news:<81**************************@posting.google. com>...
Hi Aggro-
I haven't had a chance to do what you're saying and I will tomorrow.
I believe I downloaded the odbc deal from microsoft.
Aggro <sp**********@yahoo.com> wrote in message news:<IO*************@read3.inet.fi>...
barry womb wrote:
Since I installed it, mysqld.exe doesn't work, nor does mysql.exe.
When I open mysql.exe I no longer get a prompt and the window closes
very quickly with a beep coming from my computer.


start -> run -> type: cmd -> press ok -> Black box called command line,
or console, should open. Then run mysql from there, and it won't close
the window and you can see the errormessage.

At the console you can start the mysql-console program by issuing this
command( If you installed mysql to c:\mysql ):

c:\mysql\bin\mysql
I was getting (I believe) error 1067 regarding the driver and I
installed
the drivers (hopefully correctly, HOW do you tell?)and now I no longer
get
the error, but it still doesn't fire up.


Where did you get the odbc driver, what was the name of it? Have you
tried uninstalling it? Did it help?

Jul 19 '05 #10
Also, I seem to remember when I was installing the ODBC thing the
first time, that I went into control panel/administrator tools/ODBC
Data Source Administrator and messed with something in there. I can't
remember what it was. If I go into the DSN tab now and click on
myocbc-3 test/configure, I get an error that says "the setup routines
for the ODBC 3.51 driver could not be found. Please reinstall the
driver".

That tells me that I don't have the driver loaded correctly. How do I
load it?
Any ideas?


ba*******@yahoo.com (barry womb) wrote in message news:<81**************************@posting.google. com>...
Hi Aggro-
I haven't had a chance to do what you're saying and I will tomorrow.
I believe I downloaded the odbc deal from microsoft.
Aggro <sp**********@yahoo.com> wrote in message news:<IO*************@read3.inet.fi>...
barry womb wrote:
Since I installed it, mysqld.exe doesn't work, nor does mysql.exe.
When I open mysql.exe I no longer get a prompt and the window closes
very quickly with a beep coming from my computer.


start -> run -> type: cmd -> press ok -> Black box called command line,
or console, should open. Then run mysql from there, and it won't close
the window and you can see the errormessage.

At the console you can start the mysql-console program by issuing this
command( If you installed mysql to c:\mysql ):

c:\mysql\bin\mysql
I was getting (I believe) error 1067 regarding the driver and I
installed
the drivers (hopefully correctly, HOW do you tell?)and now I no longer
get
the error, but it still doesn't fire up.


Where did you get the odbc driver, what was the name of it? Have you
tried uninstalling it? Did it help?

Jul 19 '05 #11
Also, I seem to remember when I was installing the ODBC thing the
first time, that I went into control panel/administrator tools/ODBC
Data Source Administrator and messed with something in there. I can't
remember what it was. If I go into the DSN tab now and click on
myocbc-3 test/configure, I get an error that says "the setup routines
for the ODBC 3.51 driver could not be found. Please reinstall the
driver".

That tells me that I don't have the driver loaded correctly. How do I
load it?
Any ideas?


ba*******@yahoo.com (barry womb) wrote in message news:<81**************************@posting.google. com>...
Hi Aggro-
I haven't had a chance to do what you're saying and I will tomorrow.
I believe I downloaded the odbc deal from microsoft.
Aggro <sp**********@yahoo.com> wrote in message news:<IO*************@read3.inet.fi>...
barry womb wrote:
Since I installed it, mysqld.exe doesn't work, nor does mysql.exe.
When I open mysql.exe I no longer get a prompt and the window closes
very quickly with a beep coming from my computer.


start -> run -> type: cmd -> press ok -> Black box called command line,
or console, should open. Then run mysql from there, and it won't close
the window and you can see the errormessage.

At the console you can start the mysql-console program by issuing this
command( If you installed mysql to c:\mysql ):

c:\mysql\bin\mysql
I was getting (I believe) error 1067 regarding the driver and I
installed
the drivers (hopefully correctly, HOW do you tell?)and now I no longer
get
the error, but it still doesn't fire up.


Where did you get the odbc driver, what was the name of it? Have you
tried uninstalling it? Did it help?

Jul 19 '05 #12
Also, I seem to remember when I was installing the ODBC thing the
first time, that I went into control panel/administrator tools/ODBC
Data Source Administrator and messed with something in there. I can't
remember what it was. If I go into the DSN tab now and click on
myocbc-3 test/configure, I get an error that says "the setup routines
for the ODBC 3.51 driver could not be found. Please reinstall the
driver".

That tells me that I don't have the driver loaded correctly. How do I
load it?
Any ideas?


ba*******@yahoo.com (barry womb) wrote in message news:<81**************************@posting.google. com>...
Hi Aggro-
I haven't had a chance to do what you're saying and I will tomorrow.
I believe I downloaded the odbc deal from microsoft.
Aggro <sp**********@yahoo.com> wrote in message news:<IO*************@read3.inet.fi>...
barry womb wrote:
Since I installed it, mysqld.exe doesn't work, nor does mysql.exe.
When I open mysql.exe I no longer get a prompt and the window closes
very quickly with a beep coming from my computer.


start -> run -> type: cmd -> press ok -> Black box called command line,
or console, should open. Then run mysql from there, and it won't close
the window and you can see the errormessage.

At the console you can start the mysql-console program by issuing this
command( If you installed mysql to c:\mysql ):

c:\mysql\bin\mysql
I was getting (I believe) error 1067 regarding the driver and I
installed
the drivers (hopefully correctly, HOW do you tell?)and now I no longer
get
the error, but it still doesn't fire up.


Where did you get the odbc driver, what was the name of it? Have you
tried uninstalling it? Did it help?

Jul 19 '05 #13
barry womb wrote:
Ok, I uninstalled everything. The odbc thing, and mysql.

I reloaded mysql to a different drive and am trying again.
Unfortunately, I'm getting the same deal. Window opens, closes with a
beep. If you remember, all of this started AFTER I loaded the odbc
deal. Now it's not loaded but I'm still getting the same problem.
So atleast one of the following must be true:
- Driver is not complitely uninstalled
- MySQL server is not compitely installed
- MySQL server is not correctly configured
- MySQL server is not running
- You are trying to connect to wrong server or client is incorrectly
configured or installed.

I personally bulieve that you have installed a wrong version of odbc
driver to your system, and it has corrupted it somehow. If this is the
case, I don't know how to fix it. (Well, except reinstalling Windows,
but there might be easier ways, but I'm not Windows XP guru)

I haven't worked much with odbc drivers, but atleast I have seen that
there is win95/98 version and win2k/xp versions (If I remember
correctly.) On worst case scenario, you have installed the win95/98 one
and it doesn't now allow you to uninstall itself.
I tried starting it from the command line and it came back with this
error:
ERROR 2003: Can't connect to MYSQL server on 'localhost' <10061>


I don't know if this helps, but that error message is explained here:

http://www.mysql.com/doc/en/Can_not_...to_server.html
Jul 19 '05 #14
barry womb wrote:
Ok, I uninstalled everything. The odbc thing, and mysql.

I reloaded mysql to a different drive and am trying again.
Unfortunately, I'm getting the same deal. Window opens, closes with a
beep. If you remember, all of this started AFTER I loaded the odbc
deal. Now it's not loaded but I'm still getting the same problem.
So atleast one of the following must be true:
- Driver is not complitely uninstalled
- MySQL server is not compitely installed
- MySQL server is not correctly configured
- MySQL server is not running
- You are trying to connect to wrong server or client is incorrectly
configured or installed.

I personally bulieve that you have installed a wrong version of odbc
driver to your system, and it has corrupted it somehow. If this is the
case, I don't know how to fix it. (Well, except reinstalling Windows,
but there might be easier ways, but I'm not Windows XP guru)

I haven't worked much with odbc drivers, but atleast I have seen that
there is win95/98 version and win2k/xp versions (If I remember
correctly.) On worst case scenario, you have installed the win95/98 one
and it doesn't now allow you to uninstall itself.
I tried starting it from the command line and it came back with this
error:
ERROR 2003: Can't connect to MYSQL server on 'localhost' <10061>


I don't know if this helps, but that error message is explained here:

http://www.mysql.com/doc/en/Can_not_...to_server.html
Jul 19 '05 #15
barry womb wrote:
Ok, I uninstalled everything. The odbc thing, and mysql.

I reloaded mysql to a different drive and am trying again.
Unfortunately, I'm getting the same deal. Window opens, closes with a
beep. If you remember, all of this started AFTER I loaded the odbc
deal. Now it's not loaded but I'm still getting the same problem.
So atleast one of the following must be true:
- Driver is not complitely uninstalled
- MySQL server is not compitely installed
- MySQL server is not correctly configured
- MySQL server is not running
- You are trying to connect to wrong server or client is incorrectly
configured or installed.

I personally bulieve that you have installed a wrong version of odbc
driver to your system, and it has corrupted it somehow. If this is the
case, I don't know how to fix it. (Well, except reinstalling Windows,
but there might be easier ways, but I'm not Windows XP guru)

I haven't worked much with odbc drivers, but atleast I have seen that
there is win95/98 version and win2k/xp versions (If I remember
correctly.) On worst case scenario, you have installed the win95/98 one
and it doesn't now allow you to uninstall itself.
I tried starting it from the command line and it came back with this
error:
ERROR 2003: Can't connect to MYSQL server on 'localhost' <10061>


I don't know if this helps, but that error message is explained here:

http://www.mysql.com/doc/en/Can_not_...to_server.html
Jul 19 '05 #16

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

72 posts views Thread by E. Robert Tisdale | last post: by
121 posts views Thread by typingcat | last post: by
28 posts views Thread by Madhur | last post: by
13 posts views Thread by Jason Huang | last post: by
669 posts views Thread by Xah Lee | last post: by
3 posts views Thread by Siong.Ong | last post: by
16 posts views Thread by John Doe | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.