connect.result 2.98 KB
Newer Older
unknown's avatar
unknown committed
1
drop table if exists t1,t2;
2
show tables;
3 4 5 6 7 8 9 10 11
Tables_in_mysql
columns_priv
db
func
help_category
help_keyword
help_relation
help_topic
host
12
plugin
13
proc
14
procs_priv
15 16 17 18 19 20 21
tables_priv
time_zone
time_zone_leap_second
time_zone_name
time_zone_transition
time_zone_transition_type
user
22
show tables;
23
Tables_in_test
24
connect(localhost,root,z,test2,MASTER_PORT,MYSQL_TEST_DIR/var/tmp/master.sock);
unknown's avatar
unknown committed
25
ERROR 28000: Access denied for user 'root'@'localhost' (using password: YES)
26
connect(localhost,root,z,test,MASTER_PORT,MYSQL_TEST_DIR/var/tmp/master.sock);
unknown's avatar
unknown committed
27
ERROR 28000: Access denied for user 'root'@'localhost' (using password: YES)
28 29 30
grant ALL on *.* to test@localhost identified by "gambling";
grant ALL on *.* to test@127.0.0.1 identified by "gambling";
show tables;
31 32 33 34 35 36 37 38 39
Tables_in_mysql
columns_priv
db
func
help_category
help_keyword
help_relation
help_topic
host
40
plugin
41
proc
42
procs_priv
43 44 45 46 47 48 49
tables_priv
time_zone
time_zone_leap_second
time_zone_name
time_zone_transition
time_zone_transition_type
user
50
show tables;
51
Tables_in_test
52
connect(localhost,test,,test2,MASTER_PORT,MYSQL_TEST_DIR/var/tmp/master.sock);
unknown's avatar
unknown committed
53
ERROR 28000: Access denied for user 'test'@'localhost' (using password: NO)
54
connect(localhost,test,,"",MASTER_PORT,MYSQL_TEST_DIR/var/tmp/master.sock);
unknown's avatar
unknown committed
55
ERROR 28000: Access denied for user 'test'@'localhost' (using password: NO)
56
connect(localhost,test,zorro,test2,MASTER_PORT,MYSQL_TEST_DIR/var/tmp/master.sock);
unknown's avatar
unknown committed
57
ERROR 28000: Access denied for user 'test'@'localhost' (using password: YES)
58
connect(localhost,test,zorro,test,MASTER_PORT,MYSQL_TEST_DIR/var/tmp/master.sock);
unknown's avatar
unknown committed
59
ERROR 28000: Access denied for user 'test'@'localhost' (using password: YES)
60
update mysql.user set password=old_password("gambling2") where user=_binary"test";
61
flush privileges;
unknown's avatar
unknown committed
62
set password="";
63 64
set password='gambling3';
ERROR HY000: Password hash should be a 41-digit hexadecimal number
65
set password=old_password('gambling3');
66
show tables;
67 68 69 70 71 72 73 74 75
Tables_in_mysql
columns_priv
db
func
help_category
help_keyword
help_relation
help_topic
host
76
plugin
77
proc
78
procs_priv
79 80 81 82 83 84 85
tables_priv
time_zone
time_zone_leap_second
time_zone_name
time_zone_transition
time_zone_transition_type
user
86
show tables;
87
Tables_in_test
88
connect(localhost,test,,test2,MASTER_PORT,MYSQL_TEST_DIR/var/tmp/master.sock);
unknown's avatar
unknown committed
89
ERROR 28000: Access denied for user 'test'@'localhost' (using password: NO)
90
connect(localhost,test,,test,MASTER_PORT,MYSQL_TEST_DIR/var/tmp/master.sock);
unknown's avatar
unknown committed
91
ERROR 28000: Access denied for user 'test'@'localhost' (using password: NO)
92
connect(localhost,test,zorro,test2,MASTER_PORT,MYSQL_TEST_DIR/var/tmp/master.sock);
unknown's avatar
unknown committed
93
ERROR 28000: Access denied for user 'test'@'localhost' (using password: YES)
94
connect(localhost,test,zorro,test,MASTER_PORT,MYSQL_TEST_DIR/var/tmp/master.sock);
unknown's avatar
unknown committed
95
ERROR 28000: Access denied for user 'test'@'localhost' (using password: YES)
96
delete from mysql.user where user=_binary"test";
97
flush privileges;
98 99 100 101
create table t1 (id integer not null auto_increment primary key);
create temporary table t2(id integer not null auto_increment primary key);
set @id := 1;
delete from t1 where id like @id;
unknown's avatar
unknown committed
102
drop table t1;