connect.result 1.42 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 12
Tables_in_mysql
columns_priv
db
func
help_category
help_keyword
help_relation
help_topic
host
proc
13
procs_priv
14 15 16 17 18 19 20
tables_priv
time_zone
time_zone_leap_second
time_zone_name
time_zone_transition
time_zone_transition_type
user
21
show tables;
22
Tables_in_test
23 24 25
grant ALL on *.* to test@localhost identified by "gambling";
grant ALL on *.* to test@127.0.0.1 identified by "gambling";
show tables;
26 27 28 29 30 31 32 33 34 35
Tables_in_mysql
columns_priv
db
func
help_category
help_keyword
help_relation
help_topic
host
proc
36
procs_priv
37 38 39 40 41 42 43
tables_priv
time_zone
time_zone_leap_second
time_zone_name
time_zone_transition
time_zone_transition_type
user
44
show tables;
45
Tables_in_test
46
update mysql.user set password=old_password("gambling2") where user=_binary"test";
47
flush privileges;
unknown's avatar
unknown committed
48
set password="";
49 50
set password='gambling3';
ERROR HY000: Password hash should be a 41-digit hexadecimal number
51
set password=old_password('gambling3');
52
show tables;
53 54 55 56 57 58 59 60 61 62
Tables_in_mysql
columns_priv
db
func
help_category
help_keyword
help_relation
help_topic
host
proc
63
procs_priv
64 65 66 67 68 69 70
tables_priv
time_zone
time_zone_leap_second
time_zone_name
time_zone_transition
time_zone_transition_type
user
71
show tables;
72
Tables_in_test
73
delete from mysql.user where user=_binary"test";
74
flush privileges;
75 76 77 78
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
79
drop table t1;