find history of mysql commands on ubuntu
i use mysql on ubuntu.i find all last commands history on terminal by history command but it exclude mysql query or commands.is there any method or command like history to find last mysql queries history on ubuntu
command-line mysql
asked Jul 21 '16 at 14:18
denny
144311
add a comment |
i use mysql on ubuntu.i find all last commands history on terminal by history command but it exclude mysql query or commands.is there any method or command like history to find last mysql queries history on ubuntu
command-line mysql
asked Jul 21 '16 at 14:18
denny
144311
add a comment |
i use mysql on ubuntu.i find all last commands history on terminal by history command but it exclude mysql query or commands.is there any method or command like history to find last mysql queries history on ubuntu
command-line mysql
asked Jul 21 '16 at 14:18
denny
144311
i use mysql on ubuntu.i find all last commands history on terminal by history command but it exclude mysql query or commands.is there any method or command like history to find last mysql queries history on ubuntu
command-line mysql
command-line mysql
asked Jul 21 '16 at 14:18
denny
144311
asked Jul 21 '16 at 14:18
denny
144311
asked Jul 21 '16 at 14:18
denny
144311
asked Jul 21 '16 at 14:18
denny
144311
asked Jul 21 '16 at 14:18
denny
144311
144311
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Those commands go into ~/.mysql_history.
answered Jul 21 '16 at 14:26
Jos
14.1k53849
If you consider my answer acceptable, please click the tick mark next to the question to mark it as "answered".
– Jos
Jul 21 '16 at 14:40
add a comment |
If you logged into mysql CLI with sudo, it might actually be at the following location:
/root/.mysql_history
In any case, the following find command can help you:
sudo find / -name .mysql_history
answered Dec 14 at 17:59
Michael P. Bazos
1011
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f801349%2ffind-history-of-mysql-commands-on-ubuntu%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Those commands go into ~/.mysql_history.
answered Jul 21 '16 at 14:26
Jos
14.1k53849
If you consider my answer acceptable, please click the tick mark next to the question to mark it as "answered".
– Jos
Jul 21 '16 at 14:40
add a comment |
Those commands go into ~/.mysql_history.
answered Jul 21 '16 at 14:26
Jos
14.1k53849
If you consider my answer acceptable, please click the tick mark next to the question to mark it as "answered".
– Jos
Jul 21 '16 at 14:40
add a comment |
Those commands go into ~/.mysql_history.
answered Jul 21 '16 at 14:26
Jos
14.1k53849
Those commands go into ~/.mysql_history.
answered Jul 21 '16 at 14:26
Jos
14.1k53849
answered Jul 21 '16 at 14:26
Jos
14.1k53849
answered Jul 21 '16 at 14:26
Jos
14.1k53849
answered Jul 21 '16 at 14:26
Jos
14.1k53849
14.1k53849
If you consider my answer acceptable, please click the tick mark next to the question to mark it as "answered".
– Jos
Jul 21 '16 at 14:40
add a comment |
If you consider my answer acceptable, please click the tick mark next to the question to mark it as "answered".
– Jos
Jul 21 '16 at 14:40
If you consider my answer acceptable, please click the tick mark next to the question to mark it as "answered".
– Jos
Jul 21 '16 at 14:40
If you consider my answer acceptable, please click the tick mark next to the question to mark it as "answered".
– Jos
Jul 21 '16 at 14:40
add a comment |
If you logged into mysql CLI with sudo, it might actually be at the following location:
/root/.mysql_history
In any case, the following find command can help you:
sudo find / -name .mysql_history
answered Dec 14 at 17:59
Michael P. Bazos
1011
add a comment |
If you logged into mysql CLI with sudo, it might actually be at the following location:
/root/.mysql_history
In any case, the following find command can help you:
sudo find / -name .mysql_history
answered Dec 14 at 17:59
Michael P. Bazos
1011
add a comment |
If you logged into mysql CLI with sudo, it might actually be at the following location:
/root/.mysql_history
In any case, the following find command can help you:
sudo find / -name .mysql_history
answered Dec 14 at 17:59
Michael P. Bazos
1011
If you logged into mysql CLI with sudo, it might actually be at the following location:
/root/.mysql_history
In any case, the following find command can help you:
sudo find / -name .mysql_history
answered Dec 14 at 17:59
Michael P. Bazos
1011
answered Dec 14 at 17:59
Michael P. Bazos
1011
answered Dec 14 at 17:59
Michael P. Bazos
1011
answered Dec 14 at 17:59
Michael P. Bazos
1011
1011
add a comment |
add a comment |
Thanks for contributing an answer to Ask Ubuntu!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f801349%2ffind-history-of-mysql-commands-on-ubuntu%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
