Description:
main.grant fails sporadically on windows (win2003-x86) with the following symptoms:
mysqltest: At line 217: query 'GRANT SELECT ON ��.��� TO ����@localhost' failed: 2013: Lost connection to MySQL server during query
The result from queries just before the failure was:
< snip >
ERROR HY000: Operation DROP USER failed for 'drop_user1'@'localhost','drop_user2'@'localhost','drop_user3'@'localhost','drop_user4'@'localhost'
drop table t1;
grant usage on *.* to mysqltest_1@localhost identified by "password";
grant select, update, insert on test.* to mysqltest_1@localhost;
show grants for mysqltest_1@localhost;
Grants for mysqltest_1@localhost
GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost' IDENTIFIED BY PASSWORD '*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19'
GRANT SELECT, INSERT, UPDATE ON `test`.* TO 'mysqltest_1'@'localhost'
drop user mysqltest_1@localhost;
SET NAMES koi8r;
CREATE DATABASE ��;
USE ��;
CREATE TABLE ��� (��� int);
GRANT SELECT ON ��.* TO ����@localhost;
SHOW GRANTS FOR ����@localhost;
Grants for ����@localhost
GRANT USAGE ON *.* TO '����'@'localhost'
GRANT SELECT ON `��`.* TO '����'@'localhost'
REVOKE SELECT ON ��.* FROM ����@localhost;
GRANT SELECT ON ��.��� TO ����@localhost;
How to repeat:
The bug reported after a failure in 6.0-falcon on Mon Sep 29 06:57:33:
http://tinyurl.com/3wc28x
XRef: http://tinyurl.com/4qnpbx