473,406 Members | 2,954 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

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 2214
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

125
by: Sarah Tanembaum | last post by:
Beside its an opensource and supported by community, what's the fundamental differences between PostgreSQL and those high-price commercial database (and some are bloated such as Oracle) from...
72
by: E. Robert Tisdale | last post by:
What makes a good C/C++ programmer? Would you be surprised if I told you that it has almost nothing to do with your knowledge of C or C++? There isn't much difference in productivity, for...
17
by: Paul | last post by:
HI! I get an error with this code. <SCRIPT language="JavaScript"> If (ifp==""){ ifp="default.htm"} //--></SCRIPT> Basicly I want my iframe to have a default page if the user enters in...
121
by: typingcat | last post by:
First of all, I'm an Asian and I need to input Japanese, Korean and so on. I've tried many PHP IDEs today, but almost non of them supported Unicode (UTF-8) file. I've found that the only Unicode...
28
by: Madhur | last post by:
Hello what about this nice way to open a file in single line rather than using if and else. #include<stdio.h> void main() { FILE *nd; clrscr();...
13
by: Jason Huang | last post by:
Hi, Would someone explain the following coding more detail for me? What's the ( ) for? CurrentText = (TextBox)e.Item.Cells.Controls; Thanks. Jason
669
by: Xah Lee | last post by:
in March, i posted a essay “What is Expressiveness in a Computer Language”, archived at: http://xahlee.org/perl-python/what_is_expresiveness.html I was informed then that there is a academic...
3
by: Siong.Ong | last post by:
Dear all, my PHP aims to update a MySQL database by selecting record one by one and modify then save. Here are my PHP, but I found that it doesnt work as it supposed to be, for example, when...
38
by: FAQ server | last post by:
----------------------------------------------------------------------- FAQ Topic - What books cover EcmaScript? ----------------------------------------------------------------------- Most CLJ...
16
by: John Doe | last post by:
Hi, I wrote a small class to enumerate available networks on a smartphone : class CNetwork { public: CNetwork() {}; CNetwork(CString& netName, GUID netguid): _netname(netName),...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectplanning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.