(mysql.info.gz) Windows troubleshooting

Info Catalog

(mysql.info.gz) Windows testing

(mysql.info.gz) Windows installation

(mysql.info.gz) Windows upgrading

 
 2.3.14 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 is preventing 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:\mysql\data'.   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.   Windows start service.
 
 The following are examples of some of the more common error messages
 you may encounter when installing MySQL and starting the server for the
 first time:
 
      System error 1067 has occurred.
      Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
 
 These messages occur when the MySQL server cannot find the `mysql'
 privileges database or other critical files. This error is often
 encountered when the MySQL base or data directories are installed in
 different locations than the default locations (`C:\mysql' and
 `C:\mysql\data', respectively).
 
 If you have installed MySQL to a directory other than `C:\mysql' 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 located at `C:\WinNT' or
 `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:
 
      C:\> echo %WINDIR%
 
 An option file can be created and modified with any text editor, such
 as the Notepad program. For example, if MySQL is installed at
 `E:\mysql' and the data directory is located at `D:\MySQLdata', you can
 create the option file and set up a `[mysqld]' section to specify
 values for the basedir and datadir parameters:
 
      [mysqld]
      # set basedir to your installation path
      basedir=E:/mysql
      # set datadir to the location of your data directory
      datadir=D:/MySQLdata
 
 Note that Windows pathnames are specified in option files using forward
 slashes rather than backslashes. If you do use backslashes, you must
 double them:
 
      [mysqld]
      # set basedir to your installation path
      basedir=C:\\Program Files\\mysql
      # set datadir to the location of your data directory
      datadir=D:\\MySQLdata
 
  Windows create option file.
 

Info Catalog

(mysql.info.gz) Windows testing

(mysql.info.gz) Windows installation

(mysql.info.gz) Windows upgrading