Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to view the mysql command history, the content of the article is carefully selected and edited by the author, with a certain pertinence, for your reference significance is still relatively great, the following with the author to understand how to view the mysql command history bar.

Sometimes, we log in to the database through the mysql connection command on the linux CVM, then run some commands or query sql, and then we press the keyboard up arrow key to list them one by one.

How to view the command history is like looking at the shell command history in shell under linux.

Mysql has such a mechanism that a. MySQL _ history file is generated in the user's home directory, which records every command that the user typed in mysql after logging in to mysql.

Cat ~ / .mysql_history can see the previous command history.

After reading the above command history on how to view mysql, many readers must have some understanding. If you need more industry knowledge and information, you can continue to follow our industry information column.

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.