Degan,
jumping in to try and solve some problems that look pretty obvious to
me ... #options for default service (mysqld2) (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=mypip e2", 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\dat a\' (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.
Regards,
--
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 0 2890 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 use. I am
developing an online product catalogue with shopping cart etc. Here is
a partial wish list.
1)As mentioned, a shopping cart.
2)A database search feature (to search multiple fields and phrase
occurences within).
3)An admin page for...
|
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 webserver runs that part of the
script (see attached file, snippet.php), though, it doesn't go through.
I don't get an error message or anything...it just returns a "1"
(whereas it should return a "0") as far as I can tell. I have read the
PHP...
|
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 appears
> > when I run the "setup.exe" it installs MySQL software in Windows) and
> > deleted all the folders (which included the old "c:\mysql\" directory
> > with mysqld in the \bin folder) before performing the remove
> > instructions below. So...
|
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 C++. I find my self sometimes, trying
Object app = Object();
Object *app = Object();
Object app = new Object();
|
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
--------------------------------------------------------------------------------
Hello,
I have a very simple problem but cannot seem to figure it out. I have a
very simple php script that sends a test email to myself. When I debug
it in PHP designer, it works with no problems, I get the test email. If
| |
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
persistent data storage (a database). I am between VBA in an Access
database and VB/VC/or Java with a MySQL database. Obviously with the
second option I would have to install a DBMS on the target PC, create
the database, then deploy the app...
|
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 an operating system over 20 years
old similar to DOS (Unix). That's ALL Linux is. The kernal was taken,
decompiled, and stolen by Linus himself. That's a fact. Xerox
should have sued, but at the during the early 1991, no one was
really using Unix...
|
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 traffic here than
the ado groups.
:-)
Thanks
Mark
|
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, etc?
Please explain
--
Message posted via http://www.accessmonster.com
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |