SpirirHost Support Centre: MySQL Reference Manual p.114

<< previous page -- table of contents -- next page >>

Chapter_1

Chapter_2

Chapter_3

Chapter_4

Chapter_5

Return to Table of Contents

Table of Contents
1. General Information
2. MySQL Installation
3. Tutorial Introduction
4. Database Administration
5. MySQL Optimisation
6. MySQL Language Reference
7. MySQL Table Types
8. MySQL APIs
9. Extending MySQL

114 MySQL Technical Reference for Version 4.0.3 This calls the MySQL administation utility as user `root', which is the default Adminis- trator in the MySQL grant system. Please note that the MySQL grant system is wholly independent from any login users under Windows. Note that Windows 95/98/Me don't support creation of named pipes. So on those platforms, you can only use named pipes to connect to a remote MySQL server running on a Windows NT/2000/XP server host. (The MySQL server must also support named pipes, of course. For example, using mysqld-opt under NT/2000/XP will not allow named pipe connections. You should use either mysqld-nt or mysqld-max-nt.) If mysqld doesn't start, please check the `\mysql\data\mysql.err' le to see if the server wrote any message there to indicate the cause of the problem. You can also try to start the server with mysqld --standalone; in this case, you may get some useful information on the screen that may help solve the problem. The last option is to start mysqld with --standalone --debug. In this case mysqld will write a log le `C:\mysqld.trace' that should contain the reason why mysqld doesn't start. See Section E.1.2 [Making trace les], page 759. Use mysqld --help to display all the options that mysqld understands! 2.6.2.2 Starting MySQL on Windows NT, 2000 or XP To get MySQL to work with TCP/IP on Windows NT 4, you must install service pack 3 (or newer)! Normally you should install MySQL as a service on Windows NT/2000/XP. In case the server was already running, rst stop it using the following command: C:\mysql\bin> mysqladmin -u root shutdown This calls the MySQL administation utility as user `root', which is the default Administrator in the MySQL grant system. Please note that the MySQL grant system is wholly indepen- dent from any login users under Windows. Now install the server service: C:\mysql\bin> mysqld-max-nt --install If any options are required, they must be specied as \Start parameters" in the Windows Services utility before you start the MySQL service. The Services utility (Windows Service Control Manager) can be found in the Windows Control Panel (under Administrative Tools on Windows 2000). It is advisable to close the Services utility while performing the --install or --remove operations, this prevents some odd errors. For information about which server binary to run, see Section 2.1.2.2 [Windows prepare environment], page 67. Please note that from MySQL version 3.23.44, you have the choice of set up the service as Manual instead (if you don't wish the service to be started automatically during the boot process): C:\mysql\bin> mysqld-max-nt --install-manual The service is installed with the name MySQL. Once installed, it can be immediately started from the Services utility, or by using the command NET START MySQL.

MySQL Reference Manual

Home
Hosting Plans \| Domain Registration \| About Us \| Contact Us \| Site Map Terms of Use \| Privacy Policy \| Guarantees Merchant Accounts

SpiritHost - web hosting for spiritual and education sites SpiritHit.com - Religious and Spiritual Portal Copyright © 2002 Dyntex Group, Inc. All Rights Reserved

Return to Table of Contents	Back to top

Web Hosting: Manuals & FAQ's

1. Unix-Based Web Hosting
2. Unix Dedicated Servers
3. Windows Dedicated Servers
4. CuteFTP User’s Guide
5. CuteHTML User’s Guide
6. WS_FTP Pro User's Guide
7. Miva Order User's Guide
8. Miva Merchant User's Guide