#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Posts
    1
    Rep Power
    0
    Hi everyone,
    I got a problem installing mySql under Windows NT. I can't start the
    service. It doesn't work with the command line neither with the control
    panel.
    Starting with control panel --> services says: "Couldn't start mySql. The
    process was interrupted"
    Starting with the command line says: "A system error occured. System error
    1067. The process was interrupted"
    Can anyone help me??
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 1999
    Posts
    1
    Rep Power
    0
    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by jayman18:
    Hi everyone,
    I got a problem installing mySql under Windows NT. I can't start the
    service. It doesn't work with the command line neither with the control
    panel.
    Starting with control panel --> services says: "Couldn't start mySql. The
    process was interrupted"
    Starting with the command line says: "A system error occured. System error
    1067. The process was interrupted"
    Can anyone help me??
    [/quote]

    This is a copy of the readme that came with the win32 version mysql. It should answer all of your questions about running as a service under NT. I am running mysql, apachie and php on nt4.0 sp4. Good Luck!

    This is the shareware release of MySQL for Win32.

    Please refer to the file SHAREWARE-LICENSE for information about how you
    can use this MySQL version.

    (In short form; This is an old but complete and pretty stable MySQL
    version that you have the right to use for an evaluation period of 30
    days. MySQL will not in any way force you to register and it will
    continue to work even after the evaluation period. We trust that if
    you find MySQL usefull and start using it 'for real' you will register
    a MySQL-Win32 license. By doing this you will get access to the newest
    MySQL-Win32 version and will get free updates to future MySQL-Win32
    versions)

    The latest information about MySQL can be found at: http://www.tcx.se

    To see what it can do take a look at the features section in the
    manual.

    For future plans see the TODO appendix in the manual.

    New features/bug fixes history is in the news appendix in the manual.

    For the currently known bugs/misfeatures (known errors) see the bugs
    appendix in the manual.

    For examples of SQL and benchmarking information see the bench
    directory.

    The manual mentioned above can be found in the Docs directory. The
    manual is available in the following formats: as text in
    Docs/manual.txt, as HTML in Docs/manual_toc.html, as GNU Info in
    Docs/mysql.info and as PostScript in Docs/manual.ps.

    For a contributed user manual see http://www.turbolift.com/mysql.

    MySQL is brought to you by: Michael (Monty) Widenius at TcX
    DataKonsult AB.

    For the other contributors see the Credits appendix in the manual.

    At http://www.tcx.se/Downloads you can find a port of perl, with
    DBI, DBD-MySQL and DBD-ODBC that works under Win32 against a Win32
    or Unix mysqld server!

    *************************************************************************

    Notes for this version:

    The default version of mysqld (the SQL server) is compiled with full
    debugging and automatic memory allocation checking. You can also use the
    optimized version mysqld-opt, but if you have any problems you should
    try the normal version!

    Starting MySQL (this will start mysqld in the background without a window):

    binmysqld

    or on NT if you don't want to start mysqld as a service:

    binmysqld --standalone

    Killing MySQL:

    binmysqladmin -u root shutdown

    Testing mysql:

    binmysqlshow
    binmysqlshow -u root mysql
    binmysqladmin version status proc
    binmysql test

    On NT mysqld can be installed as a service with:

    binmysqld --install # Install MySQL as a service
    binmysqld --remove # remove MySQL as a service

    Note that in this case you can't use any other options for mysqld!

    You can also run mysqld as a standalone program on NT if you
    start mysqld with any other option! If you start mysqld without options
    on NT, mysqld starts itself with the default service options.

    It is installed with the name "MySql". Once installed it must be
    started using Services Control Manager (SCM) Utility (found in Control
    Panel). If some options are wanted they must be specified as "Startup
    parameters" in the SCM utility before start.
    Once running mysqld can be stopped using mysqladmin or from Services
    Control Manager Utility. In case of stopping from SCM, there is a
    strange message from SCM but mysqld shutdown normally. Running as
    service mysqld has not access at console and so no messages can be
    seen.

    On NT you can get the following service error messages:

    Permission Denied - Means that it cannot find mysqld.exe
    Cannot Register - Means that the path is incorrect

    - You can also use MyODBC or perl to connect to mysqld.

    - This version is configured to be installed in c:mysql. You can in
    install it anywhere, but if you install it at any other location you have
    to tell mysqld where everything is by supplying options to mysqld. Use
    binmysqld --help to print all options!
    If you for example have moved the MySQL distribution to Drogramsmysql
    you have to start mysqld with:
    Drogramsmysqlbinmysqld --basedir Drogramsmysql

    - If you have problems installing mysqld as a service, try starting mysqld
    with the full path: 'C:mysqlbinmysqld --install'.
    If this doesn't work, you can get mysqld to start properly by fixing
    the path in the registry!

    - Most things appears to work nicely on Win32. We use the MySQL
    benchmarks and crash-me to check each version before releasing it.

    - The distributed default MySQL version is compiled with debugging information
    so one can get a trace file with: mysqld --debug. After one has verified
    mysqld works correctly one can switch to the optimized version:
    mysqld-opt.exe

    - There is a leak of about 200 bytes for each MySQL connection on
    Win95 (Not on Win98 or NT). The problem is probably in the Windows95
    kernel.
    This means that one should try to use persistent connections or
    boot the computer once in a while. Actually the above is not fatal as
    one needs about 5000 connection to leak one megabyte.

    - We haven't still solved how we can get signals in threads to break
    connections. This means that a connection will not automaticly be
    disconnected after 8 hours as the Unix version of MySQL.
    This also means that if a connection 'hangs' it's impossible to
    break it without killing MySQL. 'mysqladmin kill' will also not
    work on a sleeping connection and 'mysqladmin shutdown' can't abort
    as long as there are sleeping connections.

    - Normally one should add a password for the 'root' user and take mysqld down
    with:
    mysqladmin --user=root --password=your_password shutdown

    In this case one should remove the entry with host='localhost' and user=''
    from the user database.

    The above is most easly done with:

    shell> mysql mysql
    mysql> delete from user where host='localhost' and user='';
    mysql> quit
    shell> mysqladmin reload
    shell> mysqladmin -u root password your_password

    - As filenames are case insensitive on Win32, database and table names
    are also case insensitive in MySQL for Win32. The only restriction is
    that a table name must match the same case for the whole query:

    SELECT * from table_name where TABLE_NAME.col=1 # This won't work.

    - Directories in Win95 are separated with '' which is also the escape
    character in MySQL. If you are using LOAD DATA INFILE or SELECT INTO
    OUTFILE you have to double the '' or use the unix style filenames '/'
    SELECT * FROM skr INTO OUTFILE 'C:/tmp/skr.txt';
    LOAD DATA INFILE "C:tmpskr.txt" INTO TABLE skr;

    - The distributed MySQL version is compiled with debugging information
    so one can get a trace file with: mysqld --debug.

    - There are two versions of the 'mysql' command line tool; 'mysql', compiled
    on native Win32, which offers very limited text editing capabilities and
    'mysqlc', compiled with the Cygnus gnu compiler and libraries, which offers
    readline editing.

    As mysqlc is from the old MySQL 3.20 release you must start mysqld with:
    binmysqld --old-protocol --port=3333
    if you want to use readline editing. You must also copy libcygwin.dll
    to windowssystem (or similar place).

    - The default permission is that anyone can use any database that
    starts with 'test' from any host and only root can take mysql down:

    mysqladmin -u root shutdown

    - This distribution includes the a prototype of a new GUI tool,
    MySQLManager, by James Pereria. This has still some rough edges,
    but it can serve as a great base for further development!

    - If you get "Access denied" when using 'mysql -u root mysql' try to create
    a file named 'hosts' in the windows folder with the following information:

    127.0.0.1 localhost

    This file should also solve the problem if you have an dialup account
    and your computer tries to dial up every time a mysql client tries to
    connect to the mysql server. You can test that the file is ok by doing
    'ping localhost'; If you get a reply, without a your machine is trying
    to dial up your ISP, your machine is set up correctly.

    If you want to help us develop MySQL for Win95 please mail to
    mysql-win32@tcx.se to get help to set up your environment!

    All questions that are specific to the windows version should be
    posted to this list! Please remember to include all relevant
    information that may help solve your problem. Note that we at TCX
    will not answer any mails for the MySQL shareware version (but there
    are still many users on the above list that can help you if you
    run into trouble).

    Requests to be added or dropped from the mysql-win32 list should be
    sent to the electronic mail address mdomo@tcx.se. Sending a one-line
    message with body text of either "subscribe mysql-win32" or
    "unsubscribe mysql-win32" will suffice. If your reply address is not
    valid, you may use "subscribe mysql-win32 your@address.your-domain" or
    "unsubscribe mysql-win32 your@address.your-domain".

    One behalf of the TcX gang,
    Michael Widenius & David Axmark
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Posts
    1
    Rep Power
    0
    Hello,

    I've been unable to start mysql as a service on NT4, but can get it running as follows...

    <<<
    ..on NT4, and get the same message when typing

    C:>mysqld
    C:>mysqlshow

    "Can't connect to MySQL server on localhost (10061)"

    I don't know the answer - let's hope someone does.
    >>>

    Reason was that after typing "mysqld" - the process was starting and then exiting - you can see it in the Task Manager.

    Solution:

    C:>cd mysqlbin
    C:>mysqld -nt --install

    This gives an error message "mysqld: Can't read dir of '--install' (Errcode2)"

    However, the process still starts ok.

    Then...

    C:>mysql
    mysql>

    ...and you're away!

    not perfect but it works...

    thanks
    john


    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by jayman18:
    Hi everyone,
    I got a problem installing mySql under Windows NT. I can't start the
    service. It doesn't work with the command line neither with the control
    panel.
    Starting with control panel --> services says: "Couldn't start mySql. The
    process was interrupted"
    Starting with the command line says: "A system error occured. System error
    1067. The process was interrupted"
    Can anyone help me??
    [/quote]

Similar Threads

  1. Errcode:13 . How to solve it on MySQL + Windows 2000
    By hankycheng in forum MySQL Help
    Replies: 28
    Last Post: August 3rd, 2003, 11:05 AM
  2. mysql install woes........
    By stankOnIt in forum Beginner Programming
    Replies: 4
    Last Post: February 13th, 2003, 02:01 PM
  3. Can't get php to talk to mysql on install
    By terfle in forum MySQL Help
    Replies: 3
    Last Post: November 23rd, 2002, 06:08 PM
  4. mysql - new install - insert size limit?
    By unreal in forum MySQL Help
    Replies: 2
    Last Post: November 4th, 2002, 11:47 PM

IMN logo majestic logo threadwatch logo seochat tools logo