A
A
Alexey Yamschikov2015-11-17 15:20:25
MySQL
Alexey Yamschikov, 2015-11-17 15:20:25

Why is MySQL SELECT query not saved in command history?

Periodically, you need to review the existing users in MySQL on the server.
The request is something like this:
select user,host from mysql.user;
Then when you try to find this request in the command history (up arrow or ctrl + r), it is not there.
But the next one after him
delete from mysql.user where user='test';
is quite present and located.
What the hell?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
W
wol_fi, 2015-11-17
@wol_fi

do not put a space before select?

X
xmoonlight, 2015-11-17
@xmoonlight

Most likely, the current user with truncated rights.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question