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]
