That's a least what I found out - other new users have the same problem too. The ptoblem resides on WinNT/2K only (at least what I read), so probably you are right, it might be a WinNT/2K specific problem. Anyway, MySQL is a good product - that's what all say. For me, I am happy to be able to use MySQL as a service :-)
So long A:lex >-----Ursprungliche Nachricht----- >Von: Gerald R. Jensen [mailto:[EMAIL PROTECTED]] >Gesendet: Dienstag, 19. Marz 2002 03:02 >An: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] >Cc: [EMAIL PROTECTED]; '[EMAIL PROTECTED]' >Betreff: RE: Finally found mysql-nt service error 1061 1067 > > >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
