Hello Tony, Thank you for your note and assistance.
However, I'm stuck on a particular point; I use Win2k Pro; struggling with 3rd option below, 'server-specific options', for multiple instances; MySQL does not see the \mysql\data\my.cnf options file, for some reason it only sees c:\winnt\my.ini and c:\my.cnf. Got this from the manual - 4.1.2; -------------------------------------------------------- Filename Purpose windows-system-directory\my.ini Global options C:\my.cnf Global options C:\mysql\data\my.cnf Server-specic options MySQL tries to read option files in the order listed above. If multiple option files exist, an option specified in a file read later takes precedence over the same option specified in a file read earlier. Options specified on the command line take precedence over options specified in any option file. Some options can be specified using environment variables. Options specified on the command line or in option files take precedence over environment variable values. -------------------------------------------------------- I cannot see where I'm going wrong; is this possibly a version 4.0.1 option. I'm using, 3.23.46-max. I also looked at 4.7.3, cannot figure out where and how to use mysqld# outside the my.cnf options file. Tony, could you please point me? Kind regards Emmanuel --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php