2.6.2.2 Запуск MySQL на Windows NT, 2000 или XP

Для того чтобы MySQL работал с TCP/IP на Windows NT 4, необходимо установить Service Pack 3 (или выше)!

Обычно MySQL устанавливается на Windows NT/2000/XP как сервис. В случае, если сервер уже работает, необходимо сначала завершить его работу при помощи следующей команды:

C:\mysql\bin> mysqladmin -u root shutdown

Это вызов программы администрирования MySQL от имени пользователя root, который по умолчанию соответствует пользователю Administrator в системе привилегий MySQL. Обратите внимание: система привилегий MySQL абсолютно независима от каких-либо аккаунтов пользователей в системе Windows.

Теперь установим сервис сервера:

C:\mysql\bin> mysqld-max-nt --install

Если требуются какие-либо опции, они должны быть определены, как ``Start parameters'' в инструментальной программе Services системы Windows перед запуском сервиса MySQL.

Доступ к инструментальной программе Services (Windows Service Control Manager) можно получить в Control Panel (в Administrative Tools в Windows 2000). Рекомендуется закрывать Services при выполнении операций --instal или --remove - это предотвратит возникновение некоторых ошибок неизвестной природы.

За информацией о том, какие бинарные файлы следует использовать для запуска сервера, обращайтесь к разделу See section 2.1.2.2 Подготовка конфигурации MySQL для Windows.

Отметим, что начиная с версии 3.23.44 MySQL имеется возможность альтернативной установки сервиса - в режиме Manual (если вам не требуется автоматический запуск сервиса при загрузке операционной системы):

C:\mysql\bin> mysqld-max-nt --install-manual

Сервис устанавливается под именем MySQL. Сразу же после установки он может быть запущен при помощи инструментальной программы Services или командой NET START MySQL.

После запуска работа mysqld-max-nt может быть завершена при помощи mysqladmin из инструментальной программы Services или командой NET STOP MySQL.

Если MySQL функционирует в качестве сервиса, то операционная система автоматически завершает работу MySQL-сервиса при программном завершении работы компьютера. В версиях MySQL < 3.23.47 Windows ожидает всего лишь несколько секунд завершения остановки, после чего уничтожает процесс сервера базы данных, если превышено время ожидания (что может быть потенциальной причиной возникновения проблем). Например, при следующем запуске обработчик таблицы InnoDB должен выполнять восстановление после аварийного завершения. Начиная с MySQL версии 3.23.48, Windows ожидает завершения процесса MySQL-сервера дольше. Если вы считаете, что этого времени для вашей версии недостаточно, безопаснее запускать MySQL-сервер не как сервис, а из командной строки и завершать его работу командой mysqladmin shutdown.

В Windows NT (но не в Windows 2000/XP) существует проблема, которая заключается в том, что система по умолчанию ожидает окончания работы сервиса только 20 секунд, после чего уничтожает процесс сервиса. Это заданное по умолчанию значение можно увеличить с помощью редактора Registry (Реестра), запустив `\winnt\system32\regedt32.exe' и отредактировав значение WaitToKillServiceTimeout в записи HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control. Следует задать другое, большее значение в миллисекундах, например 120000, чтобы Windows NT ожидала 120 секунд.

Необходимо заметить, что при работе в качестве сервиса mysqld-max-nt не имеет доступа к консоли, а следовательно, невозможно увидеть его сообщения. Информация об ошибках находится в файле `c:\mysql\data\mysql.err'.

Если вы столкнулись с проблемами установки mysqld-max-nt в качестве сервиса, попробуйте запустить его с указанием полного пути:

C:\> C:\mysql\bin\mysqld-max-nt --install

Если это не поможет, можно принудить mysqld-max-nt стартовать соответствующим образом, исправив путь в Registry!

Если вы не хотите запускать mysqld-max-nt в качестве сервиса, его можно запустить следующим образом:

C:\> C:\mysql\bin\mysqld-max-nt --standalone
или
C:\> C:\mysql\bin\mysqld --standalone --debug

В случае последнего варианта вы получите отладочную информацию в `C:\mysqld.trace'. See section E.1.2 Создание трассировочных файлов.

User Comments

well,i could use mysql api normally with vc6,but
i could not use it in borland c++ builder 5,i add
libmysql.lib,mysqlclient.lib,but compiler told
me "[Linker
Error] 'C:\MYSQL\LIB\DEBUG\MYSQLCLIENT.LIB'
contains invalid OMF record, type 0x21 (possibly
COFF)",:) is there somebody could help me out?i
am a newbie so i even didn't know what the DMF's
meaning,thanks for reading this.

I too had the 1067 error. I wanted to have mysql
installed on my E: drive (my OS, WinXP, resides on
the C:\ drive, but I wanted all my web server stuff
to be on E:\ ). After seeing that I couldn't get the
service to start, I tried creating a my.ini file and
sticking it in C:\Windows, but this didn't solve the
problem. To correct it, I uninstalled mysql as a
service, uninstalled mysql as a program and deleted
the my.ini file. I then reinstalled the mysql program.
Re-created the my.ini file, and then installed mysql
as a service (in that order). It seems to have taken
care of the problem.

"HOW I FIXED THE 10061 error on XP: the easy way.
I installed mysql on my new win XP laptop, and
then went to the command line and tried to run it
and got ERROR 2003: can't connect to MySQL server
on 'localhost' How I fixed it: I ran
winmysqladmin.exe to see if it would work, and it
asked me to choose a username and password to
create my.ini. Interestingly, before this, I had
searched for my.ini and couldn't find it). So I
entered a username and password (made them up),
and hit OK, and it closed. Then I ran
winmysqladmin again, and it worked. Then I ran
mysql from the command line and it worked. "

I am having the same error 2003 problem with
NT...will the XP solution work on NT as well?

The answer is to install in c:\mysql (the default
location) installing in c:\program files\mysql
(where we'd like to put it) seems to result in
the error 1067 problem, although having said that
I have managed to install it in program files on
one machine without any problems (although I
can't remember how I fixed it)

If the service fails to start under Windows NT
then the chances are you have installed the mySQL
server into a different directory than the
default. (e.g. c:\program files\mySQL)

If this is the case you need to do two things:
1. create a c:\winnt\my.ini file which details
where the mySQL apps & data resides (see help
elsewhere)
2. copy the "mysql" subdirectory from the
~\mysql\data directory to where you have
specified the data will reside.

Always find and read the mysql.err file - it
should tell you what is going wrong :-)

I had the exact same problem.

Suddenly I was unable to start the MySQL service.

I retraced my actions and the only thing I had
done was to launch WinMySQLadmin.

I looked at the my.ini located in C:\winnt and
realized that it only contained an entry for
WinMySQLadmin.

It seemed as if WinMySQLadmin had overwritten my
regular configuration.

I looked at c:\ where a backup of my.cnf
(my_cnf.bak) is kept, added the contents to
c:\winnt\my.ini and everything worked again.

Hope it helps...

I was also having problems getting mySQL to start
on my windows 2000 Professional system. Then the
last comment in the list, by Peter Schumacher
made me realize that I had started the
WinmySQLadmin and that created a my.ini that was
interfering with starting mySQL. I just deleted
the my.ini file entirely and I was able to start
mySQL with no problems. Deleting the file may
not be the best way to go, but it worked for me.
BTW, I'm a complete newbie to all of this. I
have never worked with anything but Access. If I
can figure it out, anyone can!!!

Sean Porter is totally right. Just delete the
my.ini file from the WINNT folder and MySQL is
running.

I have also had problems getting mySQL to start.
I can't install on c:\mySQL due to size limits.
installing on d:\program files\mySQL will not
qork (i get an error 193(not a valid NT
application)) I assumed it was the space so tried
putting d:\progra~1\mySQL into the my.cfg file to
no avail. I was able to get it up and running
when installed on d:/mySQL if configured using
c:\winnt\my.ini. I got an error 1067 if I put
the same file as c:\my.cfg.

How I fixed my 1067 error on Win2K: I have not
installed mysql in the default directory, and when
I started it as a service I had the dreaded 1067
error, even though I had set the basedir and
datadir options in the C:\my.cnf file. I turned
out what I thought was my.cnf was instead
my.cnf.cnf. My Win2K install associates .cnf with
SpeedDial, and Explorer hides the .cnf, even
though I've turned off the option 'Do not show
hidden files and folders'. So when I copied
my-medium.cnf to C:\ I added .cnf to the one I
didn't see. Once I removed the extra one it worked
fine. (doing a DIR on the file shows the
extension, though).

PS: starting mysqld with no options still doesn't
work. It should start mysqld as a service but
instead I get the 1067 error. Debugging mysqld
shows that the call to
StartServiceCtrlDispatcher() returns
ERROR_FAILED_SERVICE_CONTROLLER_CONNECT, which
means "The service process could not connect to
the service controller", for whatever reason
(starting it from the service controller works fine).

Well, for Windows XP users, we cannot start
mySQL the conventional way like what we used to
do in Windows 2000 or previous NT versions
(\mysql\bin\mysqld-nt.exe --install). The only
solution I could give is to run
WinMySQLAdmin.exe. It will run the daemon mysqld-
nt as a service. Hope this helps.

I just installed it on XP pro. as a service
(c:\mysql\bin\mysqld-max-nt --install) no
problems
encountered. running mysql-3.23.47-win

I have installed mysql-3.23.47 on XP. If I try
to intall the service through mysqld-nt --
install or mysqld-max-nt --install, MySql
service gets intalled but still gives the error
(1067) when I start the service. As mentioned in
previous comments to remove my.ini file doesn't
work or making any changes to my.ini do any
effects. Also, after starting mysqld, when I try
to do mysql, I get the error "ERROR 2003: Can't
connect to MySQL server on 'localhost'
(10061)". I do not get ERROR 2003 only if I do
mysqld-max-nt --standalone.

Well, I've installed MySQL on about 20 W2K ADV
Servers, and have not had one problem.. wait,
no, I lie.

On a few of the servers I wanted to use mysql-max-
nt instead of mysql-nt(default)and had to play
with the my.ini to correct it.. then had to
totally unload the server. Then I had to close
winmysqladmin. When I reopened it, it restarted
the server, used the modified my.ini, and worked
fine.

All other installs have functioned just fine. If
there are problems on your W2K installation, I
suggest you check the policy settings for local
policies, or check the domain policies if you are
part of a domain.

This worked for me on Windows 2000.
Create an my.ini in c:\WINNT
Add the following contents, assuming you
installed into c:\mysql

[mysqld]
basedir=c:/mysql
datadir=c:/mysql/data

save and restart and hopefully all should be fine)

This may seem very obvious to some, but I have
previously installed on Windows XP Professional,
and have just installed on Windows XP Home, and
didn't at first realize that when I renamed a
file to my.ini or my.cnf, since I had not turned
off "Hide known file extensions", I was actually
renaming it to my.ini.txt and my.cnf.txt. Once
I turned off "Hide known file extensions", I
could NET START MYSQL and it worked perfectly
(before it was giving me error 1067).

About the terrible ERROR 1067 in Windows XP :)

Your my.ini file should contain this:

[mysqld]
basedir=C:/yourInstallDir/mysql
datadir=C:/yourDataDir/data

[WinMySQLAdmin]
Server=C:/yourInstallDir/mysql/bin/mysqld-nt.exe

Be careful with the slashes!
Now you can start mysql service from Services
window.
Everything works perfectly with my XP.

I'm running mysqld-max-nt on WinXP using InnoDB
tables. I'm running version 4.0.1. I was
running into the 1067 error as a
service too. This only happened if my log files
were on a different system. What I did to fix
the problem was the following...
1. In the my.ini file, I changed the path to the
log files from using a mapped drive letter to
using UNC. (\\server\\user\\path...)
2. In the Services Control Panel, I changed to
logon from the system to a domain user for the
share I'm keeping the logs on.
I hope this helps someone out there. It may just
be a special case, but I discovered it by playing
around for a few hours.

MySQL is not as cryptic as you might be first
led to believe. When it reports error 1067,
etc... just visit the mysql.err file in your
data folder (see your my.ini or my.cnf file for
this location). This is where MySQL puts error
messages so you can figure out what is wrong.
In the case of code 1067, basically it is
complaining that it can't find the mysql
database. MySQL stores user grant tables and
other administrative information in
database "mysql". So most likely what you have
done is set your data path to be other than the
default c:\mysql\data. In order to do this, you
also need to copy the contents of c:\mysql\data
to the non-default location you have specified
in your my.ini or my.cnf file.

I definitely think this should be stated more
clearly in the manual for specifying a non-
default data directory. This problem happened
to me as well. C drive? what is that in Windows
XP? the darn OS decided it was installing
itself on G drive and I had no say so. doh.

Re: 1067 error after having started
winmysqladmin, check for existence of c\:my.cnf,
if not present restore using my_cnf.bak worked
for me also.

Running Version 3.23.39 as SERVICE on W2K
Advanced Server and got error 1067. Problem
solved by adding group SYSTEM with "read &
Exec..", "List Fold.." and "Read" rights to the
under datadir= specified directory. (Everyone
works too but it's not what I am after)

I had trouble with setting up the service and
the standalone server on Windows XP. The issue
seems to me to be a bug in mysql with comments
on the same line as data in the configuration
file.

I wrote this and it didn't work:

datadir=f:/mysql/data # don't include
comments here.

I corrected the statement by removing the
comment:

datadir=f:/mysql/data

Then everything started working for me.

For everyone with problem 1067:
If you want to have your MySQL in C:\Program
Files\MySQL add following line to \WinNT\my.ini
(after copy it from examples):
[mysqld]
basedir=C:/Program Files/MySQL/
^^^^^ Remember about slashes.
After it service should be working:
bin/mysqld-max-nt --install
net start mysql

HOW I FIXED THE 10061 error on XP: the easy way.

I installed mysql on my new win XP laptop, and
then went to the command line and tried to run
it and got

ERROR 2003: can't connect to MySQL server
on 'localhost'

How I fixed it:

I ran winmysqladmin.exe to see if it would work,
and it asked me to choose a username and
password to create my.ini. Interestingly, before
this, I had searched for my.ini and couldn't
find it).

So I entered a username and password (made them
up), and hit OK, and it closed. Then I ran
winmysqladmin again, and it worked. Then I ran
mysql from the command line and it worked.

Windows 2000 (and possibly NT/XP):
Mysqld-nt.exe service start parameters disappear
when you close the service property dialog.
Solution 1: Manual service start
Solution 2: No start parameters
The preferred solution would be if the
service 'remember' start parameters by saving
them in registry or something.

All the above hits about changing the my.ini and
forward slashes verus backward slahes were
absolutely execellent. I have MySQL running under
program files and the data directory on another
partition (D:).

Thanks!


my.ini file under C:\WinNT
[mysqld]
basedir = c:/Program Files/MySQL
datadir = d:/MySQL/data

skip-innodb

[client_fltk]
help_file= c:/Program
Files/mysql/sql_client/MySQL.help
client_file= c:/Program
Files/mysql/MySQL.options
history_length=20
database = test
queries_root= c:/Program Files/mysql/queries
last_database_file= c:/Program
Files/mysql/lastdb

[WinMySQLAdmin]
Server = C:/Program Files/MySQL/bin/mysqld-max-
nt.exe

Just a note about a strange occurrence in case
anyone else experiences this:
winmysqladmin on W2K caused the mysql service to
freeze on non-admin user accounts. Strangely
enough, a quick port check shows the mysql as
active and listening but no connections can be
made EXCEPT when you are logged in as admin. For
the non-admin accounts on this machine, even
though the port check looks OK, if you go to the
services console it will show the service as
stopped, and you will not be able to start it
(and winmysqladmin will ask if you want to
install the service). Upon removing
winmysqladmin from startup (all users) the MySQL
service functioned normally for ALL user accounts
on this machine.

About the "System error 1067 has occurred" with
Windows OS and install in "non-standard" folder
(other than c:\mysql)
A good idee : Look on the C:\ Root and open the
"NULL" fille. There is all informations when MySQL
does not start correctly : error 1067
A regular error is "The system cannot find the
specified folder"
I thinks that's a good tips
Lionel

I wasted so many hours and hundred of curses before finally getting mysqld-max-nt.exe up running without the infamous 1067 System error for Windows 2000, whoever screwed up the my-[size].cnf files in <installDir> is deserved to be lynched for being deceitful, the innodb parameters setting between Win?? and NT/2000 may be different. The innodb parameters was updated on my Windows 2000 to:

innodb_data_file_path = /ibdata1:300M:autoextend<CR>

innodb_data_home_dir = c:/ibdata <CR>

innodb_log_group_home_dir = c:/iblogs <CR>

innodb_log_arch_dir = c:/iblogs <CR>.

Before my updates, the parameters in the default .cnf files were using c:\ibdata and so on, it may be tested on Win98 etc., but they are not acceptable for W2K. (I haven't tested other possible combinations, there may be other options that will work also)

It may be best to use comments and separate sections for different platforms even within the mysql-max-[version]-win.zip. Hope this will save future first time users of mysql some valuable time and frustrations.

Concerning "Error 1067" while attempting to start
the MySQL service previously installed through
the <code>mysqld-nt-max --install</code>
command on Windows
NT/2000:

I experienced this error myself on my first installation
of MySQL, v3.23.52. In my case, I chose to install
MySQL to a particular folder on my
drive (<code>C:/Dev/MySQL323</code>) instead
of the standard location
(<code>C:/MySQL</code>). I then created a
simple
<code>C:/WINNT/MY.INI</code> config file, tried
to start the service and got a 1067 error. After a bit
of troubleshooting I eventually traced the cause of
this error -- I simply forgot to specify
the MySQL base directory through the
<code>basedir</code> key in the
<code>C:/WINNT/my.ini</code>
config file. This setting is mandatory if you install
MySQL to a folder other than the default
(<code>C:/MySQL</code>). In this case you also
have to specify the data directory through the
<code>datadir</code> key

Below is a copy of the (correct) bare bones config
file I use
(<code>c:/winnt/my.ini</code>) --
it only contains the minimal set of entries to get
you going. Note that I am using the "Max" version of
MySQL since I want transaction support, and
therefore I also have to enable support for InnoDB
tables. To achieve this, the documentation says you
only need to specify the
<code>innodb_data_file_path</code> key;
However I found that in addition to setting this, you
also must specify the
<code>innodb_data_home_dir</code> key:

<code>
[mysqld]
basedir = C:/Dev/MySQL323
datadir = C:/Dev/MySQL323/data
innodb_data_home_dir =
C:/Dev/MySQL323/data
innodb_data_file_path =
ibdata1:16M:autoextend

[WinMySQLAdmin]
Server =
C:/Dev/MySQL323/bin/mysqld-max-nt.exe

</code>
Hope this may help some of you out there !!

Instalei o mysql em uma rede interna com vАrias
mАquinas, de diferentes Sistemas operacionais,
administrado por um servidor Win 2000. A
instalaГЦo И simples, como em Win 98. Para iniciar o
servidor, basta executar o arquivo MYSQLD-
NT.EXE. Agora, se quiser que o prСprio
adminstrador WINMYSQLADMIN selecione o melhor
servidor windows, basta executar o mesmo, e
pronto.

: O Mysql И legal, mas entender sua lСgica И um
pouco complicado. Todas as complicaГУes eu
enfrentei, como todos, e superei. Se alguИm tiver
dЗvidas, fique Ю vontade em entrar em contato
comigo. Terei prazer em ajudar.

Help me solve this ERROR?

"The procedure entry point Create
Toolhelp32Snapshot could not be locaded in the
dynammic link library KERNEL32DLL"

What a h...is this.
The error accures when i click on winmysqladmin. I
have no my.ini and no my.cnf and its not installed as
an service.
I maked a Typicall Install.
I have used MySql for several years whitout errors
before. Hlp, I need somebodys help?

On XP when I was trying to start the service from
the services window, it would not start. Upon doing
a properties on the service the information gleened
told me XP thought that the exe lived at: C:\mysqld-
max-nt and not in the directory I had placed it in. By
copying the exe to the root of c:\ it worked. Note I
have my XP environment with a path to the bin
directory of mysql.

I had same problem about
CreateToolhelp32Snapshot Function and i had found
this documentation:

CreateToolhelp32Snapshot Function

Declare Function CreateToolhelp32Snapshot
Lib "kernel32.dll" (ByVal dwFlags As Long, ByVal
th32ProcessID As Long) As Long

Platforms

Windows 95: Supported.
Windows 98: Supported.
Windows NT: Not Supported.
Windows 2000: Supported.
Windows CE: Not Supported.



DAMN !!!!!!!
it's always M$ & WINBUG !

The CreateToolhelp32Snapshot problem with
winmysqladmin.exe.
Using the MS-Tool DEPENDS.EXE on a system
running WinNT4.0 SP6a it can be seen that at least
the latest mySQL-build 3.23.53
contains a version of WinMySqlAdmin.exe which has
external references to
- CreateToolhelp32Snapshot
- Process32First
- Process32Next
in kernel32.dll, which cannot be resolved on
WinNT4.0 SP6a!

Testing the same with my currently installed mySQL-
version 3.23.47, these external references are
missing.
So that version runs fine on WinNT4.0!
On the Microsoft support page
http://support.microsoft.com/default.aspx?
scid=KB;en-us;q175030
one can read in section
"Using the ToolHelp32 Library to Enumerate
Processes"
that these API-calls are NOT supported on Windows
NT 4.0!
So I will try to inform the mySQL-developers...

How I fixed my 1067 error on Win2K: I tried all sorts


- reinstalling, upgrading, Service Pack 3, and so on


and so on. I could get it to run as a standalone but


not as a service. When trying to run as a service the


error message I got was "Error 1058: The service


cannot be started, either because it is disabled or


because it has no enabled devices associated with


it.". Finally found out that this could be fixed by the


following (from somewhere else):-





On Windows 2000:


Rightmouse click on the My Computer icon on the


Windows Desktop.


Click on Manage(which brings up the Computer


Management information).


Double click on Services and applications.


Double click on Services.


Double click on the MySql icon.


If the Startup Type shows Disabled, change it to be


either Manual or Automatic.


Click on the Startbutton.


If you get the same error, then try the following


steps:


On Windows 2000, in the same Windows 2000


Services area described earlier:


Double click the MySql icon.


Click the Log On tab.


Verify that the service has not been disabled for the


hardware profile that you're using. If it has, single


click on it, click the Enable button, and then click the


Apply button.


Click the General tab.


Click the Start button.


(Probably obvious if you know about this stuff - but I
didn't!)

System 1067 error. I wanted to have mysql
installed on my D: drive (my OS, Win2000, resides on
the C:\ drive. After seeing that I couldn't get the
service to start, I tried creating a my.ini file and
sticking it in C:\Winnt, but this didn't solve the
problem. To correct it, I uninstalled mysql as a
service, uninstalled mysql as a program and deleted
the my.ini file. Re-created the my.ini file in Winnt.
Reinstalled the mysql program. Then installed mysql
as a service (in that order). It corrected all the
problems that I was having.

After having my onw error 1067 problem and reading other comments on this page, I have come to the conclusion that starting WinMySQLAdmin BEFORE getting the service running is what screws up so many people. In the installation instructions is says something like: "If you are using WinMySQLAdmin this is done automatically, so you can skip the next sections" This makes people think "Hey, I can just start this WinAdmin thing and not have to worry about configuring it manually." So, in brief: IGNORE what the manual says about WinMySQLAdmin, and get MySQL running from the command line first!

Had the Error 1067 on Win2K Pro.
It was InnoDb settings. Seems to me that the only way is to let the innodb_data_home_dir setting empty.
This solved the problem:
# innodb_data_home_dir = D:/mysql/ibdata
innodb_data_home_dir =
innodb_data_file_path = /ibdata1:64M:autoextend
innodb_log_group_home_dir = D:/mysql/iblogs
innodb_log_arch_dir = D:/mysql/iblogs
So MySQL runs also outside C:\mysql.
Be sure to read the mysql.err to solve operation problems.

I had an error (1067) on Win XP when I installed it on my D: drive. My way of fixing: Don't use winmysqladmin.exe! I just create a my.ini file (c:\windows\my.ini) with this content:
[mysqld]
basedir=D:/mysql
datadir=D:/mysql/data

I am php developer and just installed Windows XP Professional. I got stuck when I tried to install mysql. Thanks to the users posts here I got it to work by this 'formula'.
1. Installed mysql under c:\program files\mysql
2. Opened command prompt and typed in the following
"C:\program files\mysql\bin\mysqld-max-nt" --install
3. Edited my.ini under c:\windows and typed in the following:
[mysqld]
basedir=C:/program files/mysql/
datadir=C:/program files/mysql/data/
4. Ran services under control panel and started mysql.

Hope this will help!

For everyone on Win 2000 with problem 1067:
I discovered that the path statements MUST be correct.
A simple C:\WINNT\My.ini file should read something like this:
[mysqld]
basedir=D:(or C,E,F)/Program Files/mysql
datadir=D:(or C,E,F)/Program Files/mysql/data

[WinMySQLAdmin]
Server=D:/Program Files/MYSQL/bin/mysqld-nt.exe

If you want to use the command line with this path, go to \progra~1\mysql\bin. Lines 4 & 5 are added automatically by running winmysqladmin from the .../bin directory.

Hi,
I had the error 1067 error whilst installing mysql to another directory on WINDOWS NT service pack 6 as a service.

I created a my.ini file in the c:\winnt directory and put my basedir & datadir in. At first this still didn't work until I came across the simple reason I had left this top line out. one this was in the sevice started no problems.

[mysqld] ***This line is important to the ini file and cost me a few hours and grey hairs realising that it was needed***

basedir = C:/Dev/MySQL323
datadir = C:/Dev/MySQL323/data

Thanks to Jim Dam's posting, his fix worked for me!
I'm running Windows 2000 Professional and currently learning myPHPAdmin and MySQL. In my case, I'm toying with PHP_Triad which is bundled free package that provides mySQL and PHPadmin so I can test on my box. It didn't put my.ini file so following Jim's posting, it worked. My only change was to direct to c:/apache/mysql instead.

Thanks!
S
***************************************
This worked for me on Windows 2000.
Create an my.ini in c:\WINNT
Add the following contents, assuming you
installed into c:\mysql

[mysqld]
basedir=c:/mysql
datadir=c:/mysql/data

save and restart and hopefully all should be fine)

Posted by Jim Dam on Saturday February 2 2002, @6:51pm
***********************************************

Add your own comment.