Hi All,
Mysql-4.0.1-alpha crashes when updating privileges.
mysql> select * from user where user = 'bmm';
+----------------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host | User | Password | Select_priv | Insert_priv |
Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv |
Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv
| Index_priv | Alter_priv |
+----------------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| localhost | bmm | 006d987861784d38 | N | N |
N | N | N | N | Y |
N | Y | Y | N | N
| N | N |
| %.lif.icnet.uk | bmm | 006d987861784d38 | N | N |
N | N | N | N | Y |
N | Y | Y | N | N
| N | N |
| %.mimcluster | bmm | 006d987861784d38 | N | N |
N | N | N | N | Y |
N | N | N | N | N
| N | N |
+----------------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
3 rows in set (0.00 sec)
mysql> update user set Select_priv='Y' where User = 'bmm';
Query OK, 3 rows affected (0.01 sec)
Rows matched: 3 Changed: 3 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
THEN FROM A CLIENT ...
mueller@holly:~> mysql -u bmm -p -h acacia develop
Enter password:
ERROR 2013: Lost connection to MySQL server during query
... and the server crahsed.
This is mys system:
Linux version 2.4.9-13 ([EMAIL PROTECTED]) (gcc
version 2.96 20000731 (Red Hat Linux 7.1 2.96-98))
I wonder whether other people have come across this problem, too. If you
want I can (try) investigate the problem further, but maybe someone
elese has already done this ... ;-)
Arne
--
Arne Mueller
Biomolecular Modelling Laboratory
Imperial Cancer Research Fund
44 Lincoln's Inn Fields
London WC2A 3PX, U.K.
phone : +44-(0)207 2693405 | fax :+44-(0)207-269-3534
email : [EMAIL PROTECTED] | http://www.bmm.icnet.uk
---------------------------------------------------------------------
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
