mysql-test/t/empty_user_table.test


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

#
# MDEV-4462 mysqld gets SIGFPE when mysql.user table is empty
#

source include/not_embedded.inc;

create table t1 as select * from mysql.user;
truncate table mysql.user;
flush privileges;

# connecting via unix socket gives ER_ACCESS_DENIED_ERROR
# connecting via tcp/ip gives ER_HOST_NOT_PRIVILEGED
--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT
--error ER_ACCESS_DENIED_ERROR,ER_HOST_NOT_PRIVILEGED
connect (fail,localhost,u1);

insert mysql.user select * from t1;
drop table t1;
flush privileges;