Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "how to close mysql_history files". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

This file records the statement generated by mysql-client, which is a "histroy file".

The file defaults to .mysql _ history and is stored in ~ / .mysql _ history

In older versions, such as MySQL 5.5:

Statements including "IDENTIFIED BY", "SET PASSWORD" and so on will be recorded to the "histroy file", which is extremely unsafe.

These password-related statements will not be log in MySQL 5.6 and later versions.

If you need to turn it off, you can change the user's MYSQL_HISTFILE environment variable to / dev/null, or establish a soft connection:

one

Export MYSQL_HISTFILE=/dev/null

And add it to ~ / .bashrc

two

Rm $HOME/.mysql_history

Ln-s / dev/null $HOME/.mysql_history

If you need to open it, you only need to reset MYSQL_HISTFILE:

Like export MYSQL_HISTFILE=~/.mysql_history.

That's all for "how to close the mysql_history File". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.