Hi All,
I've just migrated from mysql-3.12 to 4.0.1 and despite a mysqld crash a
few minutes ago there is a strange problem I've never had in mysql
version 3:
mysql> lock table .develop.Pseq read;
ERROR 1064: You have an error in your SQL syntax near '.Pseq read' at
line 1
Any idea what's wrong here?
thanks a lot for help,
Arne
user name is 'bmm', here's the ysql table:
mysql> select * from user where user = 'bmm' and Host = 'localhost';
+-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| 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 |
+-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
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 |
+----------------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
mysql> select * from host where Host = 'localhost';
+-----------+----+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| Host | Db | Select_priv | Insert_priv | Update_priv | Delete_priv
| Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv |
Alter_priv |
+-----------+----+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| localhost | % | Y | Y | Y | Y
| Y | Y | Y | Y | Y |
Y |
+-----------+----+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
--
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
