![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_1646196106.webp)
Troubleshooting a MySQL Installation Under Windows
86
If
mysqld
is slow to respond to TCP/IP connections from client programs, there is probably a problem
with your DNS. In this case, start
mysqld
with the
--skip-name-resolve
[420]
option and use
only
localhost
and IP addresses in the
Host
column of the MySQL grant tables.
You can force a MySQL client to use a named-pipe connection rather than TCP/IP by specifying the
--
pipe
[231]
or
--protocol=PIPE
[231]
option, or by specifying
.
(period) as the host name. Use
the
--socket
[232]
option to specify the name of the pipe if you do not want to use the default pipe
name.
Note that if you have set a password for the
root
account, deleted the anonymous account, or created
a new user account, then you must use the appropriate
-u
and
-p
options with the commands shown
above to connect with the MySQL Server. See
Section 4.2.2, “Connecting to the MySQL Server”
.
For more information about
mysqlshow
, see
Section 4.5.6, “
mysqlshow
— Display Database, Table,
and Column Information”
.
2.10.5. Troubleshooting a MySQL Installation Under Windows
When installing and running MySQL for the first time, you may encounter certain errors that prevent the
MySQL server from starting. The purpose of this section is to help you diagnose and correct some of
these errors.
Your first resource when troubleshooting server issues is the error log. The MySQL server uses the
error log to record information relevant to the error that prevents the server from starting. The error log
is located in the data directory specified in your
my.ini
file. The default data directory location is
C:
\Program Files\MySQL\MySQL Server 5.0\data
. See
Section 5.2.1, “The Error Log”
.
Another source of information regarding possible errors is the console messages displayed when
the MySQL service is starting. Use the
NET START MySQL
command from the command line after
installing
mysqld
as a service to see any error messages regarding the starting of the MySQL server
as a service. See
Section 2.10.4.7, “Starting MySQL as a Windows Service”
.
The following examples show other common error messages you may encounter when installing
MySQL and starting the server for the first time:
• If the MySQL server cannot find the
mysql
privileges database or other critical files, you may see
these messages:
System error 1067 has occurred.
Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
These messages often occur when the MySQL base or data directories are installed in different
locations than the default locations (
C:\Program Files\MySQL\MySQL Server 5.0
and
C:
\Program Files\MySQL\MySQL Server 5.0\data
, respectively).
This situation may occur when MySQL is upgraded and installed to a new location, but the
configuration file is not updated to reflect the new location. In addition, there may be old and
new configuration files that conflict. Be sure to delete or rename any old configuration files when
upgrading MySQL.
If you have installed MySQL to a directory other than
C:\Program Files\MySQL\MySQL
Server 5.0
, you need to ensure that the MySQL server is aware of this through the use of a
configuration (
my.ini
) file. The
my.ini
file needs to be located in your Windows directory, typically
C:\WINDOWS
. You can determine its exact location from the value of the
WINDIR
environment
variable by issuing the following command from the command prompt:
shell>
echo %WINDIR%
An option file can be created and modified with any text editor, such as Notepad. For example, if
MySQL is installed in
E:\mysql
and the data directory is
D:\MySQLdata
, you can create the option
file and set up a
[mysqld]
section to specify values for the
basedir
and
datadir
options:
Содержание 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 ...