Installing MySQL on Microsoft Windows Using a
noinstall
Zip Archive
82
mysqld: ready for connections
Version: '5.0.96' socket: '' port: 3306
The server continues to write to the console any further diagnostic output it produces. You can open a
new console window in which to run client programs.
If you omit the
--console
[404]
option, the server writes diagnostic output to the error log in the
data directory (
C:\Program Files\MySQL\MySQL Server 5.0\data
by default). The error log is
the file with the
.err
extension.
Note
The accounts that are listed in the MySQL grant tables initially have no
passwords. After starting the server, you should set up passwords for them
using the instructions in
Section 2.18, “Postinstallation Setup and Testing”
.
2.10.4.5. Starting MySQL from the Windows Command Line
The MySQL server can be started manually from the command line. This can be done on any version
of Windows.
To start the
mysqld
server from the command line, you should start a console window (or “DOS
window”) and enter this command:
shell>
"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld"
The path to
mysqld
may vary depending on the install location of MySQL on your system.
You can stop the MySQL server by executing this command:
shell>
"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqladmin" -u root shutdown
Note
If the MySQL
root
user account has a password, you need to invoke
mysqladmin
with the
-p
option and supply the password when prompted.
This command invokes the MySQL administrative utility
mysqladmin
to connect to the server
and tell it to shut down. The command connects as the MySQL
root
user, which is the default
administrative account in the MySQL grant system. Note that users in the MySQL grant system are
wholly independent from any login users under Windows.
If
mysqld
doesn't start, check the error log to see whether the server wrote any messages there to
indicate the cause of the problem. The error log is located in the
C:\Program Files\MySQL\MySQL
Server 5.0\data
directory. It is the file with a suffix of
.err
. You can also try to start the server as
mysqld --console
; 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 the
--standalone
[421]
and
--debug
[405]
options. In
this case,
mysqld
writes a log file
C:\mysqld.trace
that should contain the reason why
mysqld
doesn't start. See
MySQL Internals: Porting to Other Systems
.
Use
mysqld --verbose --help
to display all the options that
mysqld
supports.
2.10.4.6. Customizing the PATH for MySQL Tools
To make it easier to invoke MySQL programs, you can add the path name of the MySQL
bin
directory
to your Windows system
PATH
environment variable:
• On the Windows desktop, right-click the My Computer icon, and select Properties.
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...