Murdoch Mactaggart , The WINDOWS Environment needs the --console switch in order to output the return of mysqld to DOS commands. Please ref to: http://lists.mysql.com/list.php?list=win32#b
my.cnf will never be looked for by the WINDOWS Binary. Return to using my.ini from the C:\%Windows Directory% WinMySqlAdmin is an administration GUI automatically installed in the mysql\bin subdirectory. The 'Control Center', MySQL Control Center, can be downloaded and installed as the Operational GUI. Several Others are available. RE: " I'm somewhat unclear (and can find nothing particular relevant on the site or in the manual) as to whether MySQL functions merely as an engine or whether there is an associated UI. That is, can it be used with ordinary desktop clients and, if so how, or is it intended purely for use through appropriate programmed interfaces?" That depends on your installation. Your options are explained at the MySQL Products WWW Site page. David M Friscia friscia.rootsweb.com <http://friscia.rootsweb.com> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----Original Message----- From: Murdoch Mactaggart [mailto:[EMAIL PROTECTED] Sent: Sunday, June 15, 2003 8:54 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Installation problems with W2K Hi I'm unclear whether the address I'm using here (referenced on page 29 of the manual) is the correct one but I hope one of them may either get me an answer or a reference to where else I might seek help. DETAILS OS: Windows 2000 Professional, 5.0.2195 SP3 build 2195 MySQL version 4.0.13 for Windows, binary (mysql-4.0.13-win.zip) System: self constructed with AMD750MHz Athlon on Biostar M7MKE system board with VIA VT8371 and Award BIOS v6.00PG; 785,904KB RAM; ATI All-in-Wonder Pro video card; part of an Ethernet LAN on a 192.168.1 subnet, connecting to the internet through a Vigor 2000 router using ISDNe. TCP/IP is installed and working. There are two physical HDD, Disc0 of 12.66GB and Disc1 of 12.64GB. These are divided into logical drives C: (Windows, 2.00GB), D: (programs, 3.00GB), E: (Data, 4.00GB), F: (Backup_Store, 3.65GB) [Disc0], G: (Large_Data, 1.95GB) and F: (Recordings, 10.69GB). There is also a DVD drive designated as Z:. All HDDs are formatted as NTFS. PROBLEM The binary download was unzipped to a temporary file and setup run. This appeared to work correctly and the installation was made to D:\Program Files\MySQL with the data directory being set to e:\MySQL\data (and everything from the original ..\data directory moved to there). I then followed the instructions and created a file My.ini containing the installation address and data location addresses and placed this in C:\winnt. I then followed the instructions in the manual at 2.1.2, brought up a DOS box, changed to the ..\bin directory and entered mysqld --standalone. This gave some disc activity, the cursor moved to the next line and nothing else happened. I was unable to move the cursor or to enter anything further but I could close the command line window. Checking showed that the mysqld process had run for one second and could duly be removed. I have: renamed the my.ini file my.cnf and moved it to c:\ reinstalled from the exisitng zip file redownloaded the zipped binaries and reinstalled moved the ..\data directory back to the default (and duly edited the configuration files) getting in each case identical results. If I run mysqld.exe from the Windows desktop then the command window flashes up briefly and nothing further happens. Suggestions, help or pointers elsewhere here would be much appreciated. Secondly, I'm somewhat unclear (and can find nothing particular relevant on the site or in the manual) as to whether MySQL functions merely as an engine or whether there is an associated UI. That is, can it be used with ordinary desktop clients and, if so how, or is it intended purely for use through appropriate programmed interfaces? Thanks in advance.... Regards Murdoch Mactaggart mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]