473,403 Members | 2,293 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,403 software developers and data experts.

Re[2]: Can run two versions of MySQL in Windows 2000?


jumping in to try and solve some problems that look pretty obvious to
me ...
#options for default service (mysqld2)
It should be [mysqld2], not (mysqld2).
basedir = c:\4.1 Alpha\mysql
As Paul pointed out, the blank in the path name is likely to cause
problems (see below).
my-opts2.cnf: [mysqld2]
basedir = c:\4.1 Alpha\mysql
Again, don't use a path that contains blanks.
socket = mypipe2
As opposed to Unix, Windows doesn't know the concept of "sockets" (it
uses "named pipes" instead). Named pipes, however, might cause
problems with MySQL under Windows, so it's recommended not to use
them, but rather use tcp/ip instead (that is why named pipes are
disabled by default). You don't have to specify anything to use tcp/ip
-- it's the default under Windows. (The above line in your
configuration file is syntactically okay, but I'd recommend to delete
it for the mentioned reasons. For MySQL 4.1, that should be
"protocol=mypipe2", anyway.)
mysqld --defaults-file=C:\my-opts1.cnf
response: mysqld: ERROR: unknown option '--enable-named-pipe'
For the above given reasons, you shouldn't use named pipes. Get rid of
the appropriate lines in your configuration files, and you'll get rid
of that problem.
030723 15:09:02 Error message file 'C:\mysql\share\english\errmsg.sys'
had only 237 error messages, but it should contain at least 255 error
messages. Check that the above file is the right version for this
program! 030723 15:09:02 when I invoke it from the folder of the old
version. and:
mysqld-max: Can't change dir to 'C:\4.1 Alpha\mysql\data\' (Errcode:2)
Well, that error message says it, doesn't it? Avoid having blanks in
your pathnames.
Okay, that looks good. When you open the Services Manager, I assume
it shows lines for services named "MySQL" and "mysqld2" and that they
both have a status showing them to be running? (Sorry, the "Services Manager"? I'm not sure what that is.)
On Windows 2000, you can open the Services Manager window as follows:

Start > Settings > Control Panel > Administration > Services

In that window you see a list of Windows services, and you should find
two MySQL-related services running.
But when I attempt to invoke MySQL the response is: "ERROR 2003: Can't
connect to MySQL server on 'localhost' (10061)" Okay. What was the command you used here? (just the same as before: "mysql" or "mysql -h localhost -u root" What happens if you use this command: mysql -h localhost -P 3308 or this one: mysql -h . -S mypipe2 (both give the following response: ERROR 2003: Can't connect to MySQL
server on 'localhost' (10061), and I tried several Ports, 3308, 3307,
3306, and 3309 in this order)
All that means that the MySQL server you are trying to connect to
isn't running. You can check in the Services Manager window, now that
you know how to find that :)
(BTW. When I came in today I found out that I could no longer connect
to 4.1.0 either. When I left last night, I could connect to 4.1.0, but
could no longer connect to 4.0.13. According to windows explorer the
database files are still there, but for some reason mySQL can no longer
point to them.)

Once again, check in the Services Manager window and make sure the
MySQL servers are actually running. I can only guess, but it looks as
though they are not started at system startup (Start type: automatic).
net stop svc-name-1
net stop svc-name-2 To remove them: mysqld --remove svc-name-1
mysqld --remove svc-name-2 Then start from the beginning, using the mysqld --install instructions
in the manual. (So I don't have to "Uninstall" them in windows since they are now
services? Or does this have the same effect?)

I'd suggest you to get familiar with the Windows services concept.
Services are, uh, services that can start and stop software programs
(like the MySQL server). Rather than starting the software manually,
you'd set up a service that does that (and can do that automatically,
e.g. at system startup).

Windows (NT, 2000, XP) usually uses services to start software that
runs in the background, like the MySQL server.

Unlike software, you don't uninstall a service, you _remove_ it, so it
won't be there anymore to start the software program it's supposed to
start. For the MySQL server, that's done with the "mysqld --remove
<servicename>" command.

Hope that helps.

Stefan Hinz <hi**@iConnect.de>
iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3

[filter fodder: sql, mysql, query]
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 2869

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: MBS | last post by:
I know there are already a million threads on php vs asp.net. My prior experience is with asp but I am now doing a website for a company that has given me free reign over which technology I want to...
by: Penn Markham | last post by:
Hello all, I am writing a script where I need to use the system() function to call htpasswd. I can do this just fine on the command line...works great (see attached file, test.php). When my...
by: miguel solórzano | last post by:
At 14:47 24/7/2003 +0200, Stefan Hinz wrote: Hi, > > (I think I messed up here. I decided to start from scratch, I removed > > "MySQL Servers and Clients 4.0.13" from the program list (as it...
by: DrUg13 | last post by:
In java, this seems so easy. You need a new object Object test = new Object() gives me exactly what I want. could someone please help me understand the different ways to do the same thing in...
by: baustin75 | last post by:
Posted: Mon Oct 03, 2005 1:41 pm Post subject: cannot mail() in ie only when debugging in php designer 2005 -------------------------------------------------------------------------------- ...
by: NewToPython | last post by:
I am going to build an application for a small business that may be able to be used at other businesses. I am trying to decide which route to go in building the application - which will require...
by: Mike | last post by:
Open source programs in general suck pretty bad also. Here are some loose facts regarding why projects like Linux, PHP, MYSQL, and other open source programs suck: - Linux is simply a clone of...
by: MP | last post by:
I'm interested to learn how to use mdb files via ado/adox via vb6 Since I'm not using Access are those types of questions o.t. here? I see very few ado questions here. But there's a lot more...
by: Mell via AccessMonster.com | last post by:
I created databases on Access 2003 and I want to deploy them to users. My code was also done using 2003. If they have Ms Access 2000 or higher, will they be able to use these dbs with all code,...
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
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...
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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...
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...
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,...
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...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

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.