| 1 |
create user unpriv@localhost; |
| 2 |
set password for unpriv@localhost = 'x'; |
| 3 |
client_id user host sql_session |
| 4 |
1 x_root localhost $SESSION |
| 5 |
command ok |
| 6 |
Got expected error: 'what' is not a valid field for list_clients command (code 5021) |
| 7 |
connecting... |
| 8 |
active session is now 'aux' |
| 9 |
client_id user host sql_session |
| 10 |
1 x_root localhost $SESSION |
| 11 |
2 x_root localhost $SESSION |
| 12 |
command ok |
| 13 |
switched to session default |
| 14 |
client_id user host sql_session |
| 15 |
1 x_root localhost $SESSION |
| 16 |
2 x_root localhost $SESSION |
| 17 |
command ok |
| 18 |
Got expected error: Invalid number of arguments, expected value for 'id' (code 5015) |
| 19 |
|
| 20 |
command ok |
| 21 |
Mysqlx.Notice.Frame { |
| 22 |
type: 1 |
| 23 |
payload: "Mysqlx.Notice.Warning { level: ERROR\ncode: 3169\nmsg: \"Session was killed\"\n }" |
| 24 |
} |
| 25 |
|
| 26 |
Server disconnected |
| 27 |
closing session aux |
| 28 |
switched to session default |
| 29 |
client_id user host sql_session |
| 30 |
1 x_root localhost $SESSION |
| 31 |
command ok |
| 32 |
connecting... |
| 33 |
active session is now 'unpriv' |
| 34 |
Should list unprivs session only |
| 35 |
client_id user host sql_session |
| 36 |
3 unpriv localhost $SESSION |
| 37 |
command ok |
| 38 |
Got expected error: You are not owner of thread (code 1095) |
| 39 |
switched to session default |
| 40 |
client_id user host sql_session |
| 41 |
1 x_root localhost $SESSION |
| 42 |
3 unpriv localhost $SESSION |
| 43 |
command ok |
| 44 |
|
| 45 |
command ok |
| 46 |
Mysqlx.Notice.Frame { |
| 47 |
type: 1 |
| 48 |
payload: "Mysqlx.Notice.Warning { level: ERROR\ncode: 3169\nmsg: \"Session was killed\"\n }" |
| 49 |
} |
| 50 |
|
| 51 |
Server disconnected |
| 52 |
closing session unpriv |
| 53 |
switched to session default |
| 54 |
client_id user host sql_session |
| 55 |
1 x_root localhost $SESSION |
| 56 |
command ok |
| 57 |
Mysqlx.Ok { |
| 58 |
msg: "bye!" |
| 59 |
} |
| 60 |
ok |
| 61 |
drop user unpriv@localhost; |