Alex: I doubt this issue is a 'general mysql-nt problem'. In truth, MySQL is a very well-designed, well-behaved service.
I have installed about 80 MySQL servers on customer-owned WinNT/2K servers. If this were a 'general mysql-nt problem', I would have had to set a login account in the SCM for each one. To the best of my recollection, I have only had to do it twice in a little more than two years. I tend to think it has something to do with permissions on the machine or perhaps a general configuration setting in WinNT/2K, but I can't prove/disprove that. Miguel Solorzano is a MySQL full-timer with a good deal of experience in this area ... he reads the list, and may be able to offer some insight here. Gerald Jensen -----Original Message----- From: Alexander Hampel [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 9:05 AM To: [EMAIL PROTECTED] Cc: Gerald Jensen; [EMAIL PROTECTED] Subject: Finally found mysql-nt service error 1061 1067 Hi Gerald, The 'System-Account' did not work BUT the 'Admin' user account did! You were right :-) How comes? That's what I always do: (1) Install a service on 'System Account' and than (2) change it to an user account of my choice After 2 days wasting time trying to get the installation run, I ask myself how things like this can happen? Seems to be a 'general mysql-nt problem' if I take a look at how many questions arise to this specific issue. Anyway - thanks to all of you helping me by giving me advices :-) Special thanks to you Gerald, so long A:lex >-----Ursprungliche Nachricht----- >Von: Gerald Jensen [mailto:[EMAIL PROTECTED]] >Gesendet: Montag, 18. Marz 2002 15:13 >An: [EMAIL PROTECTED] >Betreff: Re: NT service problem > > >Then you may have a problem with services running under the System Account >on this machine. > >Try this: >- Go into the Control Panel's Service Control Manager >- Click on the MySQL service >- Click on the 'Startup' button >- Make sure 'Automatic' is selected >- Select 'This Account' (instead of 'System Account') >- Choose an Admin-level user and set the correct password >- Click 'OK' then click 'Start' > >Gerald Jensen > >----- Original Message ----- >From: "Alexander Hampel" <[EMAIL PROTECTED]> >To: "Gerald R. Jensen" <[EMAIL PROTECTED]> >Sent: Monday, March 18, 2002 7:45 AM >Subject: AW: NT service problem > > >> Thanks - my.ini is used. >> Tried to use come of your parameters - but nothing changed. >> The interesting part: the standalone run is fine, the service >> part is wrong -> so it has something todo with the service ?!? >> >> So long A:lex >> >> >> >> >-----Ursprungliche Nachricht----- >> >Von: Gerald R. Jensen [mailto:[EMAIL PROTECTED]] >> >Gesendet: Montag, 18. Marz 2002 13:40 >> >An: [EMAIL PROTECTED]; [EMAIL PROTECTED] >> >Betreff: Re: NT service problem >> > >> > >> >Check the location of the configuration file (should be either c:\my.cnf >~ >> >OR ~ c:\winnt\my.ini), then edit the contents of that file. Here is a >> >sample: >> > >> >[client] >> >#password=my_password >> >port=3306 >> >#socket=MYSQL >> ># >> >[mysqld] >> >port=3306 >> >#socket=MYSQL >> >skip-locking >> >#enable-locking >> >set-variable = key_buffer=16M >> >set-variable = max_allowed_packet=1M >> >set-variable = thread_stack=128K >> >set-variable = flush_time=1800 >> >log=C:/mysql/mysql.log >> >basedir = C:/MYSQL/ >> ># >> >[mysqldump] >> >quick >> >set-variable = max_allowed_packet=16M >> ># >> >[MYSQL] >> >no-auto-rehash >> ># >> >[isamchk] >> >set-variable= KEY=16M >> ># >> >[client_fltk] >> >help_file= C:\\MYSQL\guiclient\MYSQL.help >> >client_file= C:\\MYSQL\mysql.opt >> >history_length=20 >> >database = goetznet >> >queries_root= C:\\MYSQL\queries >> >last_database_file= C:\\MYSQL\lastdb >> > >> > >> > >> >----- Original Message ----- >> >From: "Alexander Hampel" <[EMAIL PROTECTED]> >> >To: <[EMAIL PROTECTED]> >> >Sent: Monday, March 18, 2002 1:37 AM >> >Subject: NT service problem >> > >> > >> >Hi Pierre, >> > >> >Thanks, for your help. >> >That's what I exaclty do and this is for '--standalone' fine. >> >But the point ist, I want to start mysqld-nt as NT service - >> >and this is the problem - it wouldn't let me start it as service: >> >>C:\>net start mysql >> >>System error 1069 >> >>Could not start service >> > >> >The service is an important issue. Lets you run a programm under >> >different user rights. >> > >> >Probably I'll find some other solution. >> > >> >Thanks, >> > A:lex >> > >> > >> > >> >>-----Ursprungliche Nachricht----- >> >>Von: Pierre du Parte [mailto:[EMAIL PROTECTED]] >> >>Gesendet: Montag, 18. Marz 2002 08:04 >> >>An: [EMAIL PROTECTED] >> >>Cc: [EMAIL PROTECTED] >> >>Betreff: Re: New to MySQL - can't start server :-( >> >> >> >> >> >>Hi Alexander, >> >>I use the PHPDEV compilation for local PHP/mySQL development work >> >>(http://www.firepages.com.au/devindex.htm for a no-brainer approach to >> >>getting PHP/mySQL/Apache up and running in seconds!) >> >> >> >>Anyway, for me >> >> >> >>start c:\phpdev\mysql\bin\mysqld-nt.exe --standalone >> >> >> >>kicks mySQL off on Win2K, NT and XP very nicely, thank you :) >> >> >> >>If your mySQL is in c:\ then >> >> >> >>start c:\mysql\bin\mysqld-nt.exe --standalone >> >> >> >>should work >> >> >> >>But I could be wrong, I often am.... >> >> >> >> >> >>Pierre >> >> >> >> >> >> >> >> >> >> >> >>Alexander Hampel wrote: >> >> >> >>> Hi mailing list, >> >>> >> >>> I can't start mysqld-nt as I get the eror message 1067. If I start >> >>> winmysqladmin.exe there is no server visible. >> >>> >> >>> The manual tell me in part 2.4 Post-installation Setup and >> >Testing that I >> >>> should start the script ./scripts/mysql_install_db but this >> >script is not >> >>> availabale (at all) at my Windows distribution. >> >>> >> >>> Any ideas what's wrong? >> >>> >> >>> >> >>> Thank you, >> >>> A:lex >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> >> >>> --------------------------------------------------------------------- >> >>> Before posting, please check: >> >>> http://www.mysql.com/manual.php (the manual) >> >>> http://lists.mysql.com/ (the list archive) >> >>> >> >>> To request this thread, e-mail <[EMAIL PROTECTED]> >> >>> To unsubscribe, e-mail >> >>> <[EMAIL PROTECTED]> >> >>> Trouble unsubscribing? Try: >http://lists.mysql.com/php/unsubscribe.php >> >>> >> >>> >> >>> >> >>> --------------------------------------------------------------------- >> >>> Before posting, please check: >> >>> http://www.mysql.com/manual.php (the manual) >> >>> http://lists.mysql.com/ (the list archive) >> >>> >> >>> To request this thread, e-mail <[EMAIL PROTECTED]> >> >>> To unsubscribe, e-mail >> >><[EMAIL PROTECTED]> >> >>> Trouble unsubscribing? Try: >http://lists.mysql.com/php/unsubscribe.php >> >>> >> >>> >> >>> >> >>> >> >> >> >> >> >>-- >> >>Pierre du Parte >> >>Final Filer Software >> >>349 Worrigee Road >> >>Worrigee, NSW, Australia 2540 >> >>http://www.finalfiler.com >> >> >> >>Phone 61 2 44216374 >> >>Mobile 0413 483 066 >> >> >> >>"If it feels good, do it!" >> >> >> >> >> >>--------------------------------------------------------------------- >> >>Before posting, please check: >> >> http://www.mysql.com/manual.php (the manual) >> >> http://lists.mysql.com/ (the list archive) >> >> >> >>To request this thread, e-mail <[EMAIL PROTECTED]> >> >>To unsubscribe, e-mail >> >><[EMAIL PROTECTED]> >> >>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >> >> >> > >> > >> > >> >--------------------------------------------------------------------- >> >Before posting, please check: >> > http://www.mysql.com/manual.php (the manual) >> > http://lists.mysql.com/ (the list archive) >> > >> >To request this thread, e-mail <[EMAIL PROTECTED]> >> >To unsubscribe, e-mail >> ><[EMAIL PROTECTED]> >> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >> > >> > >> > >> > >> >> >> >> > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
