I second Todd's suggestion. There is no need to run Cygwin in order to have the MySQL servers or clients or any of its tools operating under Win32 (95, 98, 2000, ME, 2003, XP, etc). I only ever use Cygwin when I need to run a remote Linux desktop and as a teaching tool. Everything else I do with MySQL is platform specific. If I am on a *nix platform, I use *nix tools. If I am on Win32, I use Win32 tools. The differences are minimal and the stability is well worth it.
Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Donny Simonton" <[EMAIL PROTECTED]> wrote on 08/30/2004 09:37:26 PM: > Todd, > I don't use Windows XP as a production machine, but I do run MySQL on my > personal machine running Windows XP, I run the Windows version of MySQL. Is > there any reason that you are using Cygwin to run MySQL when you can run the > MySQL windows binaries without any problems? The only thing I can think of > is you are trying to teach them linux as well. > > I know in the MySQL training classes offered by MySQL they are always taught > using Windows 2000 or XP, and they use the standard MySQL windows installer. > > Donny > > > -----Original Message----- > > From: Todd O'Bryan [mailto:[EMAIL PROTECTED] > > Sent: Monday, August 30, 2004 8:09 PM > > To: [EMAIL PROTECTED] > > Subject: Problem running MySQL in high school lab > > > > I'm trying to teach my students how to use MySQL, and have installed it > > on all the lab machines along with Cygwin. Originally, I had the > > permissions set wrong and my students couldn't start the server, but I > > fixed that, and now mysqld& works fine. > > > > Unfortunately, if you then mysql -u root, after a rather short period > > of time, the program crashes and pops an error message to the screen. > > The message, which I should have written down but didn't, says that "an > > assertion has failed in ftell.c" (not sure about the filename, but the > > gist is right) and "stream != NULL" (that I'm sure of) and then the > > program dies. > > > > I don't have similar problems when I'm logged in as me (which has > > Administrator privileges) or the machine Administrator. It must be a > > permissions problem, but I don't know what I need to give the students > > to prevent it. The MySQL stuff on the local machines need not be > > secure, so I've given full access to all users in the entire > > /cygwin/usr/local/ directory and its subdirectories, which is where I > > installed MySQL and all the other packages we're going to be playing > > with. > > > > There are some kids in there who don't need the temptation of being > > logged > > in as an Administrator, and since we're going to be using JDBC later > > for which > > the MySQL server will need to be running almost constantly in the > > background, > > I'd like to get this resolved with the least amount of temptation. > > > > The lab is all Windows XP Professional machines, and the students log > > into a > > domain hosted by a server in another teacher's lab. > > > > Any ideas appreciated, > > Todd > > > > P.S. If you could cc me any replies, I'd appreciate it, since I read > > the list on > > digest. > > > > > > -- > > 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] >
