MySQL Forums
Forum List  »  Install & Repo

My EASY Solution
Posted by: Dirk Frischalowski
Date: July 25, 2005 08:47AM

A Good Tutorial is the Half Life (not the game).

My Preferences:
- installed as service
- Windows XP SP2
- installed in d:\mysql
- Zone Alarm Running!

1. The new version 4.1.13 puts a my.ini - File in the Installation directory of mysql.
2. When the service starts it uses the command ""D:\mysql\bin\mysqld-nt" --defaults-file="D:\mysql\my.ini" MySQL" - that means he knows where the my.ini-file is.
3. When you use the client over the program Group "MySQL - MySQL Server 4.1 - MySQL Command Line Client" all works fine too - but you are restricted to the ROOT-User.
4. When you try it for your own with mysql -u root ... y failed with a message "ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)" - ROTFLMAO

The Documentation has no hint what to do - not good...

5. The - not told - EASY solution is to copy the my.ini to c:\windows or whatever your Windows-Directory is. Now also the client FINDS !! the my.ini and everything is all right.

6. Another solution is to use the command line "mysql --defaults=file="d:\mysql\my.ini" -u root -p"
Thats the same trick the "MySQL Command Line Client" uses to find the my.ini-File.

Dont forget to use the right user (root is preinstalled) and the right password (i.e. the pass in the configuration wizzard)


WHY NOBODY TELLS US THIS ????? I loose 1 hour to find it out ...

Options: ReplyQuote

Written By
March 16, 2010 11:16PM
June 12, 2009 01:06PM
My EASY Solution
July 25, 2005 08:47AM
January 20, 2006 11:38AM
April 09, 2010 05:07PM
December 09, 2007 06:57AM
January 13, 2010 03:53AM
June 25, 2009 05:58AM
July 15, 2009 02:19PM
July 15, 2009 06:01PM
October 07, 2009 09:41AM
March 14, 2011 06:28AM
December 03, 2009 03:00AM
December 14, 2009 01:14PM
January 04, 2010 03:49AM
March 20, 2010 07:52AM
March 16, 2010 11:08PM
May 10, 2010 06:56PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.