How to clear MySQL screen console in Windows?

Mysql Problem Overview

The title is my question. I googled and try something like

mysql> !\ clear
mysql> !\ cls
mysql> system cls
mysql> system clear 

blah blah ...

but none of them works.

Anyone show me how to clear screen, just like cls command in Windows?

Mysql Solutions

Solution 1 - Mysql

I don't think Any of the commands will work.

In Linux Ctrl+L will do the job. In Windows there is no equivalent. You can only exit MySQL console by executing quit, execute cls and then re-enter MySQL console.

Solution 2 - Mysql

This is not possible on Windows.

There is an open bug for this issue: Bug #58680: Windows Clear Screen Command

Solution 3 - Mysql

mysql> 
root@xion:~# mysql -uroot -ppassword;
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 33291
Server version: 5.0.51a-3ubuntu5.4 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> \! clear

Solution 4 - Mysql

You are typing the command wrong. It is \ before ! and not after.

The command Ctrl+L will not work for Windows. To clear MySQL console screen, type the following command:

mysql> \! cls

Explanation:

\! is used to execute system shell commands
cls is a command to clear the Windows command prompt screen

This will do the job for Windows.

Similarly if you are on Linux, you will type Ctrl+L or the following:

mysql> \! clear

Source: https://dev.mysql.com/doc/refman/8.0/en/mysql-commands.html

Solution 5 - Mysql

Just scroll down with your mouse

In Linux Ctrl+L will do but if your scroll up you will see the old commands

So I would suggest scrolling down in windows using mouse

Solution 6 - Mysql

On linux : you can use ctrl + L or type command system clear.

Solution 7 - Mysql

although there is bug for clearing the screen in MySQL, I have found one tactic trick whatever you want to say...

you can easily clear the screen using this...

just press ( ctrl + down arrow ) until you reach to top... happy codding...

Solution 8 - Mysql

This is what I did to get around this bug. The windows console (cmd) is just not worth using for anything other than some simple commands. So the following is what I did.

Installed Cygwin (Go here) It is pretty straight forward to install. You can watch this video. It explains very easily how to install cygwin. Make sure when you select the packages that you want to install includes Mintt (it is basically a better shell or cmd) and mysql client package.

Once you are done installing it, you should add the bin folder from cygwin in your PATH Environmental Variables(The above video explains that as well)

Now You will have an icon on the desktop for cygwin. Open it up and login to mysql using the normal commands. You will need to put the ip of the mysql server in the command to make it work. I use the following logging in MySQL which was installed through wamp

mysql -u root -p -h 127.0.0.1

You can add more arguments in there if you want. Once you get in mysql just press ctrl + L and you will clear the screen.

Solution 9 - Mysql

I had the same issue, and CTRL+L worked for me on Windows 10.

Solution 10 - Mysql

mysql console can cleared out on windows by using shortcut key

CTRL + L

Solution 11 - Mysql

just type \system cls

took me a couple hours to get it jejej

Solution 12 - Mysql

Well, if you installed MySql Server e.g. Version 5.5. which has it's folder located in:

> C:\Program Files\MySQL\MySQL Server 5.5\bin

The best way would be to include it in your paths.

First run sysdm.cpl applet from run i.e. WinKey + R
Navigate to Advanced -> Environment Variables
Select PATH and Click Edit.
Scroll to the end of the text, and add ";C:\Program Files\MySQL\MySQL Server 5.5\bin" without quotes (Notice the semicolon starting the text, this should only be added if it's not already there),

Now you can just call:

> start /b /wait mysql -u root -p

via command prompt.

To clear the screen now, you can just exit in mysql & call cls

Kinda trickish hack but does the job.

If you're using WAMP or other tool, it's even easier!

Open command prompt and type:

> C:\wamp\mysql\bin\mysql -u root -p

Enter as normal, then whenever you want to clear screen, do:

> exit or quit

And then clear using DOS:

> cls

You can easily re-enter by pressing up twice to get your mysql call command

Solution 13 - Mysql

you can type the following step:

mysql> exit;

C:\xampp\mysql\bin> cls

C:\xampp\mysql\bin> mysql -u root -h localhost

it's work!

Solution 14 - Mysql

I handle it as follows:

Right click on cmd open property's goto layout
Set screen buffer height to 9999 and ok
Now whenever you want to type a new query, just scroll with the mouse and you will get a blank screen

Solution 15 - Mysql

SQL> clear scr

This command clears the screen in MYSQL

Solution 16 - Mysql

Unfortunately in Windows, It is not possible. The only way out is to exit and type cls and then again open mySQL

Solution 17 - Mysql

It worked for me using this:

clear screen

Solution 18 - Mysql

The bug on Windows which most people are talking is probably fixed. Ctrl + L is works for clearing the screen on Windows 10 [Mysql 8]

Solution 19 - Mysql

For windows user just type system cls;

Note don't forgot to add semicolon ; at the last.

Solution 20 - Mysql

MySql Command Line Client:

>Clear screen feature is support from v5.6

We're using cls in cmd to clear the screen.
MySql command line client accepts the same command with either system or \! flag. > >Both commands listed below are valid!

> > system cls > > > \! cls >

> No need to add any semicolons after the system commands
>Other commands can be found here for MySql Command Line Client
>Change the version number form the top right corner on the website.

Solution 21 - Mysql

Open Properties by clicking the upper left console window icon, go to Layout tab, take note of the value set in Screen Buffer Size->Height, and change it to 1. Click OK.
You'll see a 1 row console. Open Properties again and change that value back to what it had before. Resize the console down and you'll have a clean console.

Solution 22 - Mysql

For windows command prompt

Use

system cls

Solution 23 - Mysql

Fixed in 8.0.19.

Previously, the system (!) command for the mysql command-line client worked only for Unix and Unix-like systems. It now works on Windows as well. For example, system cls or ! cls may be used to clear the screen.

Solution 24 - Mysql

I used the command line client prompt and to clear the screen I typed:-

system cls

Solution 25 - Mysql

For Window 10

Use the command system cls and this will clear the MYSQL Command Line window in Windows

Solution 26 - Mysql

Click with contextMenu button on Mysql prompt and choose "Scroll", because I didn't find any way to clean too. =P

Content Type	Original Author	Original Content on Stackoverflow
Question	Leo Lerdorf	View Question on Stackoverflow
Solution 1 - Mysql	user915331	View Answer on Stackoverflow
Solution 2 - Mysql	dogbane	View Answer on Stackoverflow
Solution 3 - Mysql	Milind Morey	View Answer on Stackoverflow
Solution 4 - Mysql	yogeshwar	View Answer on Stackoverflow
Solution 5 - Mysql	jafaritaqi	View Answer on Stackoverflow
Solution 6 - Mysql	Niket Thada	View Answer on Stackoverflow
Solution 7 - Mysql	kunal doidya	View Answer on Stackoverflow
Solution 8 - Mysql	user3047717	View Answer on Stackoverflow
Solution 9 - Mysql	dzoneuser	View Answer on Stackoverflow
Solution 10 - Mysql	CHAITTNYA SHINDE	View Answer on Stackoverflow
Solution 11 - Mysql	Melolailo	View Answer on Stackoverflow
Solution 12 - Mysql	Chibueze Opata	View Answer on Stackoverflow
Solution 13 - Mysql	edrianhadinata	View Answer on Stackoverflow
Solution 14 - Mysql	Akash	View Answer on Stackoverflow
Solution 15 - Mysql	Deepa Madiwalar	View Answer on Stackoverflow
Solution 16 - Mysql	Pratiik Priyadarsan	View Answer on Stackoverflow
Solution 17 - Mysql	LFer	View Answer on Stackoverflow
Solution 18 - Mysql	saonnet	View Answer on Stackoverflow
Solution 19 - Mysql	Neeraj Tangariya	View Answer on Stackoverflow
Solution 20 - Mysql	Piyush Pranjal	View Answer on Stackoverflow
Solution 21 - Mysql	Ivan Ferrer Villa	View Answer on Stackoverflow
Solution 22 - Mysql	Chowdary	View Answer on Stackoverflow
Solution 23 - Mysql	mXrio	View Answer on Stackoverflow
Solution 24 - Mysql	Shivam Sourav Jha	View Answer on Stackoverflow
Solution 25 - Mysql	Rohit Chaurasiya	View Answer on Stackoverflow
Solution 26 - Mysql	lebzra	View Answer on Stackoverflow