nixCraft

MySQL clear history file ~/.mysql_history

This is a discussion on MySQL clear history file ~/.mysql_history within the Databases servers forums, part of the Mastering Servers category; How do I clear mysql database server command history stored in ~/.mysql_history file?...

		nixCraft Linux Forum > Mastering Servers > Databases servers
MySQL clear history file ~/.mysql_history

Linux answers from nixCraft.

Forgotten your password?

Mark Forums Read

Databases servers Discussions of databases of all types - especially MySQL.

LinkBack

Thread Tools

Display Modes

#1 (permalink)

29-07-2007, 05:35 AM

raj

Senior Member

User

Join Date: Jun 2005

Location: Hyderabad

OS: Fedora, Debian Linux

Posts: 307

Thanks: 42

Thanked 8 Times in 8 Posts

Rep Power: 6

MySQL clear history file ~/.mysql_history

How do I clear mysql database server command history stored in ~/.mysql_history file?

__________________
Raj
Linux rulz.
I have never turned back in my life ; I shall not do so today.. haha

Sponsored Links

#2 (permalink)

16-04-2008, 09:55 AM

agn

Member

User

Join Date: Feb 2008

OS: OpenBSD/FreeBSD/Debian/Fedora/RHEL

Posts: 69

Thanks: 0

Thanked 0 Times in 0 Posts

Rep Power: 3

Code:

cat /dev/null > ~/.mysql_history

or if you don't want mysql to log the queries you can set $MYSQL_HISTFILE to /dev/null.

« Tutorial: Setting up MySQL quotas for users (MyISAM) | Configuration of Sybase(ASE 15.0.2) Server »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
bash history...suse 10.1	grogf	Linux software	4	30-10-2007 04:42 PM
Confusion Pl. Clear it for me	kasimani	Linux software	2	25-10-2006 11:38 PM
How to save history of a hung terminal	ricc	Linux software	2	20-06-2006 12:21 AM
Command history	ricc	Linux software	1	26-04-2006 04:57 PM
shortcut linux command history		Shell scripting	1	26-12-2005 06:22 PM

All times are GMT +5.5. The time now is 11:45 PM.

nixCraft

MySQL clear history file ~/.mysql_history

MySQL clear history file ~/.mysql_history

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads